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.

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.

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.

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. If the data is not read as "dates", it needs to covert this column to dates. See the explanation of Common transformations.
3. Choose “Facet” and then select “Timeline facet.”
4. A window with a sliding scale will appear in the pane to the left side of the grid view.

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