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 Cell Format

When you import a project into OpenRefine, the cells will automatically be given a format: text, number, or date. To change this format:

  1. Go to the column you would like to change the format of and click the arrow button on the column header.
  2. Choose “Edit cells” and then select “Common transformations.”
  3. Under “Common transformation,” choose the desired format.

Helpful Tips:

  • Columns with values in green are either in date or number format. This makes it easier to identify what types of facets and filters you can use.

Numeric Facet

The Numeric Facet allows you to sort columns with numeric values and to use a sliding scale to adjust the range of number values displayed in the grid view. To display this facet:

  1. Go to the column you would like to facet and click the arrow button on the column header.
  2. Choose “Facet” and then select “Numeric facet.”
  3. A window with a sliding scale will appear in the pane to the left side of the grid view.

Process of using the numeric facet

Helpful Tips:

  • The “Numeric Facet” function is useful for narrowing data to exclude outlying numeric values.
  • This function can also be used to isolate high or low values.

Timeline Facet

The Timeline Facet allows you to sort columns with date values and to use a sliding scale to adjust the range of date values to displayed in the grid view. To display this facet:

  1. Go to the column you would like to facet and click the arrow button on the column header.
  2. Choose “Facet” and then select “Timeline facet.”
  3. A window with a sliding scale will appear in the pane to the left side of the grid view.

Process for using the timeline facet

Helpful Tips:

  • The “Timeline facet” function is useful for narrowing data to exclude outlying date values.
  • This function can also be used to isolate specific dates, times, or date ranges.

5/3/2018 - Brinna Michael