OpenRefine

7.1easy start · #6 of 36
in Data Transformation Tools

Free to practise onyes
Free trialnot on record
Well documentedyes
Runs where you workyes

Runs on Linux, Mac, self-hosted, Web, Windows.

OpenRefine is ranked #6 of 36 in data transformation tools on The Geeks Club. It runs on Linux, macOS, Self-hosted, Web, Windows. There is a free plan.

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

KNIME Analytics Platform 0 of 4 in the starter kit Lesson 17.7 dbt Semantic Layer 0 of 4 in the starter kit Lesson 27.5 Matillion Transform 0 of 4 in the starter kit Lesson 37.5 Coalesce Catalog 0 of 4 in the starter kit Lesson 47.4 csvkit 0 of 4 in the starter kit Lesson 57.1 Apache Beam 0 of 4 in the starter kit Lesson 77.0

The record

Purpose: OpenRefine is a tool for cleaning, transforming and extending messy data with web services and external data.
Open source: OpenRefine is free and open source.
Faceting: Facets let users drill through large datasets and apply operations to filtered views.
Clustering: Clustering uses heuristics to merge similar values and fix inconsistencies.
Reconciliation: Reconciliation matches dataset values to external databases through reconciliation services.
Undo history: OpenRefine provides infinite undo and redo, allowing users to rewind and replay operation histories.
Local processing: Data is cleaned on the user's machine rather than in a cloud service.
Integrations: OpenRefine can upload data to Google Sheets and create or update statements on Wikidata.
Import formats: Supported imports include CSV, TSV, text, fixed-width, JSON, XML, ODS, XLS/XLSX, PC-Axis, MARC, RDF formats and Wikitext.
Offline operation: Basic functions run without internet access because OpenRefine runs as a small web server on the user's computer.
Operating systems: OpenRefine releases packages for Windows, Mac and Linux.
Java requirement: Java must be installed and configured, although the Mac version includes Java and some Windows packages include it.
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.
Support: The project provides support through its forum, GitHub, community calls and Gitter chat.
Price from: Free

Where it ranks on The Geeks Club

Best Data Transformation Tools in 2026#6 of 36
Best Data Cleansing Software in 2026#4 of 30
Best Data Preparation Software in 2026#5 of 27

Is OpenRefine yours?

Claim it for free: prove the domain, then correct facts, plans and screenshots. An editor reviews every change.

Claim it free Promote OpenRefine

Sources

openrefine.org· checked 30 Sept 2026
openrefine.org/docs/manual/exporting· checked 30 Sept 2026
openrefine.org/docs/manual/starting· checked 30 Sept 2026
openrefine.org/docs/manual/installing· checked 30 Sept 2026
openrefine.org/privacy· checked 30 Sept 2026
openrefine.org/community· checked 30 Sept 2026
openrefine.org/usage· checked 30 Sept 2026
openrefine.org/download· checked 30 Sept 2026