Submitting data

How to upload from CSV

This is for staff accounts only.

The file you import must be saved as a file of type *.CSV (Comma Separated Values). Use the following column titles to ensure that the data will be matched to the correct fields in the database:

• Date - dd/mm/yyy or yyyy-mm-dd format.

• Recorder name - name of the recorder

• Species - species name which must match one of the available names from the UKSI list

• Certainty - Certain, Likely or Uncertain

• Quantity - free text, e.g. a numeric count or other abundance indicator

• Sex - not recorded, male, female or mixed

• Stage - not recorded, adult, pre-adult or other

• Identified by - name of the person who identified the species

• Sensitivity precision - for sensitive records, specify 1000, 10000 or 100000 as the size of the square to blur the record to

• Location - site name

• Spatial reference - Ordnance Survey grid reference format

• Habitat - habitat name picked from the list available on the Enter a Casual Record form

• Comment - free text

When you import the data, the system will attempt to automatically match up the column titles to database fields. If there are any unmatched columns you will be offered the chance to match them up on a Column Mapping screen.

After importing, all successful rows will go straight into the database. if there are any errors you will be offered a file download containing just the rows with errors. The last columns explain the error. Download the file and fix the errors, then upload just this single file to complete the import.

An example

Here is my excel sheet with the appropriate columns. You can see that I have misspelled the species name in the second row.

I navigate to your Nature Counts site ../import and click choose file then click upload