I have an excel spreadsheet for office 2010 and i have version 10.2 of ArcMap. I have tried several file extensions as a 97-2003 excel file and csv. I can display the lat / long but the data is not aligning correctly with my other data. I clicked on the dbf and tried to create a feature class from x/y table. The x and y fields were empty. I went through the table and removed everything except oid , lat and long. The csv file I can display x/ y when I created an x/y event shapefile i set the coordinate system but the layer still will not align correctly. I just need to know if i am using the correct excel file extension csv when i display the x/y in arcmap. Why this layer will not align correctly.