Importing data from a spreadsheet
There has been an increase in queries regarding the import of coordinate values from spreadsheets into ArcGIS Desktop and ArcGIS Pro. With that in mind, find a checklist that hopefully will encourage, when dealing with this type of data, the understanding of coordinate values, their implications of how they are managed and the relationship to coordinate reference systems in ArcGIS software.
Check List
- Check coordinates are in the order you expect (e.g. Lat/Long or Long/Lat or X, Y; Y, X and W, E; -X, -Y etc)
- Check there are no NULLs or other errors
