Beginner's Guide to OpenRefine

This guide contains a basic introduction to OpenRefine, a tool useful for data transformation and validation. Many metadata workflows make use of OpenRefine to iron out inconsistencies, link to external authorities, and export to different formats. 

Start by reviewing the demo recordings below (transcripts and slides are also available.) If you'd like more background information on OpenRefine as a program, see the buttons below.

 

 

 

Demo Recordings


This video reviews basics on creating projects in OpenRefine, how to use facets and clusters to group data, creating, deleting, and moving columns, and a handful of basic transformation scripts to edit data.

Demo Transcript (vtt file)

Slides


This slideshow contains similar information to the demo video above. All images in the slideshow contain alt text.