OpenRefine
A tool for cleaning messy data and reconciling inconsistent values.
Cost
Completely free
Fully free and open source.
Open source
Yes
The code is public. Anyone can inspect it, and it cannot be taken away from you.
Your data
Stays on your computer
Nothing is uploaded. This matters for anything confidential.
Use it for this
The specific misery of a column where the same thing is spelled nine ways.
Do not use it for this
Analysis or visualisation. It cleans; other tools analyse.
A moment where you would reach for it
Collapsing 'Mumbai', 'mumbai', 'Bombay' and 'Mumbai ' into one value across 40,000 rows.
How hard is it to pick up?
Takes real effort to learn. Worth it if you need what it does.
Worth knowing before you use it
Runs locally in your browser against a local process.
Other things that do this job
No tool is best at everything. These solve a similar problem, with different trade-offs.
About this entry
Checked on 1 Sept 2026. Prices and free limits change without warning, and often quietly. Treat everything above as a starting point and confirm on the official site before you rely on it.
Nothing here is sponsored. A tool appears because it solves a real problem, not because someone paid for it to be listed.