Skip to content

CSV Format

For convenience and easy spreadsheet editing MilGPS supports importing and exporting waypoints in CSV file format. The easiest way to generate a suitable CSV file to use as a template is to export one or more waypoints from the app as a CSV file.

CSV files need to be comma delimited with a header row. Commas and double quotes must be escaped in accordance with RFC 4180.

Required Columns (Lat/Lon)

  • Name (waypoint name)
  • Latitude (WGS84 latitude, +/- decimal degrees format)
  • Longitude (WGS84 longitude, +/- decimal degrees format)

Required Columns (MGRS)

  • Name (waypoint name)
  • MGRS (WGS84, full grid reference with 1m precision)

Optional Columns

  • Altitude (metres above sea level)
  • Description (waypoint description)
  • Symbol (0 for cross, 1000 for circle, 2000 for triangle, 3000 for square, 4000 for star. Add 100-135 for characters from 0...Z, 200 for exclamation mark and 201 for question mark. eg, a square with the number 1 would be 3000 + 101 = 3101. Characters cannot be added to the cross.)
  • Color (red, orange, yellow, blue, green, cyan, magenta)

Note

Numeric values should not contain symbols other than numbers, a decimal point and + or -.

Lat/lon and MGRS columns cannot be present in the same CSV file.

If the color column or symbol column is present, valid colors or symbols are required for each waypoint.