Skip to main content

OpenRefine

OpenRefine is a powerful open source tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data.

Download
Screenshot of an OpenRefine project

Main features

Facetting

Drill through large datasets using facets and apply operations on filtered views of your dataset.

Learn more

Clustering

Fix inconsistencies by merging similar values thanks to powerful heuristics.

Learn more

Reconciliation

Match your dataset to external databases via reconciliation services.

Learn more

Infinite undo/redo

Rewind to any previous state of your dataset and replay your operation history on a new version of it.

Learn more

Privacy

Your data is cleaned on your machine, not in some dubious data laundering cloud.

Learn more

Wikibase

Contribute to Wikidata, the free knowledge base anyone can edit, and other Wikibase instances.

Learn more

And much more to discover in our documentation.