XY Table to Point not working

05-13-2021 11:24 AM
Labels (1)
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?  


0 Kudos
1 Reply
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)














Think Location