Skip To Content

Streamlined Data Cleaning in OpenRefine

Ended Aug 7, 2023
2 credits

Spots remaining: 1

Enrollment is closed
Add yourself to the wait list and you'll be auto enrolled when a spot opens

Add to Wait List

Full course description

Term: Fall 2023

Date: August 7th, 2023

Time: 11:00am - 1:00pm

Location: Online Only

Instructor: Nathaniel Porter, Ellie Kohler, & Corrine Guimont

Presented By: University Libraries (LIB)



Learn how OpenRefine, a free and open source tool, can make the process of cleaning data from spreadsheets, surveys and other sources both faster and more transparent. This workshop teaches learners how to import data into OpenRefine and use faceting, filtering, clustering and transformations to identify and correct errors and improve the usability of datafiles. Additionally, learners will practice saving reproducible and reusable workflows and exporting data for use in other software. 

This workshop is based on the Library Carpentry OpenRefine lesson and is recommended for anyone who frequently works with messy text or spreadsheet data. No experience is necessary, but learners will need access to a computer with Zoom and OpenRefine throughout the workshop. OpenRefine is free software that is approved for use at Virginia Tech, but may require administrator privilege or assistance from IT to install on a VT-owned computer.

If you are an individual with a disability and desire an accommodation, please email at least 10 business days prior to the event.