This tutorial will show you how to easily import or open Microsoft Excel file (.xlsx, .xls) on ArcGIS. I am using ArcGIS version 10.2.2 on this tutorial. It is very easy to import Excel data to ArcGIS geodatabase format. First, off course prepare the excel file. On this example, I have an excel file containing rock sample location. It has coordinates, and some other information in the excel table. To import, follow these steps.
On ArcGIS, go to ArcToolbox and go to Data Interoperability Tools. Then select Quick Import
Select Microsoft Excel from the list.
Press OK and you will see the overview for the data to be imported.
Next, provide the destination folder for the output staging geodatabase.
Press OK and you are done. Now open it on ArcMap