Skip to Main Content

OpenRefine

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

Editing Columns

Renaming, removing, splitting or joining columns:

Select the column that you want to edit. Navigate to the dropdown arrow at the top of the column. Select "edit column" then choose the desired action from the pop-up window. 

Collapsing a column from view:

Select the column that you want to edit. Navigate to the dropdown arrow at the top of the column. Select "view" the "collapse this column".