

In the later versions of Excel, the Print Area options are on the Page Layout tab. After formatting the file, select all the cells in populated rows and columns in the table, and navigate to File > Print Area > Set Print Area, or Page Layout > Print Area > Set Print Area.The image below shows the distribution of positive and negative values for longitude (X) and latitude (Y) coordinates worldwide. The label columns are ID, Longitude, Latitude, and Description. This is to ensure that ArcMap reads the data in the file correctly.ĭescriptions of the contents of each column are required in the output file. Use Excel to format the columns containing the Longitude (X, or Easting) and Latitude (Y, or Northing) values as NUMBER, with a minimum of 8 decimal places.In more recent versions of Microsoft Excel, DBase III and DBase IV file formats (.dbf) are no longer supported. In version 9.2 and later versions, ArcMap can read the above formats along with. If they exist, extra sheets must be deleted from these formats in Microsoft Excel. In version 9.1 and earlier, ArcMap can read the following formats: DBase III, DBase IV. There are several table formats that ArcMap can read to bring point data into ArcMap as an event theme. The steps below are instructions for formatting XY data, in decimal degrees, using Microsoft Excel, and converting these data into a shapefile or geodatabase feature class in ArcMap.

DATA RES2DINV KE ARCGIS PRO
To perform these actions in ArcGIS 10.1 and later versions, refer to How To: Import XY data to ArcMap and convert the data to shapefile or feature class at ArcMap 10.1 and later versions.ĪrcMap and ArcGIS Pro cannot read data in degrees-minutes-seconds (DMS), and therefore this data must be converted into decimal degrees (DD) before importing.

Later versions of ArcGIS may contain different functionality, as well as different names and locations for menus, commands and geoprocessing tools. The information in this article applies to ArcGIS versions 10.0 and prior only. How To: Import XY data tables to ArcMap and convert the data to a shapefile using ArcMap 10.0 and previous versions Summary
