Skip to main content

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

Drop-down menu path for moving or removing columns

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."

Process for renaming a column

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

Drop-down menu path for collapsing columns

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

Example of collapsing columns function

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