Erasmus-Staff Mobility Program : OpenRefine Workshop

Universitat Pompeu Fabra Library, Barcelona, Spain

Nov 15, 2022

10:00 am - 14:00 pm CEST

Instructors: Tuelo Ntlotlang,

Helpers: :Rosa Montañà,

General Information

Library Carpentry is made by people working in library- and information-related roles to help you:

Library Carpentry introduces you to the fundamentals of computing and provides you with a platform for further self-directed learning. For more information on what we teach and why, please see our paper "Library Carpentry: software skills training for library professionals".

Who: The course is for people working in library- and information-related roles. You don't need to have any previous knowledge of the tools that will be presented at the workshop.

Where: Universitat Pompeu Fabra, Library Barcelona-Room 40.047B. Get directions with OpenStreetMap or Google Maps.

When: Nov 15, 2022 . Add to your Google Calendar.

Requirements: Participants must bring a laptop with a Mac, Linux, or Windows operating system (not a tablet, Chromebook, etc.) that they have administrative privileges on. They should have a few specific software packages installed (listed below).

Accessibility: We are committed to making this workshop accessible to everybody. Please note that the following has been arranged :

Materials will be provided in advance of the workshop and you will be able to ask organisers for extra materials if needed in advance. If we can help making learning easier for you

Contact: Please email or for more information.

Who can attend?: This workshop is designed for Universitat Pompeu Fabra, Library staff. No programming experience is required

Code of Conduct

Everyone who participates in Carpentries activities is required to conform to the Code of Conduct. This document also outlines how to report an incident if needed.


Please be sure to complete these surveys before and after the workshop.

Pre-workshop Survey

Post-workshop Survey


Day 1

08:30 Introductions
09:30 Pre-workshop survey
10:00 Data Cleaning with OpenRefine
11:30 Health break
12:00 Data Cleaning with OpenRefine
13:30 Health break
14:30 Wrap-up
16:30 Post-workshop survey


To participate in a Library Carpentry workshop, you will need access to software as described below. In addition, you will need an up-to-date web browser.

We maintain a list of common issues that occur during installation as a reference for instructors that may be useful on the Configuration Problems and Solutions wiki page.


OpenRefine is a free open-source tool that makes organizing, editing and cleaning up messy data easier through clustering, facecting, advanced find and replace in a spreadsheet like environment. Please find instructions to install it and the data used in the lesson.

Follow the instructions on the lesson to install OpenRefine on your computer.