Adding Excel Lat Long Coordinates into ArcGIS – GIS Geography
If you have GPS data from the field or a long list of Excel lat long coordinates in a spreadsheet, giving them locations can be a daunting task for those starting out in ArcGIS. If you have latitude and longitude coordinates, you will have to prepare these columns in decimal degrees. Use this online decimal degrees converter or the conversion formula below. In ArcGIS, right-click the Layers data frame in the table of contents. Select properties. In the coordinate system tab, expand geographic coordinate systems. Click world and select WGS 1984. Now, add your excel data to ArcMap (file >, add data). Navigate to your Excel spreadsheet and double-click the sheet with the lat long coordinates. Right click the table and select display XY data. The X field should equal longitude. The Y field should equal latitude. This XY data will not be saved in memory once ArcGIS is closed. To save the points data, you need to create a feature class or shapefile. So right-click the event layer and export data (data >, export data). Click “use the same coordinate system as the data layer”. 5 Quick Steps: 1. Convert degrees/minutes/seconds to decimal degrees 2. Ensure data frame is set to WGS 1984 3. Add Excel table to ArcMap 4. Display XY Data 5. Save as feature class Follow these quick 5 step guide and turn an Excel spreadsheet with latitude and longitude coordinates into spatial data. good stuff. One question, you say: Ensure data frame is set to WGS 1984. Is there some reason I can’t use a data frame based on State Plane for our area? Or do DecDeg need to first come in via WGS 1984 and after I get the lat long populated, I can then convert to State plane. Thanks This article assumes the data was collected in lat, long coordinates. The first step is to set it to WGS 1984, after you’d project the data to State Plane, UTM or whatever projection. Hi, your link for the converter does not appear to be working for me. Would you have another suggestion for it? Very useful article! I followed through with these steps but when I import the excel document and hit “Display XY Data” the X and Y field do not have any options in the drop down menu. Do you know why this is the case? I have been trying to figure this out for hours now and believe it is a simple error on my part. Any assistance you provide would be greatly appreciated. Hi Kevin. I am not too sure why the X and Y field aren’t appearing in the drop down. I haven’t seen that happen before. Were you able to solve the problem? Does it feel like a big challenge to find LiDAR data sources? Master the art of attaining LiDAR at no cost with this list of 6 free LiDAR data sources. […] If you want free satellite imagery, there’s no better way to do it then follow this incredibly useful guide. We rank the best sources of free satellite data. […] It’s a head-to-head GIS software showdown with the star-studded lineup in the GIS industry- ArcGIS vs QGIS. Discover the differences between ArcGIS and QGIS […] Map all day. Geoprocess all night. All with gvSIG software. gvSIG emerged in 2004. It’s been fine-tuned for over a decade and is used around the world. […] Source.