Skip to Main Content

OpenRefine

An introduction to this free, open source tool for working with "messy" data.

Create or Open a Project

  1. Open OpenRefine.
  2. Data can be imported from a number of locations and in a number of formats. Select where you would like to get your data from, choose the files, and click "Next."
  1. This screen shows a preview of your data. Before creating the project, change the settings based on the file format (e.g. CSV, TSV, xls, JSON). For CSV or TSV data, set the character encoding to match the original file, identify how columns are separated, and choose options for  parsing the data.
  2. When you are done, click "Create Project" in the upper right corner.