What is OpenRefine?
OpenRefine is a free open-source desktop tool for exploring, cleaning, transforming, clustering, and reconciling messy tabular data.
What stands out
Import a CSV, spreadsheet, JSON, or another supported source, then use facets to inspect patterns and clusters to merge inconsistent values. Transformations can be recorded and reapplied, reconciliation can match entities to external databases, and the cleaned result can be exported.
Frequently Asked Questions
Questions about OpenRefine
Does OpenRefine upload my dataset to a hosted service?
No. OpenRefine runs locally and opens its interface in a browser, so ordinary project processing stays on the computer unless you connect an external service.
Can OpenRefine find inconsistent spellings or labels?
Yes. Clustering groups similar text values so you can review and merge variants such as misspellings or inconsistent naming.
Do I need to write code to use OpenRefine?
No for many cleaning tasks. Expressions and scripting-style transformations are available when a workflow needs more precise control.