How To: Export an attribute table to Microsoft Excel
Instructions provided describe several methods to export an attribute table to Microsoft Excel.
Note: Before the release of Office 2007, Microsoft Excel was limited to 65,536 rows. This was increased to 1,048,576 rows with Office 2007.
Use one of the following solutions:
Option A: For ArcGIS for Desktop 10.2 and above, using the Table to Excel tool
- Start ArcMap.
- Open the Table To Excel tool from ArcToolbox > Conversion Tools > Excel > Table To Excel.
- Specify the Input Table from the drop-down list, or move the feature class into the text box.
- Specify the Output Excel File.
- 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
- Start ArcMap.
- Open the attribute table; right-click the feature class > Open Attribute Table.
- Click the Table Options arrow, and click Select All.
- Right-click the left-most column of the attribute table, and select Copy Selected.
- Start Microsoft Excel.
- Right-click cell A1 of the Excel file, and select Paste.
- Save the file.
Option C: Export the attribute table to a CSV file
- Follow steps 1 and 2 in Option B above.
- Click the Table Options arrow, and select Export.
- Under Output table, click the folder browsing icon.
- Under Save as type, click the drop-down list, and select Text File.
- Specify the desired name and change the file extension .txt to .csv to the name.
- Click Save.
- Navigate to the folder location through Windows Explorer to view the .csv file in Microsoft Excel.