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


Instructions provided describe several methods to export an attribute table to Microsoft Excel.

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.


Use one of the following solutions:

Option A: For ArcGIS for Desktop 10.2 and above, using the Table to Excel tool

  1. Start ArcMap.
  2. Open the Table To Excel tool from ArcToolbox > Conversion Tools > Excel > Table To Excel.
  1. Specify the Input Table from the drop-down list, or move the feature class into the text box.
  2. Specify the Output Excel File.
  1. Click OK. The Excel file is created in the designated output location.

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

  1. Start ArcMap.
  2. Open the attribute table; right-click the feature class > Open Attribute Table.
  1. Click the Table Options arrow, and click Select All.
  1. Right-click the left-most column of the attribute table, and select Copy Selected.
  1. Start Microsoft Excel.
  2. Right-click cell A1 of the Excel file, and select Paste.
  1. Save the file.

Option C: Export the attribute table to a CSV file

  1. Follow steps 1 and 2 in Option B above.
  2. Click the Table Options arrow, and select Export.
  1. Under Output table, click the folder browsing icon.
  1. Under Save as type, click the drop-down list, and select Text File.
  1. Specify the desired name and change the file extension .txt to .csv to the name.
  2. Click Save.
  3. Navigate to the folder location through Windows Explorer to view the .csv file in Microsoft Excel.

Related Information