I'm frequently having trouble adding excel tables to maps or importing them into my geodatabase in Pro. I keep getting error messages that say the container is empty, but when I try to import the same table to my geodatabase in Arc catalog, it works just fine. Has anyone else had this problem? Why can't I import my table directly into Pro?
Most people don't take the time to format an excel table to ease the process of bringing it into other software.
This link will help
and quit skipping a step by trying to add directly, until you can format the perfect excel file and don't need the helper tool....
A big tip is only have the data you need on one sheet and treat each column as one data type (don't mix data)
Another tip is to ensure that your file names and paths are simple and preferably local.