English

How To: Export an attribute table from ArcMap to Microsoft Excel

Summary

The instructions provided describe a few methods to export an attribute table to Microsoft Excel.

Note:
Before the release of Office 2007, Microsoft Excel was limited to 65,536 rows and 256 columns. This was increased to 1,048,576 rows and 16,384 columns as of Office 2007.

Procedure

Use the Table to Excel tool in ArcMap

  1. Open the .mxd project in ArcMap.
  2. Open the Table To Excel tool by navigating to ArcToolbox > Conversion Tools > Excel > Table To Excel.
The ArcToolbox pane displaying the Conversion Tools where the Table To Excel tool is found in.
  1. In the Table To Excel window, specify the Input Table from the drop-down list, or drag and drop the feature class from the Layers pane into the Input Table section.
  2. For Output Excel File, specify the folder location and name of the output table.
The Table To Excel window displaying the Input Table and Output Excel File parameters.
  1. Click OK. The Excel file is created in the designated output location.

Copy and paste all records in the attribute table into the Excel file

  1. Open the .mxd project in ArcMap.
  2. Open the layer's attribute table by right-clicking the feature class, and click Open Attribute Table.
Right-clicking the layer displays the Open Attribute Table option.
  1. In the attribute table, click the Table Options icon > Select All.
The Table Options drop-down menu displaying the Select All option.
  1. Right-click the left-most column of the attribute table, and select Copy Selected.
Right-clicking the left-most column of the attribute table displays the Copy Selected option.
  1. Open Microsoft Excel.
  2. Right-click cell A1 of the Excel file, and select Paste.
The Excel file displaying the A1 cell, and right-clicking it displays the Paste option.
  1. Save the file.

Export the attribute table to a CSV file

  1. Open the .mxd project in ArcMap.
  2. Open the layer's attribute table by right-clicking the feature class, and click Open Attribute Table.
  3. Click the Table Options icon > Export.
The Table Options drop-down menu displaying the Export option.
  1. In the Export Data window, under Output table, click the browse button and navigate to a location to save the exported attribute table.
The Export Data window displaying the Output table parameter.
  1. In the Saving Data window, for the Save as type section, click the drop-down list, and select Text File.
The Saving Data window displaying the folder location and name of the exported table.
  1. For the Name section, specify the desired name and change the file extension from .txt to .csv in the name.
  2. Click Save.
  3. Navigate to the folder location through Windows Explorer to view the .csv file in Microsoft Excel.

Related Information

Last Published: 7/22/2021

Article ID: 000012471

Software: ArcGIS for Desktop Advanced 10.3, 10.2.2, 10.2.1, 10.2, 10.1 ArcGIS for Desktop Basic 10.3, 10.2.2, 10.2.1, 10.2, 10.1 ArcGIS for Desktop Standard 10.3, 10.2.2, 10.2.1, 10.2, 10.1