Introduction to OpenRefine

UC Santa Barbara Library


April 14, 2022

2:00 pm - 6:30 pm PST

Instructors: Renata Curty, Jon Jablonski

Helpers: Amanda Ho, Greg Janee, Kristi Liu

Some adblockers block the registration window. If you do not see the registration box below, please check your adblocker settings.

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: This training will take place online. The instructors will provide you with the information you will need to connect to this meeting.

When: April 14, 2022. Add to your Google Calendar.

Requirements: Participants must have access to a computer 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 dedicated to providing a positive and accessible learning environment for all. Please notify the instructors in advance of the workshop if you require any accommodations or if there is anything we can do to make this workshop more accessible to you.

Contact: Please email for more information.

Roles: To learn more about the roles at the workshop (who will be doing what), refer to our Workshop FAQ.


For a few of us, teaching Carpentry workshops is part of our job descriptions, but most are volunteers from around campus and the academic Santa Barbara community - including researchers, post-docs, graduate students, faculty, and staff. Meet the instructors and helpers:

Renata Curty | she/her | Social Sciences Research Facilitator at UCSB Library Research Data Services.
Amanda Ho | she/her | Library staff at the Interdisciplinary Research Collaboratory for instructional design and support.
Ryan Horne | he/him | Digitial Humanities Research Facilitator by day, chef for three little ones by night.
Kristi Liu | she/her | A UCSB Geography alum and Library staff member, Kristi spends her free time gluing tiny little GPS units to bees and monitoring regional meteorology

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.

Collaborative Notes

We will use this collaborative document for chatting, taking notes, and sharing URLs and bits of code.


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

Pre-workshop Survey

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.

Install the videoconferencing client

If you haven't used Zoom before, go to the official website to download and install the Zoom client for your computer.

Set up your workspace

Like other Carpentries workshops, you will be learning by "coding along" with the Instructors. To do this, you will need to have both the window for the tool you will be learning about (a terminal, RStudio, your web browser, etc..) and the window for the Zoom video conference client open. In order to see both at once, we recommend using one of the following set up options:

This blog post includes detailed information on how to set up your screen to follow along during the workshop.


You may find instructions to install the nesessary software and data on the Setup page: link to setup page.

OpenRefine is a free, open-source Java application. You can download OpenRefine from Please download the latest stable version, choosing "kit" for your operating system. Current versions of the Windows Kit with embedded Java and Mac Kit include everything you need to run OpenRefine. The Linux Kit and traditional Windows Kit require a Java Runtime Environment (JRE) installed on your system