Skip to content
Day 69: new resources are added every day. See what's new
Best Productivity ResourcesBy Shushant LakhyaniVerified creator

Desktop App

OpenRefine

Clean up messy data in a spreadsheet-like browser tool.

Visit OpenRefine4.6

  • Rating

    4.6 / 5

  • Pricing

    Free

  • Difficulty

    Intermediate

  • Works on

    macOS, Windows, Linux

Built with love by Shushant Lakhyani. Building bestproductivityresources.com

Free: 1,100+ ways people make money onlineFree: 399+ ways to make money online

What is OpenRefine?

OpenRefine is a free, open-source power tool for working with messy data. It runs on your own computer and you use it in a web browser to load data, understand its structure, clean and transform it, reconcile it and add information from the web. It runs on macOS, Linux and Windows.

Third-party open-source projects. We are not affiliated with their authors; repositories are provided as-is by their maintainers. Review each project's license, code and security before installing. See our Disclaimer.

Pros: what OpenRefine does well

  • Fixes inconsistent entries across thousands of rows
  • Data stays on your computer
  • Works on macOS, Linux and Windows

Cons: where it falls short

  • Takes practice to learn its expressions
  • Not a replacement for a full spreadsheet

Who OpenRefine is for

Researchers, journalists and analysts who deal with untidy spreadsheets.

Who can skip it

People whose data is already clean.

OpenRefine alternatives

Not sold on OpenRefine? These do a similar job, and each card says what it has in common.

All Research resources

VisiData

Focus: data and command line. Shares csv and spreadsheet with OpenRefine. Rated 4.5 (OpenRefine: 4.6).

Desktop AppFreemacOS, Linux
4.5Visit

DBeaver

Focus: database, sql and data. Shares open source and github with OpenRefine. Same 4.6 rating.

Desktop AppFreemacOS, Windows
4.6Visit

Baserow

Focus: database, no-code and self-hosted. Shares spreadsheet and open source with OpenRefine. A no-code tool, not a desktop app. Freemium (OpenRefine: Free). Adds Web. Same 4.6 rating.

No-Code ToolFree planWeb
4.6Visit

Atuin

Focus: shell history, terminal and command line. Shares open source and github with OpenRefine. Rated 4.7 (OpenRefine: 4.6).

Desktop AppFreemacOS, Linux
4.7Visit

btop

Focus: system monitor, terminal and processes. Shares open source and github with OpenRefine. Adds Offline. Rated 4.7 (OpenRefine: 4.6).

Desktop AppFreemacOS, Linux
4.7Visit

chezmoi

Focus: dotfiles, config management and command line. Shares open source and github with OpenRefine. Adds Offline. Rated 4.7 (OpenRefine: 4.6).

Desktop AppFreemacOS, Windows
4.7Visit

Free alternatives to OpenRefine

Want to spend nothing? These free picks cover similar ground.

Hugo

Focus: static site, blog and documentation. Shares open source and github with OpenRefine. Rated 4.7 (OpenRefine: 4.6).

Desktop AppFreemacOS, Windows
4.7Visit

jq

Focus: json, data and command line. Shares open source and github with OpenRefine. Rated 4.7 (OpenRefine: 4.6).

Desktop AppFreemacOS, Windows
4.7Visit

Yazi

Focus: file manager, terminal ui and developer tool. Shares open source and github with OpenRefine. Adds Offline. Rated 4.7 (OpenRefine: 4.6).

Desktop AppFreemacOS, Windows
4.7Visit

Bruno

Focus: api client, api testing and postman alternative. Shares open source and github with OpenRefine. Same 4.6 rating.

Desktop AppFreeWindows, macOS
4.6Visit

direnv

Focus: environment variables, shell and projects. Shares open source and github with OpenRefine. Same 4.6 rating.

Desktop AppFreemacOS, Linux
4.6Visit

hyperfine

Focus: benchmark, speed test and command line. Shares open source and github with OpenRefine. Same 4.6 rating.

Desktop AppFreemacOS, Windows
4.6Visit
Are you the maker of OpenRefine?Get a free Featured badge for your site, a share image and ready-to-paste posts. No sign-up.

Free Notion database

1,100+ ways people are making money online

Real online businesses, creators and projects, broken down by how they make money: apps, online stores, AI tools and more. Free on Gumroad.

Get the free database

Free Notion database

399+ ways to make money online

Hundreds of online income methods in one place, so you can compare options and pick one to try. Free on Gumroad.

Get the free list

For research and ideas only. Results vary and nothing here is a promise of income. See our Disclaimer.

Weekly newsletter

Everything new, every Monday.

One short email every Monday with everything shipped that week: new free tools and websites, new guides, new free browser tools and what's new in my free Gumroad libraries, plus how the site is growing. Free, and you can unsubscribe anytime.

Join the newsletter

You sign up on Gumroad, which stores your email to send the newsletter. See our Privacy Policy.