ASCII .DAT, .TXT, .CSV Data Files

ASCII files are generic format files that can be read or produced by most applications. There are three common ASCII data formats: .DAT, .CSV, and .TXT. ASCII files are generic format files read or produced by most applications. These files can also be imported into most applications, including word processors, spreadsheets, and ASCII editors.


Worksheet Formatting

ASCII files do not contain any worksheet formatting information such as row height, column width, or cell formatting. When ASCII files are loaded into the worksheet, the default column formatting parameters are applied to the data. This does not result in any change to data, but might result in rounding of values in the data display. There is no limitation on the number of rows or columns in an ASCII format. ASCII formats save and load slowly because there is a conversion from binary numbers to character representation.



There are some distinctions in formatting of ASCII files. Here are some brief notes that outline the usefulness of the ASCII file features.

Comma Separated Variables

Comma separated variable .CSV files are comma delimited with double-quotes around text strings (non-numeric or mixed alpha numeric).



ASCII text files .TXT are normally tab delimited ASCII text files with no quotes around the text strings. After selecting .TXT as the format, the Data Export Options dialog is displayed.


Golden Software DAT Files

ASCII .DAT files are ASCII files with no set format. Any delimiter or text qualifier can be set. When a file is saved in the .DAT format, the Data Export Options dialog is displayed.


Data Export Options Dialog

The Data Export Options dialog is displayed when saving a .TXT file or .DAT file.

Choose one Delimiter and a Text Qualifier for .TXT

files in the Data Export Options dialog.




Import Options Dialog

Data Import Options Dialog


Import Automation Options

Data Import Automation Options


Export Options Dialog

Data Export Options Dialog


Export Automation Options

Data Export Automation Options


DAT and CSV XYZ Points Export

MapViewer plots can be exported to a DAT or CSV data file including XYZ coordinates, attributes, and linked data information. The first three columns are always X, Y, and Z coordinates, followed by attributes, and then linked data. Exporting a CSV file will include column headers as the first line of the CSV file. In MapViewer, the Z column will be populated with zeroes.


Export Options

There is no export options dialog for DAT XYZ points or CSV XYZ points export formats.



See Also

Data File Formats

Opening Worksheet Files

Saving Worksheet Files

File Format Chart


Excel XLS Files