Import Excel coordinate lists to a map with CSV
Coordinate lists often arrive as spreadsheets. With clean columns they can become field points.
Field takeaways
- Spreadsheet points usually travel to the field as CSV.
- Use clear point name, easting, northing, Z and note columns.
- Coordinate order and CRS must be stated.
- Check known points after import.
- MapLab Survey connects CSV points with layers and exports.
The clean path from Excel to the field
Rather than using the spreadsheet directly on site, export it as CSV. CSV is a plain text format; with the right separator, clear column names and correct decimals it opens in most mapping and GIS software. What travels is the meaning of the columns, not the styling of the table.
Column layout
A practical table starts with point_name, east_x, north_y, z, note. Some crews use X for north and Y for east, and some lists put latitude first — which is why writing "east" and "north" instead of "x" and "y" prevents field errors, and explicit headers remove half the problems before they start.
Separators and decimals
A file saved under a different regional setting can turn 41,5 into two columns or into 415. Open it in a text editor and look at the raw numbers before importing; that thirty-second look prevents the surprise of points landing on another continent.
Check before you stake
After importing into MapLab Survey, do not go straight to stake-out. First verify one point you can recognise on the ground — that is the only way to know the whole list landed correctly. If the points sit in the right area, clarify the layer name and put the targets to work.
Let the filename carry information
A name like "blockA_stakeout_TM33_rev05.csv" is far safer than "final_list.csv". A coordinate list without its system is ambiguous: put the EPSG code in the file, the filename and the message, and keep the revision with it.
Try these steps on your own phone.
MapLab Survey handles RTK/GNSS point capture, drawing, area and volume calculations and coordinate conversion, then exports to DXF, KML/KMZ, GeoJSON, Shapefile, GeoPackage, NCZ or CSV. Capture, calculation and export work offline. Live NTRIP corrections and online basemaps need a connection.
Frequently asked questions
Can Excel coordinates open on a map?
Yes, by exporting to CSV.
How should X/Y be ordered?
Use explicit easting/northing labels.
Can CSV be used for stake-out?
Yes, after checks.
Is Z required?
Only when height is needed.
Technical references
The field guidance in this article is aligned with the technical and official references below.
Related: CSV coordinate list · Go to coordinate · Field layers · MapLab Survey