XY Table to Points, Long and Lat attributes wont appear

Question

Hello,

I am trying to use the XY table to points tool to load in around 2000 data points. Each point has the following data:

The issue is, every time I put the table into ArcPro and try to use the tool, the fields wont even appear in the drop down menu. I have tried changing the cell format in excel before I bring it in, but it does not work as a text field or numeric field. Any idea on how to fix this? I am likely missing something obvious.

Thanks.

Robert_LeClair · Answer

If you'd like to gain some valuable experience converting XY tabular data a geodatabase feature class, I recommend taking this tutorial first.  Then you may apply that knowledge to converting your data to a feature class.  Create points from a table—ArcGIS Pro | Documentation

DanPatterson · Answer

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

your data are in the wrong format for this tool, it needs

* Decimal degrees in a geographic coordinate system
* Linear measurements in a projected coordinate system that use numbers to indicate the position with an x- and y-offset from an origin location

With no text or punctuation or zonal letter designators

See

Convert Coordinate Notation (Data Management)—ArcGIS Pro | Documentation