Data Cleanup With OpenRefine

Data Cleanup With OpenRefine

About This Session:

Have you ever found yourself with a data set that required some "cleaning up" before becoming useful? A database export with inconsistent date formats? A list of geographical locations in need of normalisation against an authority file? Doing these tasks in Excel can take a long time and lead to human error. OpenRefine is a powerful, spreadsheet-like tool that is built to automate precisely this kind of work. This hands-on session will introduce OpenRefine and get participants started on their own data clean-up project.

Learning Goals:

- Learn how to use OpenRefine to import, clean up and export data sets

- Learn how to use facets to explore a data set, e.g. for trends analysis

- Hands-on session. This will be a live session (no slides) demonstrating OpenRefine. Participants will be encouraged to follow along and try the software out for themselves.

About the Presenter:

Thomas Guignard works at the Ontario Colleges Library Service (OCLS) in Toronto. He also volunteers as an instructor with Software Carpentry and Library Carpentry, teaching basic computing skills to librarians and researchers to help them do more with less pain.

Social media handles: @ocls @timtomch (and @concretelibraries on Instagram)

Members: 45.00
Non Members: 55.00
4/9/2019 12:00 PM - 4/9/2019 1:00 PM

Sign in

To register for an Education Institute session, please enter your account username and password below. Member discounts are automatically applied.

Once you've registered for a session, a payment receipt will be emailed to the address provided. Session connection instructions are sent the day prior to the session.

Sign In

Create an account

Don’t have an account? Please create a free account with us in order to register for EI sessions.


NOTE: If you are a Partnership member, please contact Esteban Dorado-Troughton (416.363.3388 ext 232) upon completion of your account.

Having trouble? Try the Registration FAQ or contact our Education team at