Geographic Information Systems (GIS) Services Frequently Asked Questions:

_{How do I create a shapefile from Latitude/Longitude Coordinates?}

Follow the below instructions to turn an Excel file containing latitude/longitude coordinates into a Shapefile using ArcMap.

Click here to watch a demo of this process
Please Note: Flash player plugin is required to view this demo.

How to create a shapefile from XY coordinates using Excel and ArcMap

1. Open ArcMap.
2. Add your Excel worksheet (97-2003 or 2007) to ArcMap 9.3 just as you would spatial data, (File -> Add Data or use the Add Data button).
3. Filename.xls(x) will appear in the table of contents (TOC). Right-click on the worksheet name in the TOC, and choose "Display XY Data..."
   In the dialog box, the X Field should be Longitude and the Y Field should be Latitude.
   If you know the spatial reference of the input coordinates, click the "Edit..." button and select it.
   For example, if your coordinates are based on a WGS84 Geographic Coordinate System, Click the "Edit..." button, then the "Select..." button, Geographic Coordinate Systems -> World -> WGS 1984.prj -> OK.
   If you do not select a spatial reference, the shapefile will have an Unknown Coordinate System.
   Click OK.
4. The coordinates should plot as a point event theme. Note that it is not a shapefile, just an event theme. To create a shapefile from the event theme, right-click the layer in the TOC and select Data -> Export Data... Then select a location for the new shapefile, name it and click OK.

TIP:
Make sure that coordinates South of the Equator and West of the Prime Meridian are negative, or your points will plot in the wrong hemisphere!

For more GIS assistance,
Please contact Amanda C. Henley, GIS Librarian
amanda.henley@unc.edu
(919) 962-1151

Can't Find What You Are Looking For? How Can We Help You?