File Format Options

Last modified: January 11, 2022

Depending on the file format you use to input or output data, configuration options vary. Select file format options in these tools: Input Data tool, Output Data tool, and Cloud Storage Input tool.

Option Description File Formats
Delimiter

Select the field delimiter in the data.

Use \0 to read or write a text file with no delimiter. Use 0 if the data contains two or more delimiters to force Designer to read the data as flat text.

Use the RegEx tool in Tokenize mode to parse your data.

.csv
File Format Select the data file format. all formats
First Row Contains Field Names Select if the first row should be treated as a header. .csv
Line Ending Style Define the character or sequence of characters signifying the end of a line of text. .csv
No Spatial Index

Select to turn off the spatial index.

Use this option only when writing large temporary files that will not be used in spatial operations. This option writes smaller files and faster.

.yxdb
Output Options

Select an output option:

Create New Sheet: Creates a new sheet, but does not overwrite an existing sheet.

Append to Existing Sheet: Appends data to an existing sheet so that the output consists of new and previous data.

Overwrite Sheet or Range: Deletes the data in the selected sheet or range and writes data into the sheet or range with the selected name.

Do not use the above option if your Excel file contains formulas, tables, charts, and images as these items can be corrupted.

Overwrite File (Remove): Deletes the existing file and creates a new file.

.xlsx
Preserve Formats on Overwrite (Range Required)

Write a formula into a cell (if the string starts with an (=) sign, it gets written as a formula), but if trying to write data over a formula, an error will occur. If you have an existing formula in a cell, you can overwrite it with a new formula.  

The format of a sheet, column, or row can't yet be preserved. Make sure not to...

  • Overwrite your sheet with a range to preserve the Excel format. Overlay a part, or all of your sheet and use a range to preserve the format. Cells without a formula are preserved.
  • Enter formulas on a column. Your cell format will be lost.

When you select this option, you must also:

  • Select Overwrite Sheet or Range via Output Options.
  • Specify cell ranges in the output file path. For example, Sheet1$A1:A10.
.xlsx
Quote Output Field

Choose an option to quote output fields:

Auto: Inserts quotes around fields that have a single or double quote, and around fields that contain delimiters.

Always: Inserts quotes around each field.

Never: Doesn't insert quotes.

.csv
Save Source and Description Selected by default, this option includes source and description data in the metainfo. Deselect the option to exclude source and description data. .yxdb
Skip Field Names

When checked, this option allows you to write data only in a sheet or a range.

.xlsx
Write BOM Select to include the byte order mark (BOM) in the output, or deselect to output without a byte order mark. .csv
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.