XY Table to Point not working

127
1
05-13-2021 11:24 AM
Labels (1)
Sara_Jordan
New Contributor

I'm just starting to use ArcGIS Pro and having trouble getting my excel table with coordinates to convert into points. Why can't I select the appropriate columns in the XY Table to Point Tool?  

Capture.JPG

0 Kudos
1 Reply
JayantaPoddar
MVP Esteemed Contributor

That degree symbol is causing the issue. It also makes the fieldtype as "TEXT", whereas the acceptable fieldtype for X and Y field should be numeric (Float, Double, etc.).

If possible, remove the degree symbols in the excel file itself, and ensure the cell format is "numeric".

__________________________________________________________________________________________________

Alternatively, you may add two more fields, X and Y (Float or Double) in the geodatabase table, and use Field Calculator to input the values of Longitude and Latitude in them respectively.

Following would be the expression in Field Calculator (Python Parser)

X

 

 

!Longitude!.split("°")[0]

 

 

 

Y

 

 

!Latitude!.split("°")[0]