Table to Excel

Purpose

The tool allows exporting an attribute table of a feature layer or a standalone table to .xlsx file and then opening it in the Microsoft Excel application (if the application is installed).

Description

The tool has been reworked. The tool allows to export selected fields of input attribute or standalone table to Excel workbook file (.xlsx). Output file can be opened in the Microsoft Excel application after exporting, if the application is installed and new option "Open file after exporting" is selected.

Notes:

The .xlsx files can be opened with Microsoft Office Excel 2007 or later and even with earlier versions (using the Microsoft Office Compatibility Pack).
If Microsoft Excel application is not installed, the option "Open file after exporting" is not available.

Usage

Select input dataset for exporting (either a feature layer or a standalone table).
If you wish to export only some of the features/records from the input table, select the records you wish to export and check in the "Use selected items" option.
Specify the name and location of the output .xlsx file.
Select the fields you want to export to Excel. Fields are selected with the check-boxes from the drop-down list of fields. At that, there are capabilities provided to filter fields, sort fields, as well as select all fields, unselect all fields or invert current selection.

Notes:
- you can see not only field names but also aliases and types which may help in selecting fields for exporting
- fields can be sorted by name, alias or even type, in either ascending or descending order
- fields can be filtered by name or type
- fields will be added to the output file in order they've been selected

Select if you wish to export field aliases instead of field names as column headers in Excel.
If there are any coded value domains or subtypes used you can select to export descriptions instead of coded values.
Select if you wish to open output file after exporting operation completes.
Press Run to export selected fields to the Excel file.