OpenRefine
openrefine.org
- Free plan
- Windows
- macOS
- Linux
- Web
- Self-hosted
What OpenRefine 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 run offline because it operates as a small web server on that computer. Facets help users examine large datasets and apply operations to filtered views. Clustering applies heuristics to group similar values and address inconsistencies, while reconciliation can match values to external databases through reconciliation services. OpenRefine provides undo and redo history for revisiting operations. It 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. Releases are available for Windows, Mac, and Linux. Java must be installed and configured, although the Mac version includes it and some Windows packages do too. Data is not encrypted by default; users can protect it with full-disk encryption provided by their operating system. The project offers support through its forum, GitHub, community calls, and Gitter chat.
Who it suits
OpenRefine may suit people preparing and enriching datasets, including journalists, media professionals, galleries, libraries, archives, and museums. It is designed for local desktop use rather than cloud processing.
Good to know, and what to watch
- Free and open-source software.
- Processes data locally, with basic offline functions.
- Supports a wide range of import formats.
- Includes undo and redo operation history.
- Java must be installed and configured.
- Data is not encrypted by default.
- Some functions require internet access or services.
Plans
Every plan and priceFree open-source software
Free plan
Getting started
- Install the OpenRefine package for Windows, Mac, or Linux
- Install and configure Java when your package requires it
- Start OpenRefine as a local web server
- Import data in a supported format
- Clean and transform data with facets, clustering, or reconciliation
- Export or send results to Google Sheets or Wikidata
Limits to check
The Free open-source software plan is listed as free. Data is not encrypted by default, and Java installation and configuration may be required.
The Club's review
OpenRefine is a free, open-source desktop tool for cleaning, reshaping and enriching untidy datasets. It is best suited to journalists and to teams in libraries, archives, galleries and museums that need local control over records. The trade-off is that Java setup and data protection remain your responsibility.
Overview
OpenRefine runs as a small web server on your own computer, so processing stays on the machine instead of moving data to a cloud service. Basic work can continue without an internet connection. That combination suits sensitive collection records and reporting data, while making it less convenient for teams that need a centrally managed, browser-only service.
The project has been active since 2010 and is released under the BSD 3-clause license. Support comes through its forum, GitHub, community calls and Gitter chat. Data is not encrypted by default; anyone requiring encryption must use full-disk protection supplied by the operating system.
Key features
Facets let you inspect a large dataset through filtered views and apply operations to the matching subset. In practice, that is faster than correcting every row individually when a problem affects a recognizable group. Clustering uses heuristics to find similar values and propose merges, helping standardize inconsistent entries while leaving the final judgment with the user.
Reconciliation connects values to external databases through reconciliation services, extending preparation into enrichment. OpenRefine can upload data to Google Sheets and create or update statements on Wikidata. Those integrations are useful when they match your publishing workflow, but they do not substitute for connectors to other destinations.
Infinite undo and redo records operation history, allowing a transformation to be replayed or reversed instead of forcing a project to start over. Import coverage is unusually broad: CSV, TSV, plain text, fixed-width, JSON, XML, ODS, XLS/XLSX, PC-Axis, MARC, RDF formats and Wikitext are supported. Data profiling is included, providing a way to examine the shape and quality of an incoming dataset before changing it.
Pricing
Free open-source software — free (BSD 3-clause license; desktop installation). There are no paid tiers, seats or usage quotas in this plan. It is the right choice for individuals and organizations that can operate software locally and handle their own setup and protection. The cost advantage comes with no hosted service: you manage installation, Java configuration and stored-data security yourself.
Platforms
OpenRefine is offered for Windows, macOS and Linux, with desktop deployment and self-hosted operation through its local web interface. Java must be installed and configured; the Mac version includes Java, and some Windows packages include it. That reduces setup on those packages but still makes runtime compatibility part of deployment planning.
Who it's for
Journalists and media professionals can use local, reversible transformations when preparing reporting data. Galleries, libraries, archives and museums benefit from the import range, faceting, clustering and reconciliation when cleaning collection records or enriching catalog data. It is a strong fit for budget-conscious users who want open-source control and can work with a desktop-oriented process.
Look elsewhere if your workflow depends on cloud-hosted processing, default encryption, or integrations centered on services other than Google Sheets and Wikidata.
Pros and cons
Pros
- No software charge: the BSD-licensed release costs nothing and has no paid-plan restrictions.
- Broad file support: many tabular, document, bibliographic and semantic formats reduce conversion work before cleanup.
- Reversible operations: infinite undo and redo makes iterative transformations safer to refine.
- Local and offline capable: data can stay on your machine and basic functions work without internet access.
- Useful enrichment paths: reconciliation, Google Sheets uploads and Wikidata updates cover common publication and cataloging tasks.
Cons
- Java dependency: installation and configuration can complicate rollout, especially where runtime management is restricted.
- No default encryption: protecting stored projects requires operating-system full-disk encryption and local security practices.
- Destination coverage is selective: the named integrations favor Google Sheets and Wikidata rather than a broad set of services.
- Heuristics still need oversight: clustering accelerates matching but does not decide which values should be merged for you.
Alternatives
Melissa Data Quality is a better fit when address verification and API, web or mobile deployment matter; its GAV Free plan is free for 250 records per month and includes CASS and DPV certification.
BlueData suits a small web-and-mobile workflow, with a freemium plan covering one web user, one mobile user, 1 GB of storage and 500 submissions per month.
Plauti Deduplicate is the alternative for Salesforce-focused deduplication, with a free AppExchange version and fuller features requiring a trial or custom pricing.
DataCleaner is another free, open-source desktop option for Linux, macOS and Windows.
DQE One Unify is for organizations wanting curative processing hosted in DQE's cloud.
Experian Data Quality Solutions provides a paid solution tailored to budget and requirements.
Firstlogic Data Quality IQ Suite targets enterprise deployments with yearly licensing and unlimited records, priced according to products, features, platform and country coverage.
SAS Visual Statistics is the choice for enterprise-scale statistical modeling on SAS Viya rather than a free cleaning desktop.
Browse Data Cleansing Software, Data Preparation Software and Data Transformation Tools for broader category comparisons.
Verdict
Choose OpenRefine if you need capable, no-cost data preparation with broad imports, local processing and a safely reversible operation history. Look elsewhere when managed cloud delivery, built-in encryption or enterprise integrations outweigh open-source flexibility and local control.
The verdict
OpenRefine provides local tools for cleaning, transforming, and enriching data, with broad import support and an operation history. Users should account for its Java requirement and protect stored data themselves if encryption is needed.
Questions people ask
How much does OpenRefine cost?
The Free open-source software plan is listed as free and uses a BSD 3-clause license.
Which operating systems does it support?
Packages are available for Windows, Mac, and Linux. Self-hosted and web platforms are also listed.
Does OpenRefine require internet access?
Basic functions work offline because OpenRefine runs as a small web server on your computer. Reconciliation and other external-data services can use web connections.
Which data formats can it import?
Imports include CSV, TSV, text, fixed-width, JSON, XML, ODS, XLS/XLSX, PC-Axis, MARC, RDF formats, and Wikitext.
Can it connect to Google Sheets or Wikidata?
It can upload data to Google Sheets and create or update statements on Wikidata.
Is OpenRefine open source?
Yes. OpenRefine is free and open source, with a BSD 3-clause license.
What the maker publishes
- Clustering
- Clustering uses heuristics to merge similar values and fix inconsistencies. source
- Faceting
- Facets let users drill through large datasets and apply operations to filtered views. source
- Founded
- 2010 source
- Import formats
- Supported imports include CSV, TSV, text, fixed-width, JSON, XML, ODS, XLS/XLSX, PC-Axis, MARC, RDF formats and Wikitext. source
- Integrations
- OpenRefine can upload data to Google Sheets and create or update statements on Wikidata. source
- Java requirement
- Java must be installed and configured, although the Mac version includes Java and some Windows packages include it. source
- Local processing
- Data is cleaned on the user's machine rather than in a cloud service. source
- Offline operation
- Basic functions run without internet access because OpenRefine runs as a small web server on the user's computer. source
- Open source
- OpenRefine is free and open source. source
- Operating systems
- OpenRefine releases packages for Windows, Mac and Linux. source
- Purpose
- OpenRefine is a tool for cleaning, transforming and extending messy data with web services and external data. source
- Reconciliation
- Reconciliation matches dataset values to external databases through reconciliation services. source
- 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. source
- Support
- The project provides support through its forum, GitHub, community calls and Gitter chat. source
- Undo history
- OpenRefine provides infinite undo and redo, allowing users to rewind and replay operation histories. source
- Users
- Journalists, media professionals, galleries, libraries, archives and museums use OpenRefine for data preparation and enrichment. source
Checked against the maker's pages on 30 Sept 2026.