XY Table to Point not working

Sara_Jordan — Thu, 13 May 2021 18:24:01 GMT

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?

Re: XY Table to Point not working

JayantaPoddar — Thu, 13 May 2021 19:19:31 GMT

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)

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

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

topic XY Table to Point not working in ArcGIS Pro Questions

XY Table to Point not working

Re: XY Table to Point not working