How to create shapefile from XY coordinates in Excel?

How to create shapefile from XY coordinates in Excel?

How to create a shapefile from XY coordinates using Excel and ArcMap: Open ArcMap. Go to File -> Add Data -> Add XY Data. In the “Add XY Data” dialog box, browse to your Excel file (can be in Excel 97-2003, 2007, or 2010), and select the worksheet that contains your table of coordinates.

What should the Y and X fields be in a shapefile?

In the pop-up window, 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 “Coordinate System of Input Coordinates…” button.

How to create a shapefile from a list?

Just substitute your list for the parts= argument to Writer.poly, and set whatever fields you would like to associate with your shapefile. One easy (one time) solution is to use the QuickWKT Plugin. Transform your list into a EWKT string by adding a the header with the SRID and the type of geometry. Add a comma in the end of each XY pair.

How to import XY data tables to ArcMap?

To add the data from the .dbf, .csv, .txt or .prn file to ArcMap, navigate to Tools > Add XY Data and select the file. In version 10.0, click the Add Data button. Right-click the table name and select Display XY Data. Warning: At version 10.0, ArcMap applies the coordinate system of the Data Frame to the XY Data.

How to make an Excel file into a shapefile?

If so, you could create this as a point shape file, then use the fishnet command to create a “grid” of square polygons over the top of the points and joint the data that way. With the name “Tract”, there might already be a polygon shapefile of this.

How to save XY data tables to ArcMap?

Navigate to File > Save As, and select a supported format from the choices available in Excel. Click Yes if Excel prompts that certain formatting is not supported in this file format.

What is the coordinate system for the road shapefile?

The road shapefile has the WGS_1984_UTM_Zone_42N Projected Coordinate System and GCS_WGS_1984 Geographic Coordinate System and whose whose units (as far as I can tell) are in meters.

How to add x y data as a layer?

Steps for adding x,y data as a layer 1 Click File > Add Data > Add XY Data. 2 Select the table that contains x,y coordinate data. 3 Identify the columns that hold the x- and y-coordinates (and, optionally, the z-coordinate). 4 Specify the coordinate system.

How to convert UTM coordinates to shapefile?

Click on Layers ‣ Add Delimited Text Layer. In the Create a Layer from a Delimited Text File dialog, click on Browse and specify the path to the text file you downloaded. In the File format section, select Custom delimiters and check Tab. The Geometry definition secction will be auto-populated if it finds a suitable X and Y coordinate fields.

How do I create a shapefile for WGS 1984?

Click the plus icon and scroll down until you find “WGS 1984”. Select it and then select OK. Specify where you want to save your shapefile under the Output option and then click OK. A shapefile will be added to your map. Check against a basemap to make sure the points plotted in the correct locations.