OpenRefine
About this tool
An open-source data-cleaning tool that runs locally and is operated through a browser. Use facets to find anomalies, cluster similar spellings, transform data with GREL, and reconcile entities against sources such as Wikidata. Data stays on your machine. Useful for surveys, reference metadata and archival datasets.
- Feature 1: Find anomalies and inconsistent records with facets and filters.
- Feature 2: Cluster similar values with different spellings.
- Feature 3: Transform columns and cells with GREL, Jython and other expressions.
- Feature 4: Reconcile entities with external sources such as Wikidata.
- Feature 5: Undo operations and export history as JSON for reuse in other projects.
Resource information
- Maintainer
- OpenRefine community and core team, fiscally hosted by Code for Science and Society.
- Type
- Tool / library
- Category
- Experiments & data analysis
- Runs on
- Tool or library
- Who it's for
- Social-science, digital-humanities, library and information researchers cleaning survey data, standardizing names and matching metadata to knowledge bases.
- License at time of listing
- BSD-3-Clause
- Source
- GitHub
