Skip to Main Content


An introduction to this free, open source tool for working with "messy" data.

Common Data Transformations

Through the column drop down menus, OpenRefine provides options for common transformations to facilitate data cleaning such as:

Common Transformations - How to perform common data transformations.

Faceting and Clustering - How to create and edit text and number facets.

Combining and Splitting Cells - How to combine and split cells into different columns.


Data Transformation Tutorial