Skip to Main Content

UC Carpentries Workshop: Tidy Data with Spreadsheets

Event box

Image contains text: UC Carpentries, Data and Software Skills; September 8-23, 2026, Join learners from across the UC Community.  Images includes cartoons of UC mascots including anteater, bobcat, bear, horse, banana slug, and raccoon

Good data organization is the foundation of any research project. Most researchers have data in spreadsheets, so it’s the place that many research projects start.

In this lesson, you will learn:

  • Good data entry practices - formatting data tables in spreadsheets
  • How to avoid common formatting mistakes
  • Approaches for handling dates in spreadsheets
  • Basic quality control and data manipulation in spreadsheets
  • Exporting data from spreadsheets

In this lesson, however, you will not learn about data analysis with spreadsheets. You will learn how to think about data organization and some practices for more effective data wrangling. With this approach you can better format current data and plan new data collection so less data wrangling is needed.

Register for the event, and check out other UC Carpentries Workshops, here: https://www.tim-dennis.com/2026-09-08-uc-carpentries/

Date:
Tuesday, September 8, 2026
Time:
9:00am - 12:00pm
Categories:
Data & Digital  

Host/Presenter(s)

Rachel Torres

Email Newsletter

Library Workshops Newsletter