Skip to Main Content

University Library, University of Illinois at Urbana-Champaign


A free, open source, powerful tool for working with messy data.

Reordering Columns

OpenRefine allows you to reorder your columns for better contextualization or to prepare for further transformations of your data. To reorder columns:

  1. Go to the first column, labeled “All,” and click the arrow button on the column header.
  2. Select the option “Edit columns” and then choose “Re-order/remove columns.”
  3. In the pop-up window, click and drag the column titles into the order in which you would like them to be displayed or drag them to the far right to remove the columns.


Helpful Tips:

  • Reordering columns can be useful when preparing to combine column data or to rearrange columns after splitting column data.

2/12/18 - Brinna Michael