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

qsv

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

Desktop AppFreemacOS, Windows
4.5Visit

DBeaver

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

Desktop AppFreemacOS, Windows
4.6Visit

DbGate

Focus: database, sql and nosql. Shares open source and github with OpenRefine. Adds Web. Rated 4.5 (OpenRefine: 4.6).

Desktop AppFreemacOS, Windows
4.5Visit

Free alternatives to OpenRefine

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

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

htop

Focus: process viewer, system monitor and terminal. Shares open source and github with OpenRefine. Rated 4.7 (OpenRefine: 4.6).

Desktop AppFreemacOS, Linux
4.7Visit

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
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.