11,931 stars · BSD-3-Clause · 3.10.1 (2026-03-04) · Track this in Scout
A local workbench for cleaning a messy table, best known for clustering near-duplicate values so they can be merged in one pass.
▶Repo detailsthe review · specs · pros & cons · install
What it is
OpenRefine loads a table from CSV, Excel, JSON or XML and gives it a browser interface for filtering, grouping and transforming. Its best-known feature is clustering: it finds values that are almost the same and offers to merge them.
What it is good for. Anyone who has inherited a customer list, a product catalogue, an export from an old system, or a survey of free-text answers. The job of getting that into a state where it can be imported somewhere is usually done by hand, and it is the sort of work that takes a day and produces new mistakes. This turns it into an hour and leaves a record of exactly what was changed.
- Clustering is genuinely good. It offers several matching methods, and on a column of company names it will typically catch hundreds of near-duplicates in one pass.
- Every operation is stored as a list you can export. Run it against next month's file and the same cleanup happens again, identically.
- It runs locally. Nothing is uploaded, which matters when the messy file contains customer data.
- It needs Java installed — JDK 11 or newer — and it opens in a browser while running as a local program, which confuses people the first time.
- The interface is from another era and the vocabulary is its own. "Facet" means filter. Expect an hour of reading before it clicks.
- It loads the table into memory, so a file of several million rows wants a machine with room to spare. It is not a replacement for a database.
- saulpw/visidata
9,241 stars, the same kind of exploring but inside a terminal and driven by the keyboard; far faster once learned, with no clustering feature.
Track this in Scout - wireservice/csvkit
6,412 stars, a set of command-line tools for cutting, joining and querying CSV files; scriptable and repeatable, with nothing to look at.
Track this in Scout 
dathere/qsv3,763 stars, a very fast Rust toolkit for the same command-line work, built for files too large to open comfortably.
Track this in Scout
wget https://github.com/OpenRefine/OpenRefine/releases/download/3.10.1/openrefine-linux-3.10.1.tar.gz tar -xzf openrefine-linux-3.10.1.tar.gz cd openrefine-3.10.1 ./refine
