OpenRefine/OpenRefine

Health v2 · maintenance only

Adoption not part of the score

11954 stars · 2161 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

OpenRefine is a free, open-source desktop application (running a local web server accessed via browser) for cleaning, transforming, and enriching messy datasets. It offers faceted browsing, clustering to fix inconsistencies, reconciliation against external databases like Wikidata, and full undo/redo of operation histories.

Use cases

• clean up messy csv or spreadsheet data
• deduplicate and merge similar values in a dataset
• reconcile entity names against wikidata
• explore large datasets with facets and filters
• convert data from one format to another
• bulk upload cleaned data to wikidata
• augment a dataset with data from web services

When to choose

• you need to interactively explore and clean tabular data without writing code
• you want to match your records against external authorities like Wikidata or library subject headings
• you care about privacy and want data cleaning done locally, not in the cloud
• you need reproducible, replayable cleaning histories with undo/redo

When to avoid

• you need fully automated, scheduled ETL pipelines - OpenRefine is interactive by design
• you want to clean data on a headless server without a browser interface
• your data does not fit a tabular/row-based model
• you need a lightweight command-line-only tool

Facets

application · maturity stable

data-science etl search-engine gui self-hosted data-science developer-tools cross-platform jvm browser data-cleaning data-wrangling reconciliation wikidata faceted-browsing grel data-journalism linked-open-data clustering record-linkage data-engineering openrefine web-server desktop

Member repositories

For agents

markdown · JSON · MCP: product_card(name="OpenRefine/OpenRefine")