https://openrefine.org/

Skip to main content
 
OpenRefine diamond logoOpenRefine diamond logo
OpenRefineDownloadDocumentationCommunityBlog
DonateGitHub
Search

OpenRefine

OpenRefine is a powerful free, 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
OpenRefine logo

Main features

Faceting feature logo

Faceting

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

Clustering feature logo

Clustering

Fix inconsistencies by merging similar values thanks to powerful
heuristics.

Reconciliation feature logo

Reconciliation

Match your dataset to external databases via reconciliation services.

Infinite undo/redo feature logo

Infinite undo/redo

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

Privacy feature logo

Privacy

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

Wikibase feature logo

Wikibase

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

And much more to discover in our documentation.

Get OpenRefine

  * Download
  * What's new
  * Extensions
  * Other distributions
  * GitHub repository

Documentation

  * User manual
  * Contributing
  * External resources
  * Privacy notice

Community

  * Get involved
  * Forum
  * Gitter chat
  * Twitter
  * Mastodon

OpenRefine diamond logoOpenRefine diamond logo
Creative Commons License
OpenRefine's documentation is licensed under a Creative Commons
Attribution 4.0 International License.