Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

University Library, University of Illinois at Urbana-Champaign

OpenRefine

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

Changing the Grid View

There are several ways you can change the grid view to make it easier to compare, assess, and associate columns of data. Some changes can be either permanent or non-permanent and can help improve the overall organization of your data.

Permanent Changes

Permanent changes to the grid view include rearranging columns, removing columns, and/or renaming columns.

Rearranging and removing columns can be done using the instructions found in Reordering Columns, but for small, quick adjustments, this method has the same results.

  1. Go to the column you would like to rearrange or remove and click the arrow button on the column header.
  2. Select the “Edit columns” option and choose the option that best fits from the dropdown:
    1. Remove this column
    2. Move column to beginning
    3. Move column to end
    4. Move column left
    5. Move column right

Changes to the column name can be done in a few simple steps:

  1. Go to the column you would like to rename and click the arrow button on the column header.
  2. Select the "Edit columns" option and click on "Rename this column."
  3. Change the column name in the pop-up window and click "OK."

NOTE: Changes to column order or column name and removal of columns are logged as transformations in your tracked history. To undo moving a column, follow the instructions found in History and Undo/Redo.

Non-Permanent Changes

Non-permanent changes to the grid view include collapsing columns in one of four ways: collapsing the current column, collapsing all other columns, collapsing all columns to the left of the current column, or collapsing all columns to the right of the current column.

  1. Go to the column you would like to change and click the arrow button on the column header.
  2. Select the “View” option and pick the best option from the dropdown:
    1. Collapse this column
    2. Collapse all other columns
    3. Collapse all columns to left (see second image below)
    4. Collapse all columns to right

  1. The collapsed column(s) are replaced by a narrow placeholder.
  2. To reopen collapsed columns, click on the placeholder.

NOTE: Collapsing columns does not permanently delete columns from your data, it only hides the selected columns from view. To permanently delete columns, follow the instructions in Reordering Columns.

5/2/2018 - Brinna Michael