OpenRefine cleans and transforms messy data between formats and extends datasets with web services.

openrefine.org
OpenRefine homepage screenshot

About OpenRefine

OpenRefine is a tool for working with messy data: cleaning it, transforming it from one format into another, and extending it with web services and external data. Its main features include faceting for drilling through large datasets and running operations on filtered views, clustering to merge similar values and fix inconsistencies, reconciliation to match a dataset against external databases, and unlimited undo/redo that can rewind to any previous state and replay an operation history on a new version of the data. It also supports contributing to Wikidata and other Wikibase instances. The homepage states that data is cleaned on the user's machine rather than in a cloud service; reconciliation and Wikibase work involve external databases and services. Further capabilities are covered in the project's documentation.

Key features

  • Faceting to drill through large datasets and operate on filtered views
  • Clustering merges similar values to fix inconsistencies using heuristics
  • Reconciliation matches datasets to external databases via reconciliation services
  • Unlimited undo/redo rewinds to any prior dataset state
  • Contribute to Wikidata and other Wikibase instances
  • Data cleaning runs on the user's machine, not a cloud service
Best for: Researchers and anyone who needs to clean, transform or enrich messy datasets before analysis.
Good for
  • Covers cleaning, format conversion and enrichment with external data
  • Operation history supports rewinding and replaying on a new data version
  • Processing is described as taking place on the user's own machine
Watch out for
  • Reconciliation and Wikibase features depend on external databases and services
  • Pricing and licensing terms are not stated in the available information

OpenRefine at a glance

Type
Website
Pricing
Not confirmed. Check the site
Platforms
Web
Open source
Not stated
Language
English
Last checked
Oct 6, 2026 · Online when checked
Listed
Oct 5, 2026

OpenRefine alternatives

Tools and sites you could use instead, ranked by how closely they match.

All 24 alternatives

Telborg

telborg.com

Telborg tracks construction and power developments for Texas data centers using public filings and related announcements.

Popular in Research & Study Tools

Well-known listings from the same topic.

All 153

OpenRefine FAQ

What can OpenRefine do with a dataset?
It cleans messy data, transforms it from one format into another, and extends it with web services and external data.
How does OpenRefine match data to external sources?
It uses reconciliation services to match a dataset to external databases.
Is data processed locally?
The homepage says data is cleaned on your machine rather than in a cloud service, but reconciliation and Wikibase features work with external databases and services.
Is something wrong or out of date?

Tell us and an editor will check it.

Own this website?

Claim the listing and suggest updates yourself. An editor checks every claim first.

Claim this listing