What it does
OpenRefine cleans and transforms messy datasets. It provides faceting, clustering of similar values, reconciliation with external data sources, and a replayable operation history.
Facet a dataset, cluster inconsistent values and use undo history while cleaning it locally. Export the current result as CSV/TSV, a spreadsheet or another supported format; many export choices respect active filters, so check whether the current view or all rows are selected. Operation history can be exported as JSON for reuse. A project archive instead contains the full data and earlier history, including confidential values removed later. Reconciliation and optional Google Sheets/Drive exports involve external services; Drive authorization is separate from local work.
Strengths
- Connects targeted cleanup with replayable transformation history.
Best for
- Preparing inconsistent tabular data for reuse
Sources
- OpenRefine (Oct 26, 2026)
- Exporting your work | OpenRefine (Oct 26, 2026)