When I create an XY event layer in ArcMap from an .xlsx sheet it automatically reads X and Y fields OR I am allowed to choose those from a dropdown menu. PRO does not read XY fields from .xlsx nor does it read the field names into a similar drop down menu. This small difference makes importing XY data into Pro very cumbersome. When I re-save the spreadsheet as a CSV file, PRO will read the field names and pre-populate X and Y fields but then it fails on execute with: ERROR 000055: Cannot create a Query Table for this workspace Failed to execute (MakeXYEventLayer).
Both identical .xlsx and .csv succeed in ArcMap without a glitch.
Why?
EDIT: As Kory pointed out the issue with reading field names from an Excel file is an existing bug. I was able to successfully create an XY event layer after reviewing the source data and again and ensuring all values in X and Y columns were numeric.