Importing Excel Coordinates to ArcMap and Plotting

hi welcome to another tutorial today I'm going to show you how to add some coordinates which we have in Excel into arcmap here we can see in excel we have some stations 8 stations and then we have the longitude and latitude information and here in Google Earth we can see actually the real locations of those coordinates but today I'm going to show you how to add directly these information into our arcmap interface from this Google Earth map we can see that our stations are located within Singapore so I'm just going to go ahead and open our map and I have already prepared a shapefile of Singapore so I'm just going to add that as as a base layer for this exercise just go to our catalog and drag this and drop it over here now since we have a base layer once we import the station information to arcmap we will be able to see that very clearly so let's first go ahead and open our excel information so here you can see we have latitude and longitude information so I'm going to go ahead and save this file first go to file save as and the saving tab I'm going to go ahead and select Excel 97 to 2003 workbook somehow I have found out then if you save this in the latest Excel format arcmap will not be able to detect it I'm going to name this one as station coordinates ok now let's go ahead and open our map so just make sure that you are using your consistent with the coordinate system that you're using so if you want to check which coordinate system you're using currently you can go to layers and properties and you can see that right now my data frames coordinate system is WGS 1984 and it's the same coordinate system with with my layer as well ok the next thing is now to import the data that we saved so go for go to file add data and add XY data so from here we can browse to the place where we saved our coordinate information you can see here station coordinates dot XLS click add and click on the sheet 1 all right now if you go back to the to the Excel document again you can see that my my X values are corresponding to longitude and my Y values are corresponding to latitude so let's come here and make sure that in xfield I have selected the longitude and in Y field I have selected the latitude and here in case if the coordinate system is not been selected over here you have to make sure that you are selecting the same coordinate system as your data frame and the layer so in my case it's already selected WG is 1984 and I'm going to simply click okay all right now you can see that we have successfully added the data and it contains the station name longitude and latitude information as well and I can also make some changes to the style if we select the triangle decrease the size a little bit and maybe change the color okay that's about it for this tutorial I hope you enjoyed thank you and if you have any questions kindly leave a comment below

Channel: GeoDelta Labs

Views: 77,517

Rating: 4.9374185 out of 5

Keywords: ArcGIS, ArcMap, QGIS, Plotting, Maps, Coordinates, Importing, Excel, Singapore, Asia, GIS, Map making

Id: a2UeMNGCoY0

Length: 4min 29sec (269 seconds)

Published: Tue Feb 05 2019