← Back to Upload

Formatting Guidelines

We standardize every record to Darwin Core (DwC), the international standard for biodiversity data. Your file doesn't need to already be in that format. It can have any number of columns; just make sure the ones below are included, using these exact header names. Any other columns you upload are kept too, not discarded.

Required on every row:

  • scientificName (e.g. Cardinalis cardinalis) or vernacularName (e.g. "Northern Cardinal") if you don't know the scientific name
  • eventDate — when it was observed, e.g. 2024-06-28 (a year alone, e.g. 2024, is fine for older records)
  • recordedBy — who observed it
  • decimalLatitude + decimalLongitude, or locationRemarks — a text description confirming the record is on or near WashU's Danforth Campus (e.g. "near Brookings Hall")

Note: the upload form doesn't yet support setting a date, observer, or location once for the whole file. Please repeat these as their own column on every row, even if the value is the same throughout.

Optional, but useful if you have them:

  • organismQuantity — count of individuals (defaults to 1)
  • organismID — only for individually marked or tracked organisms (a tag, band, collar, or accession number). Use the same value every time you record that same individual, so repeat observations can be linked. Leave blank for one-off sightings, and put a per-row record number in sourceRecordID instead.
  • occurrenceRemarks — free-text notes (e.g. "heard only", "flyover")
  • vitalityalive, dead, or cannot be determined
  • lifeStageadult, juvenile, larva, egg, etc.
  • associatedMedia — photo or audio URLs
  • sourceRecordID / sourceURL — your own record ID or a link to the original list

This is one example of a well-formatted upload. Your file doesn't need to match it exactly:

scientificName vernacularName eventDate recordedBy decimalLatitude decimalLongitude locationRemarks organismQuantity occurrenceRemarks vitality lifeStage associatedMedia sourceRecordID sourceURL
Cardinalis cardinalis Northern Cardinal 2024-06-28 Jane Smith 38.6491 -90.3098 1 Singing from the canopy; heard only adult JS-2024-001
Quercus rubra Northern Red Oak 2024-06-28 Jane Smith 38.6487 -90.3105 1 alive JS-2024-002
American Robin 2024-06-15 Jane Smith Near Brookings Hall, WashU Danforth Campus 3 Foraging on the lawn adult https://example.com/photo1.jpg JS-2024-003
Acer saccharum Sugar Maple 1998 Campus Ecology Survey Danforth Campus, near the quad 1 Historical record; exact location approximate dead CES-1998-014

Download sample CSV

← Back to Upload