Skip to Main Content

Cleaning Spreadsheet Data with OpenRefine

This guide accompanies the Galter Health Sciences Library class of the same name, or can be used on its own to learn the basic functions of OpenRefine. The class and guide are adapted from Library Carpentry OpenRefine, Copyright 2016-2019

Exporting your OpenRefine Project

When you have finished making all data changes in your project, look for the Export button in the upper right-hand corner of OpenRefine’s main screen. There are multiple data options for export, including many comma-separated value options. Remember that OpenRefine will export the new, cleaned data file, which will be different from the original file you uploaded. The automatically-generated file name will be similar, so be sure to change it to reflect that this is a new, cleaned data file.

Screenshot showing the export options in OpenRefine