Freedom251
For vendors
AdvertiseTop spots, featured rows, home sponsor Get listedAdd a product we don't cover yet Claim a listingFree: verify the domain, then correct your page Vendor dashboardNumbers, orders and placements
Vendor dashboard

OpenRefine

OpenRefine is free, open-source desktop software for cleaning, transforming, and extending messy data. It processes data on the user's machine rather than through a cloud service, and its basic functions work offline because it runs as a small web server on that computer. Facets help users inspect large datasets and apply operations to filtered views. Clustering uses heuristics to bring similar values together and 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, JSON, XML, spreadsheets, 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, although the Mac version includes Java and some Windows packages include it. Data is not encrypted by default; users can protect it with their operating system's full-disk encryption. The project offers support through its forum, GitHub, community calls, and Gitter chat.

Who it is for

It suits people preparing and enriching data locally, including journalists, media professionals, galleries, libraries, archives, and museums. Its offline basics may help users who need to work without an internet connection.

What is good

  • Processes data locally rather than in a cloud service.
  • Basic functions work offline.
  • Includes faceting, clustering, and reconciliation tools.
  • Imports a wide range of data formats.

What to know first

  • Java must be installed and configured.
  • Data is not encrypted by default.
  • It is desktop software, not a mobile app.

Verdict

OpenRefine offers local data cleaning and enrichment with a wide range of import formats and an operation history. Users should account for the Java requirement and the lack of default data encryption.

OpenRefine plans and pricing

All plans
Free open-source software Free BSD 3-clause license · desktop installation openrefine.org · 30 Sept 2026

Compared on data transformation tools

Free plan
Yes

Best OpenRefine alternatives

See all 12
jq Free plan LinuxMacself-hostedWebWin Free6.6 Apache Beam Free plan apiLinuxMacself-hostedWeb Free6.5 Bruin for Customer Success Free plan apiLinuxMacself-hostedWeb Free6.5 csvkit Free plan LinuxMacWin Free6.5 KNIME Analytics Platform Free plan LinuxMacWin 6.5 Apache Hop Free plan LinuxMacself-hostedWin Free6.4