Select to view content in your preferred language

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

756
2
01-08-2024 11:40 AM
LaurenWilliams23
New Contributor

IMG_9791.jpeg

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. 

0 Kudos
2 Replies
DanPatterson
MVP Esteemed Contributor

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


... sort of retired...
0 Kudos
MarcelSt-Germain
Frequent Contributor

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. 

0 Kudos