Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

Tip

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

Auibutton
titleDownload OpenRefine
typestandard
urlhttps://openrefine.org/download.html

Auibutton
titleOpenRefine User Manual
typestandard
urlhttps://docs.openrefine.org/

Demo Recordings

Multimedia
nameOpenrefinedemo2.mp4
width500
height300

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

OpenRefineDemoTranscript.vttDemo Transcript (vtt file)

Slides


Widget Connector
width600
urlhttps://docs.google.com/presentation/d/1dqv-w7cJCgV7mVH5cLp9sHN2LwpGR1qyM9MOOEWYbF0/edit?usp=sharing
height400

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