Table to File

Purpose

The new tool combines all three previously available table exporting options - export to Microsoft Excel (.xlsx), CSV (.txt), HTML (.html).

Description

This tool exports attribute tables or standalone tables to Microsoft Excel workbook files (.xslx), CSV text files (.txt) or HTML files (.html).

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

• Select the fields you want to export to a file. 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.

Note:
- 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

• Select if you wish to export field aliases instead of field names as column headers

• If there are any coded value domains or subtypes used you can select to export descriptions instead of coded values

• Specify the output file and select if you wish to open it after exporting operation completes

• Press Run to export selected fields to the specified file.

About output text file format

Output files are saved in unicode text format. To store the attribute data the tool uses CSV file format.

The CSV (Comma Separated Values) file format is often used to exchange data between disparate applications. The file format as it is used in Microsoft Excel has become a pseudo standard throughout the industry, even among non-Microsoft platforms. Some general CSV files characteristics are:

• Each record is one line.

The tool separates lines with a carriage return and line feed pair.

• Fields are separated with commas.

• Fields with embedded commas are delimited with double-quote characters.

• Fields that contain double quote characters are surrounded by double-quotes, and the embedded double-quotes are each represented by a pair of consecutive double quotes.

• Fields with leading or trailing spaces are delimited with double-quote characters.

• The first record in an output file is a header record containing field names.