Skip to Main Content

OpenRefine

This guide will help you learn how to download OpenRefine, create a project, and utilize some functionalities for analyzing and fixing data.

Data

OpenRefine can work with a variety of data formats.

 

Import formats:
CSV, JSON, MARC, ODS, TSV, XML, XLS, XLSX.

 

Export formats:
CSV, HTML, ODS, SQL, TSV, Wikidata, XLS, XLSX.
 

Reproduce your workflow

Every change made to a project in OpenRefine is tracked as GREL code. You can get the JSON of your work history and share it for reproducibility or re-use transformations by applying them to another project.

 

JSON from OpenRefine