X and Y Coordinate Selection Not Giving An Option of All The Headings From my Excel Spreadsheet

Question

Hello,

I am having issues trying to input my excel table into x an y coordinates. I have attached an image to show the headings that I have been using.

Once the table is selected there is only an option of latitude for both x and y coordinates. I have tried changing the titles and moving to a new spreadsheet but nothing is working

I have inputted the exact same layout of data for different locations already and it’s been fine.

MarcelSt-Germain · Answer

Hi,

I had some trouble to.  What I find is the type of data for my field was the source of the problem.  When inserting X and Y coordinates, Pro check for numeric field.  If not find, it doesn't show.

For me, since I use imported coordinate in text, I close the problem by making a calculate of that field in a numeric one and it's finely show in the parameters.

DanPatterson · Answer

Did you try Excel To Table (Conversion)—ArcGIS Pro | Documentation

to get the excel file into a geodatabase table first. From there you can use

XY Table To Point (Data Management)—ArcGIS Pro | Documentation

to create a point featureclass