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 links on the right. 

OpenRefine Basics

Download OpenRefine

OpenRefine User Manual

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.

Confluence Documentation | Web Privacy Policy | Web Accessibility