from xy coordinates to feature class

Question

Hi,

I have XY Coordinates in xls and I want to convert these in feature class layers.

I tried by using display XY data in ArcGIS data and ArcGIS pro but I am getting an error.

ERROR 000308  Invalid field type

Please review and let me know how to resolve this issue

XY.xlsx

Clip_1192.jpg

ShengdiZhang_0-1638411366537.png

JakeSkinner · Answer

Hi Udaya,

I believe Dan was correct that the degree sign is causing the issue.  I removed the degree sign, and then executed the Excel to Table tool.  I was then able to convert the geodatabase table to point data.  Attached is the Excel table.

XY.xlsx

Study Area.jpg

SrinivasaRao1 · Answer

Hi, Sorry to say.. it couldn't work

DanPatterson_Retired · Answer

the degree sign, I hope, is purely for display... otherwise the values are not numbers but text

Excel To Table—Conversion toolbox | ArcGIS Desktop after you clean up the excel file

and

XY Table To Point—Data Management toolbox | ArcGIS Desktop or

Make XY Event Layer—Data Management toolbox | ArcGIS Desktop