Using spreadsheet programs for scientific data

Data Carpentry

This lesson was recently cloned and expanded from Data Carpentry's "Better Spreadsheet Skills for Ecologists". Data Carpentry's aim is to teach researchers basic concepts, skills, and tools for working with data so that they can get more done in less time, and with less pain. The lessons below were designed for those interested in working with data in .


  1. Introduction
  2. Formatting data
  3. Common formatting problems
  4. Dates as data
  5. Quality control
  6. Exporting data
  7. Data Format Caveats
  8. Functions
  9. Regular Expressions
  10. iDigbio Portal Exercise