Contents
Can You import XY coordinates into ArcGIS Pro?
ArcMap (and ArcGIS Pro) cannot read data in degrees-minutes-seconds (DMS), and therefore this data must be converted into decimal degrees (DD) before importing. 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.
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 ADD excel lat long coordinates to ArcGIS?
Add Excel lat long coordinates table to ArcMap 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. This will add the Excel table to ArcGIS and appear in the table of contents.
How do I export coordinates from an Excel spreadsheet?
Before you close your ArcGIS session, you need to create a feature class or shapefile. So right-click the event layer and export data (data > export data). Next, click “use the same coordinate system as the data layer”. Save the file. At this point, you permanently create a spatial file from an Excel spreadsheet.
How to add x y coordinates to a map?
In addition to data sources, such as a shapefile, you can add tabular data that contains geographic locations in the form of x,y coordinates to your map. If the table also contains z-coordinates, such as elevation values, you can add tabular data as 3D content into your globe or scene.
How to add data from a file to ArcMap?
To add the data from the formatted file to ArcMap, select the Add Data button and navigate to the folder where the table containing coordinates is saved on the computer, select the file and click Add.
How to add x and y coordinate data?
Select the table that contains x,y coordinate data. Identify the columns that hold the x- and y-coordinates (and, optionally, the z-coordinate). Specify the coordinate system. You can also add x,y data in tables as a new feature class using geoprocessing.
How to convert XY data to ArcMap data frame?
The data can also be re-projected to the coordinate system of the ArcMap data frame during this process. Go to View > Data Frame Properties. Click the Coordinate System tab, and select the desired output projection for the new data.
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.
Which is the default coordinate system in ArcGIS?
The default is GCS_WGS_1984 unless the input table is a feature class, in which case the default is the coordinate system of the input features. The following formats are supported: