Clean Data: Data Organization in Spreadsheets [Online]: 2021-06-18


March 20, 2020 update: While the physical SFU Libraries are temporarily closed due to COVID-19 measures, we are happy to continue to support you with any research data management questions remotely. Please feel free to contact us by email at during this time, and we can set up a meeting via video conferencing or telephone.


Friday, June 18, 2021 - 10:30am to 12:00pm
via Zoom (link will be sent to participants 24 hours before the workshop/event begins)

All times are Pacific Time Zone (Vancouver, BC, Canada).

Do you work with research data in spreadsheets? If so, this workshop is designed for you! Good data organization is the foundation of your research project, and so we will be covering the best practices for Data Organization in Spreadsheets, according to Data Carpentry. Then we’ll look at formatting values, fixing dates, dealing with missing data, merging/splitting columns, variable names, and more. By the end, you’ll be prepared to take your spreadsheets to the next level. Note that this workshop will not teach you how to use macros or code inside spreadsheets; this is mainly because such approaches are not efficient for data analysis, and are not easily reproducible.

Carla Graebner
Eirian Vining

Import this workshop into a calendar