OpenRefine

Open source

OpenRefine is a free, open source tool for cleaning messy data, transforming formats, and extending data with web services and external sources.

Open-source alternative to

openrefine.org
OpenRefine homepage screenshot
GitHub stars
12k
Last 30 days
+66(+1%)
Last commit
yesterday
Repository age
14 years
Version
3.10.1
Licence
BSD-3-Clause
Self-hosted
Yes

About OpenRefine

OpenRefine is a free, open source desktop application designed for working with messy data. It allows users to clean data, transform it from one format to another, and extend it using web services and external data sources.

The tool is aimed at anyone who needs to prepare and improve datasets, from journalists to researchers. It emphasizes privacy by processing data locally on the user's machine.

Key features

  • Faceting: drill through large datasets using facets and apply operations on filtered views.
  • Clustering: fix inconsistencies by merging similar values using heuristics.
  • Reconciliation: match datasets to external databases via reconciliation services.
  • Infinite undo/redo: rewind to any previous state and replay operation history on a new version.
  • Privacy: data is cleaned on the user's machine, not in a cloud service.
  • Wikibase: contribute to Wikidata and other Wikibase instances.

Good fit for

  • Cleaning and standardizing messy datasets
  • Transforming data between formats
  • Matching local data to external knowledge bases
Built with
Java tools
Tags
data cleaning
data transformation
open source
desktop app
wikidata

OpenRefine: questions and answers

What is OpenRefine used for?
OpenRefine is a free, open source tool for cleaning messy data, transforming formats, and extending data with web services and external sources. It is a good fit for cleaning and standardizing messy datasets, transforming data between formats, and matching local data to external knowledge bases.
Is OpenRefine open source?
Yes. OpenRefine is open source under the BSD-3-Clause licence. Its source code is on GitHub at OpenRefine/OpenRefine and is written mainly in Java.
Is OpenRefine free?
Yes. OpenRefine is open source, so the software itself is free to use.
Can I self-host OpenRefine?
Yes. OpenRefine can be self-hosted on your own server or infrastructure; there is no official hosted version.
What is OpenRefine an alternative to?
OpenRefine is an open-source alternative to Talend and Parabola. Other open-source alternatives to Talend include Airflow.
Is OpenRefine actively maintained?
Yes. The most recent commit to OpenRefine was on 12 November 2026, and the latest release is 3.10.1, published on 4 March 2026. The project has 12k stars on GitHub, with 66 added in the last 30 days.

Open-source alternatives to OpenRefine

See all

SaaS alternatives to OpenRefine

See all