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
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.