Workshop: Messy Data? Clean it up with OpenRefine!

Thursday, October 8, 2020 - 10:00am to 3:30pm

Messy Data? Clean it up with OpenRefine!

I Hotel and Conference Center
1900 South First Street, Champaign

Driving Directions

Join the CARLI Created Content Committee at the I Hotel in Champaign for a workshop which introduces OpenRefine (, a free, open source tool used to organize, clean up, and transform your data. Presenters Tricia Lampron from the University of Illinois at Urbana-Champaign, and Greer Martin, from Loyola University Chicago, will provide an overview of this browser based application, as well as use cases that show the benefits of working with your data in OpenRefine. The first half of this workshop will demonstrate the basic functions to get you started on cleaning up your data, while activities in the second half include reconciling data against two different types of sources, library authority data and Wikidata. The workshop will also teach how to import data by making an API call in OpenRefine, and how to export your data in a different formats such as XML and JSON.

Lunch will be provided.

This workshop is intended for all CARLI members, but may be of special interest to those who work with spreadsheets, data, metadata, authorities, controlled vocabularies, and open data.

While the workshop will not be completely hands-on, participants are highly encouraged to bring their own laptops so they can work with their own dataset or some provided metadata during the workshop. Wifi and power strips will be available.

Registration will be available in late August. This workshop was rescheduled from its original April 30 date due to the COVID-19 pandemic. Those who were already registered for the April 28 date will have the first opportunity to register for this workshop.