I am trying to make a map using ArcMap 10.3 and adding Excel coordinates from a map. I originally converted addresses to lat/long using an online site. I have tried every suggestion I could find online and I can't figure how to get the points to show up. I've been able to upload the Excel file and add xy coordinates, but nothing shows up when I do. I only have 12 addresses/coordinate pair to add so I also tried to add them individually and couldn't figure out how. How can I fix this?
1) Save the excel doc as a .xls file. 2) Open ArcMap 3) Set the coordinate system to WGS84 if you have basic lat/long coordinates. 4) Add data (the xls doc) 5) Right click the table in the ToC and run the XY to point tool. 6) I recommend exporting the point file to a new layer.