OpenRefine

About OpenRefine

OpenRefine is a desktop-accessible application for exploring and cleaning tabular data. Import a copy of a dataset, use facets to inspect inconsistent values and try clustering to identify spellings that may refer to the same thing. Keep human review in the loop when deciding which records should be merged. The tool is useful for cleaning data before analysis or publication, particularly when repeated edits need an audit trail. Reconciliation can use external services, so check what data an operation sends before applying it to a private dataset. Review a sample export and compare its record count and field values with the original.