- Home
- Data Cleansing Software
- OpenRefine
OpenRefine
What it is
OpenRefine is free, open-source software for cleaning, transforming, and extending messy data. It works on the user's machine rather than in a cloud service, and basic functions can run offline because it operates as a small web server on that computer. Facets let users explore large datasets and apply operations to filtered views. Clustering uses heuristics to group similar values and help address inconsistencies; reconciliation matches dataset values to external databases through reconciliation services. An undo and redo history lets users revisit operations. OpenRefine imports formats including CSV, TSV, text, fixed-width, JSON, XML, ODS, XLS/XLSX, PC-Axis, MARC, RDF formats, and Wikitext. It can upload data to Google Sheets and create or update Wikidata statements. Packages are available for Windows, Mac, and Linux. Java must be installed and configured, though the Mac version and some Windows packages include it. Data is not encrypted by default; the operating system's full-disk encryption can protect it.
For and against
For
- Processes data on the user's machine, not in a cloud service.
- Basic functions work offline.
- Facets support operations on filtered dataset views.
- Imports a wide range of listed data formats.
- Includes undo and redo history.
Against
- Java must be installed and configured for use.
- Data is not encrypted by default.
The verdict
OpenRefine offers local tools for exploring, cleaning, and enriching data, including offline basic functions and integrations with Google Sheets and Wikidata. Users should account for the Java requirement and default lack of data encryption.
Who it suits
OpenRefine suits people preparing or enriching datasets, including journalists, media professionals, galleries, libraries, archives, and museums. Its local processing and offline basic functions may suit users who want to work without a cloud service.
Plans and prices
Free open-source software
BSD 3-clause license · desktop installation
Read 30 Sep 2026 · openrefine.org
On the record
- Clustering
- Clustering uses heuristics to merge similar values and fix inconsistencies.openrefine.org · read 30 Sep 2026
- Faceting
- Facets let users drill through large datasets and apply operations to filtered views.openrefine.org · read 30 Sep 2026
- Import formats
- Supported imports include CSV, TSV, text, fixed-width, JSON, XML, ODS, XLS/XLSX, PC-Axis, MARC, RDF formats and Wikitext.openrefine.org · read 30 Sep 2026
- Integrations
- OpenRefine can upload data to Google Sheets and create or update statements on Wikidata.openrefine.org · read 30 Sep 2026
- Java requirement
- Java must be installed and configured, although the Mac version includes Java and some Windows packages include it.openrefine.org · read 30 Sep 2026
- Local processing
- Data is cleaned on the user's machine rather than in a cloud service.openrefine.org · read 30 Sep 2026
- Offline operation
- Basic functions run without internet access because OpenRefine runs as a small web server on the user's computer.openrefine.org · read 30 Sep 2026
- Open source
- OpenRefine is free and open source.openrefine.org · read 30 Sep 2026
- Operating systems
- OpenRefine releases packages for Windows, Mac and Linux.openrefine.org · read 30 Sep 2026
- Purpose
- OpenRefine is a tool for cleaning, transforming and extending messy data with web services and external data.openrefine.org · read 30 Sep 2026
- Reconciliation
- Reconciliation matches dataset values to external databases through reconciliation services.openrefine.org · read 30 Sep 2026
- Security and privacy
- Data stored by OpenRefine is not encrypted by default, and users can protect it with full-disk encryption provided by their operating system.openrefine.org · read 30 Sep 2026
- Support
- The project provides support through its forum, GitHub, community calls and Gitter chat.openrefine.org · read 30 Sep 2026
- Undo history
- OpenRefine provides infinite undo and redo, allowing users to rewind and replay operation histories.openrefine.org · read 30 Sep 2026
- Users
- Journalists, media professionals, galleries, libraries, archives and museums use OpenRefine for data preparation and enrichment.openrefine.org · read 30 Sep 2026
