Awesome Open

Project record

OpenRefine

OpenRefineDatabases & Search / Education & ResearchClean, transform, and improve messy data.BSD-3-Clause
Field notes / 396OpenRefine
I / Function

Clean, transform, and improve messy data.

OpenRefine works on messy datasets locally, using facets to isolate records and clustering to consolidate inconsistent values. Reconciliation services connect records to external databases, and transformations can change formats or enrich data from web services. The operation history supports undo, redo and replay on another version of a dataset.

OpenRefine: Features · Reviewed 2026-10-13

A translucent calyx sorting mixed mineral grains into matching vertical strands.
Awesome Open* · Field recordOpenRefineOP-88684EE6 · Folio 396Domain: Databases & Search / Education & Research
  1. 01 / Feature noteReplay a cleanup

    Undo or redo changes, then replay the operation history on another version of the dataset.

    Feature source ↗
  2. 02 / Feature noteFind inconsistent values

    Clustering groups similar values so spelling and formatting inconsistencies can be consolidated.

    Feature source ↗
II / Repository record

GitHub stars

12,090

Detected license

BSD-3-Clause

Repository created

2012-10-15

Repository push

2026-11-02

III / Observations & evidence

GitHub stars

Unknown

i
Window mismatch; awaiting refresh

Cached history uses a different month window; chart withheld until aligned.

Latest attempt: ok · Checked 2026-10-15T19:40:39.600225+00:00 · Last successful fetch 2026-10-15T19:40:39.600225+00:00 · Provider source

Hacker News stories

Unknown

i
Not recorded

OpenSSF Scorecard

Unknown

i
Unavailable

No result returned.

Checked 2026-10-27T00:21:53Z · Latest attempt: not found · Provider source

IV / Release record

GitHub release

3.10.1

Published 2026-03-04

i
Available

Checked 2026-11-04T04:04:05Z · Last successful fetch 2026-11-04T04:04:05Z · Value fetched 2026-11-04T04:04:05Z · Provider source

V / Where it runs
Local browser interface
Downloadable binary / archiveInstallerPackage manager
Windows / macOS / Linux
i

Run Install Documented platforms

Reviewed 2026-10-13 · AI evidence review · Approved evidence record

Run modes
  • Local browser interface

    A local web server on the user's computer, accessed through a browser.

    Installing OpenRefine

Install methods
Documented platforms
External services
  • Online import, reconciliation and export services · optional

    Basic local operations work without internet; selected web operations require it.

    Installing OpenRefine

Package coordinates
  • Homebrew cask · openrefine · stable · documented · unknown

    macOS cask documented by upstream; the registry currently notes Intel build and Rosetta 2 on Apple Silicon. Maintainer affiliation was not established.

    Installing OpenRefine / Homebrew openrefine cask

Resource and setup notes
  • Default: The documented default Java heap allocation is 1 GB (1024 MB).

    An application memory setting, not minimum total machine RAM; larger datasets may need a larger allocation.

    Installing OpenRefine

  • Constraint: Java and a compatible browser are required; some distributions bundle Java.

    Runtime prerequisites depend on the chosen OpenRefine version and download.

    Installing OpenRefine