Skip to main content

Transforming data


OpenRefine gives you powerful ways to clean, correct, codify, and extend your data. Without ever needing to type inside a single cell, you can automatically fix typos, convert things to the right format, and add structured categories from trusted sources.

This section of ways to improve data are organized by their appearance in the menu options in OpenRefine. You can:

Edit rows

Moving rows around is a permanent change to your data.

You can sort your data based on the values in one column, but that change is a temporary view setting. With that setting applied, you can make that new order permanent.

A screenshot of where to find the Sort menu with a sorting applied.

In the project grid header, the word “Sort” will appear when a sort operation is applied. Click on it to show the dropdown menu, and select Reorder rows permanently. You will see the numbering of the rows change under the All column.

Reordering all rows

Reordering rows permanently will affect all rows in the dataset, not just those currently viewed through facets and filters.

You can undo this action using the History tab.