addind excel in arcgis

[raoufbouamra]

 when i add excel point i can't specify X OR y, any solution?

[LongDinh · Accepted solution]

Hi @raoufbouamra,

You should convert your xlsx file to a csv before adding it to ArcGIS Pro. You can use the this guide to create points from a table.

ArcGIS uses some keywords to automatically detect spatial field names (e.g. X, Y, Latitude etc...) in CSV, TEXT and GPX files. They can be found here.

Hope this helps!

[raoufbouamra]

thanks you so much my friend you saved me , i hope you will find only hapinessse in your life. take care

[DanPatterson · Accepted solution]

If you intend to use excel, you should read the guiding principles to be aware of its limitations.

Work with Microsoft Excel files in ArcGIS Pro—ArcGIS Pro | Documentation

Also, in addition to the above, make sure you explicitly format your coordinate columns as double/float and ensure there are no blank cells in the sheet.