File Format

The Data Connection import and export files are comma-delimited text files and have the identical format and record structure – one header record followed by any number of data records. The files can be opened with Microsoft Excel™ as well as text editors such as Word, Notepad, and WordPad.

Opening a Data Connection file in Excel gives the user an extremely easy means of changing the file content:

Change header record data field values
Delete existing data records
Add new data records
Change existing data record values.

The Excel worksheet representing the Data Connection file can then be saved as a comma-delimited text file. This, in turn, can be imported back into a tax return locator.

This round-trip export/import capability allows the user to manipulate tax return data without having to be connected to the tax compliance application. This feature represents the ultimate in portability.

Data from any source can be converted into the file format required by Data Connection with the requisite data field identification. The data can then be imported into a new or existing tax return.

Import/Export/dc_specs_gst_2.htm/TY2021

Last Modified: 02/23/2021

Last System Build: 10/18/2022