Guide to OpenRefine

The text filter helps you to search a column for values containing the string you want to find.

Faceting enables you to rapidly see distinctive values in a column, make changes to those values, and customize your display to only display results that match a given aspect.

This function allows you to make transformations to individual cells or groups of cells in a column.

The “Common Transformations” feature provides a quick and easy way to apply transformations to cells in a column.

This feature allows you to identify and merge similar records in a dataset. This helps to clean and standardize the data, reducing errors and inconsistencies.

This function allows you to split a single column into multiple columns based on a specified delimiter. This is useful when you have data that is stored in a single column but should be separated into separate columns for easier analysis or manipulation.

This feature allows you to merge multiple columns into a single column. This function is useful when you have data across columns, and you want to consolidate it into a single column for easier analysis or manipulation.

This function allows you to manage the columns in a dataset. You can re-order columns by dragging and dropping them to a new position, or you can remove columns that are no longer needed.

The Undo/Redo tab is located at the left of the grid view just in the same pane as the Facet/Filter tab. To roll back steps, just click on the step you wish to restore.

Exporting data in Openrefine is a simple process that allows you to save your data in a variety of formats for use in other applications.