Introduction to OpenRefine

Importing data into OpenRefine

Figure 1

Screenshot of Open Refine Create Project Screen

Layout of OpenRefine, Rows vs Records

Figure 1

Screen capture showing OpenRefine in Rows mode.Screen capture showing OpenRefine in Rows mode.

Faceting and filtering

Clustering

Working with columns and sorting

Figure 1

Addition of Sort menu to OpenRefine grid after first sort command

Introduction to Transformations

Writing Transformations

Transformations - Undo and Redo

Transforming Strings, Numbers, Dates and Booleans

Transformations - Handling Arrays

Exporting data

Looking Up Data

Figure 1

At this point, your screen should be similar to this: Add column by fetching URLs screen capture