Data Cleaning with Open Refine - Online

Data Cleaning with Open Refine - Online

Got messy data? Open Refine is a powerful, free open-source software tool for cleaning and transforming data in a way that is easy to reproduce. If you have ever struggled to remember exactly how you modified your data in Excel, give Open Refine a try!

Materials and set up instructions available in the CLE: Data Cleaning with Open Refine

 In this class we will cover the basics of:

  • importing data
  • faceting data to discover patterns
  • clustering data (as in cases where NYC and New York City should be the same name)
  • splitting data into multiple columns
  • exporting clean data

This will be an online class via Zoom conferencing. The zoom link will be sent out a week in advance.

When you register, the Library reserves class space for you. Since many of our classes have a waitlist, please cancel your registration if you can no longer attend.

Related LibGuide: Data Sharing & Data Management by Ariel Deardorff

Thursday, January 17 at 9:30am to 11:00am


Event Type

Class/Info Session


Students, Postdocs, Faculty, Staff




Data Science Initiative, data management, data sharing, open refine




UCSF Library
Contact Info


Event Registration Required

This event requires registration.