How to add points from a CSV file to your map

The Add points from a file marker tool allows you to upload a CSV file containing data you have collected and create points on your map. For example, if you have been out on fieldwork and collected data in a spreadsheet or mobile app, you can upload that data and represent points on your map. Your points must have a location element to them, either Easting and Northing coordinates, Latitude and Longitude coordinates or a full GB Postcode. The data you have collected might be recording certain tree species, places you have observed micro climatic conditions, locations of graffiti or the postcode of people you have surveyed in a tourist hot spot.

CSV file format

Your CSV file must conform to a few specific rules in order for it to be uploaded.

  • All files must be in the .csv (Comma Separated Values) file format. These files most easily created using Microsoft Excel.
  • Files can have a maximum of three columns (further detail below)
  • All points must be located within the geographic extent of Great Britain
  • Labels - the maximum number of characters that will be displayed is 15 (you can have up to 200 characters, but only the first 15 will be displayed)

Specific formatting of columns in the files:

  • For Postcodes:
    • One required column containing postcodes and the column must be named Postcode in the header row.
    • One optional column containing a label which can be up to 15 characters long. The column must be named Label in the header row.
    postcode file example
  • For Easting/Northing:
    • Two required columns containing easting and northing values. These columns must be named as Easting and Northing in the header row.
    • One optional column containing a label which can be up to 15 characters long. The column must be named Label in the header row.
    easting northing file example
  • For Latitude/Longitude:
    • Two required columns containing latitude and longitude values (in decimal format) These columns must be named Latitude and Longitude in the header row.
    • One optional column containing a label which can be up to 15 characters long. The column must be named Label in the header row.
    lat long file example
  • For Ordnance Survey Grid References:
    • One required column containing OS Grid References (these can be 2-4-6-8-10 or 12 figure Grid Reference points) and the column must be named gridref in the header row.
    • One optional column containing a label which can be up to 15 characters long. The column must be named Label in the header row.
    grid ref example

How to add points:

  1. Ensure that your CSV file is in the correct format
  2. Click on the Add points from a file marker tool add points icon
  3. Navigate to your CSV file and click upload

  4. upload point file
  5. Your file will be checked and points uploaded to your map.
Sites examples

Error messages help

If you have uploaded a CSV file and received an error message, please follow the checklist to identify the problem. If you are having trouble uploading your file, please contact the EDINA Helpdesk at digimap.schools@ed.ac.uk and send us a copy of your file.

  • Non supported file type - only CSV files can be uploaded.
  • No features identified in your file. Please ensure there are suitable records in your CSV file.
  • Your file does not contain acceptable column headings - Add the correct column names in the first row.
  • Your file contains too many features - There is a maximum of 500 annotation features that can be displayed on the map. Please reduce the number of points in your file.
  • File is too big to be imported - Please ensure your file is less than 10MB in size.
  • Points are outwith the range of Great Britain - Please only upload points that have coordinates or a postcode located within GB.
  • Invalid postcode - please check the postcode and edit. If the postcode is old, it may not be in use anymore and therefore invalid.

iPad: The add points from file tool is not available when using Digimap for Schools on an iPad. This is because iPads do not support file upload in a browser.