POSTPONED: Workshop: Messy Data? Clean it up with OpenRefine!

Primary tabs

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

This workshop has been postponed until October 8, 2020. Registration will be open again in late August.

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 on April 30, 2020, 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.