Skip to Main Content

Today's hours:

See all library hours »

  • Ask a Librarian
  • FAQ

Clean Messy Data with OpenRefine

Exporting Data & Scripts

Exporting Cleaned Data

Use the Export button at the top right corner to export your cleaned data in the following formats: 

  • Tab separated values (TSV)
  • Comma separated values (CSV)
  • Excel
  • HTML table

You can also export an OpenRefine project, which will include both your clean data and operational history. See Exporting for more information and if you wish to export a format not listed in the above list. 

Extracting Cleaning/Transformation Operational History

To copy your operational history, click on the Extract button under Undo / Redo. By default, your transformations will be selected, however deselect any operations you do not wish to apply on a future project. 

  • Your operation history will appear as a JSON in the right display panel. Copy this into a notepad or txt file. 
  • To apply the operations to a another OpenRefine project, use the Apply button under Undo / Redo, and past the extracted JSON.