OpenRefine is a powerful free and open source tool to clean, correct, codify, and extend your tabular data. Using OpenRefine will save you hours of manual editing and correcting of data.

Are you working with data organised in spreadsheets? Do you usually spend more time on data cleansing and data quality improvements than on data analysis? And do you want a powerful tool, that is free of charge and runs on every computer, including your local PC? If your answer to these questions is YES, then you should consider registering for this hands-on workshop.

In this hands-on workshop we will first introduce what OpenRefine is and what it can do. You will learn how to import your data into OpenRefine, how to find and correct errors in your data, how to transform data, and how to save and export your cleaned data from OpenRefine. Finally, we will point you to additonal resources.
Participating in this workshop does not require any prior knowledge of OpenRefine.
Installation instructions will be sent to you 1 week before the course starts.

This workshop is based on the Library Carpentry lesson OpenRefine.
 

Certificate

This course is part of the Certificate Course "Tools for Digital Research". In order to receive the Library Carpentry Certificate you also have to attend the other two courses.