Delimited text export settings

Fields and options for downloading the data as a delimited text file.

The delimited text export settings allow you to customize an exported file to suit your needs. Depending on the defined fields and options, the file extension of the exported file will generally be either .csv, .txt, or .zip
Figure: Export settings for delimited files
Column Headers
Names
The column header in the text file includes only the column name for each column.
Labels
The column header in the text file includes only the column label for each column.
Note: If this option is selected and a column does not have a label, the column name is used in its place.
Names and Labels
The column header in the text file includes both column name and column label for each column, in that order.
Labels and Names
The column header in the text file includes both column label and column name for each column, in that order.
No Headers
The column header in the text file does not include column headers.
Field Separator
The options in this section define the character used to separate adjacent columns in the text file.
Comma
Columns in each row of the table are separated by a comma (,) in the text file.
Tab
Columns in each row of the table are separated by a tab in the text file.
Space
Columns in each row of the table are separated by a space in the text file.
Colon
Columns in each row of the table are separated by a colon (:) in the text file.
Semicolon
Columns in each row of the table are separated by a semicolon (;) in the text file.
Vertical Bar
Columns in each row of the table are separated by a vertical bar (|) in the text file.
Row Separator
The options in this section define the record (row) separator character. The separator is used to indicate the end of each row of the table in the text file.

The row separator is a sequence of one or more characters used to specify the boundary between separate, independent regions in plain text files. In general, the two most commonly used record delimiters in the Insights Platform are CRLF (Windows newline) and LF (Unix/OS X Newline).

Windows Newline (CRLF)
The last column in each row of the table is indicated by the Carriage Return Line Feed (CRLF) row separator in the text file.

The CRLF ('\r\n', 0x0D 0x0A) row separator is used in Microsoft Windows, DOS (MS-DOS, PC DOS, etc.), DEC TOPS-10, RT-11, CP/M, MP/M, Atari TOS, OS/2, Symbian OS, Palm OS, Amstrad CPC, and most other early non-Unix and non-IBM OSes. Select this option for PC files.

Unix/OS X Newline (LF)
The last column in each row of the table is indicated by the Line Feed (LF) row separator in the text file.

The LF ('\n', 0x0A) row separator is used in Multics, Unix and Unix-like systems (Linux, OS X, FreeBSD, AIX, Xenix, etc.), BeOS, Amiga, RISC OS, and others.

macOS 9 Newline (CR)
The last column in each row of the table is indicated by the Carriage Return (CR) row separator in the text file.

The CR ('\r', 0x0D) row separator is used in macOS 9.

File-type settings
Export formatted data
Compress as a Zip archive
The exported text file is compressed into a .zip file. The Filename extension changes to zip automatically.
Filename
By default, exported delimited .csv files are named exported.csv. You can choose to name the exported file something else by entering a new name in this field.
Export
Click Export to export the query with the selected settings.