English

How To: Export an attribute table to Microsoft Excel

Summary

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

Procedure

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.
[O-Image]
  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.
[O-Image]
  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.
[O-Image]
  1. Click the Table Options arrow, and click Select All.
[O-Image]
  1. Right-click the left-most column of the attribute table, and select Copy Selected.
[O-Image]
  1. Start Microsoft Excel.
  2. Right-click cell A1 of the Excel file, and select Paste.
[O-Image]
  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.
[O-Image]
  1. Under Output table, click the folder browsing icon.
[O-Image]
  1. Under Save as type, click the drop-down list, and select Text File.
[O-Image]
  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