AnsweredAssumed Answered

Import Excel into ArcMap 10.2

Question asked by psawyer_0324 on Mar 13, 2017
Latest reply on Mar 13, 2017 by Dan_Patterson

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. 

Outcomes