victor.lejona@cenex.co.uk

ArcGIS Pro - Excel Lat Longs not plotting correctly, merging to one point

Discussion created by victor.lejona@cenex.co.uk on Jun 21, 2019
Latest reply on Jun 21, 2019 by victor.lejona@cenex.co.uk

Hello, i'm having issues whilst attempting to import a number of lat longs stored in an excel worksheet, to plot them in Arc GIS pro.

When attempting to plot say 600 points, they will arbitrarily (to my mind) all be placed at one of the lat longs, so i will have all 600 points at one lat long.

I can get it to work with lots of copy pasting into new sheets, trying csv, xlsx etc, but there seems to be no logical reason as to why it will work or not work, and i have wasted numerous hours fiddling with excel sheets to get them to import.

 

Any help would be greatly appreciated.

Outcomes