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

buttons below.


Auibuttongroup
an.spaceKeyutlmetadata
id0jenm8ml4rm9
alignmentcenter
directionhorizontal

Auibutton
externalUrlhttps://openrefine.org/download.html
color#0052CC
filterSpacefalse
destinationexternalUrl
iconatlaskit-ArrowDownCircleIcon
textColorPaletteDefault
titleDownload OpenRefine
typestandard
textColor#FFFFFF
url
targettrue
selectedUrlhttps://openrefine.org/download.html
an.spaceKeyutlmetadata
idxy18vc9xlfh
backgroundColorPaletteDefault
Auibutton
externalUrlhttps://docs.openrefine.org/
color#0052CC
filterSpacefalse
destinationexternalUrl
iconatlaskit-BillingIcon
textColorPaletteDefault
titleOpenRefine User Manual
typestandard
textColor#FFFFFF
url
targettrue
selectedUrlhttps://docs.openrefine.org/
an.spaceKeyutlmetadata
idrpbyfxmt27n
backgroundColorPaletteDefault


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