OpenRefine

OpenRefineExperiments & data analysisListed

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