Open Refine for working with large spreadsheets

Who: Titus Brown (instructor)

When: October 20th, 2016

Times: 9:15am-12:30pm

Where: 1043 Valley Hall, UC Davis campus

Cost: there is no fee.

Contact the instructor with any questions.

This workshop is open to everyone, including graduate students, postdocs, staff, faculty, and community members. We have extra space for UC Davis VetMed affiliates; contact the lead instructor if you are an SVM affiliate.


This half day workshop provides an introduction to working with large spreadsheets, and using the OpenRefine tool to clean and correct spreadsheet data. It is intended for anyone who uses spreadsheets for data analysis.

Topics overview

  • Techniques for managing large spreadsheets
  • Exploring and correcting with OpenRefine
  • Recording and applying recorded changes


  • 9:15am-10:30a - spreadsheets
  • 10:30a: Coffee break
  • 10:45a-12:15p - OpenRefine

Installation instructions

Please follow the instructions under “Before we get started” on this page.

LICENSE: This documentation and all textual/graphic site content is licensed under the Creative Commons - 0 License (CC0) -- fork @ github. Presentations (PPT/PDF) and PDFs are the property of their respective owners and are under the terms indicated within the presentation.