I must process an Excel file data but the format of my longitude and latitude coordinate are: Lat: -22 to -34 and Long: 9 to 18 in decimal degree. So i want to use Add XY tool into Arcgis10 to put my coordinate data, but i have meet some difficulties because two latitude and two longitudes. How to put the variation of latitude and longitude coordinates with Arcgis tool?
Modify your spreadsheet so that Latitude and Longitude are in separate columns. Each point should have its own row with one X and one Y. Also make sure that you format your cells so that they are number values, sometimes ArcGIS is finicky about this. Use this image as a template:
Save your excel spreadsheet and close it.
(1) Open ArcGIS and add the data using the Add Data icon, which is probably sheet1 within your spreadsheet.
(2) In the table of contents, right click on your table (sheet1), and select "Display XY Data"
(3) Fill in the X and Y fields with your lat and long and select the appropriate coordinate system. This should be a geographic coordinate system (likely WGS1984 or NAD1983). Select OK and your data points should be populated on the map.