Cant convert table of XY coordinates to Points properly

309
1
Jump to solution
02-28-2019 03:39 PM
DavidSchwab1
New Contributor

I

0 Kudos
1 Solution

Accepted Solutions
DanPatterson_Retired
MVP Emeritus

I opened the spreadsheet.  You have errors

Y is longitude 

X is latitude …. you have them switched

Your coordinate fields are indeed in decimal degrees (probably a GCS WGS84)

You have to get rid of blank rows and/or rows with no coordinates... this will cause failure with Excel to Table for sure

Your coordinates need to be in numeric fields... yours are left justified... make sure they aren't text but formatted as numbers as soon as you get rid of the rows with no coordinates

View solution in original post

1 Reply
DanPatterson_Retired
MVP Emeritus

I opened the spreadsheet.  You have errors

Y is longitude 

X is latitude …. you have them switched

Your coordinate fields are indeed in decimal degrees (probably a GCS WGS84)

You have to get rid of blank rows and/or rows with no coordinates... this will cause failure with Excel to Table for sure

Your coordinates need to be in numeric fields... yours are left justified... make sure they aren't text but formatted as numbers as soon as you get rid of the rows with no coordinates