Contents
How to convert XY coordinates to shapefile in Excel?
The steps below give instructions for formatting XY coordinates, using Microsoft Excel, and converting these data to a shapefile or geodatabase feature class in ArcMap. ArcMap can read several table formats, including DBase III; DBase IV; .prn, .txt, .csv, .xls, and xlsx. Post-2003, Excel no longer generates files in DBase format.
How to format XY coordinates as a number?
The graphic below shows the distribution of positive and negative values for longitude (X) and latitude (Y) coordinates worldwide. Note : Format the ID field as Number, with no decimal places. Format Longitude and Latitude as Number, with at least 8 and up to 11 decimal places.
How to create a polygon from an XY data table?
In the Display XY Data dialog box, browse the X Field and the Y Field for the columns that contain the x and y coordinates. Click OK to execute the tool. A new layer based on XY events from the table is created. Use the XY To Line tool to create a new feature class containing geodetic line features.
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 to display XY data in ArcMap [ Quick Guide ]?
Right-click the table name in the Table of Contents and select Display XY Data . Warning: ArcMap applies the coordinate system of the Data Frame to the XY Data.
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.