Academy
Analysis and Export

Text File Export Step

The Text File Export step generates a delimited file (.csv, .txt, .tsv, or .dat) with the data prepared in the flow. It is the most universal format for loading into other systems — ERPs, databases, third-party tools — and the most suitable for large volumes. Text File Export is found in the Analysis and Export category of the toolbar and is available in Turbo AI processes.

How to configure

Connect a source to the step — to export more than one result, use one export step for each — and configure:

  • Name: identifies the step in the flow (up to 100 characters).

  • File name pattern: defines the name of the file generated on each run. It accepts the same variables as the other exports: {referenceDate}, {timestamp}, {id}, {code}, {name}, {folder} and {folderName} — for example, titulos_{referenceDate:yyyyMMdd}.

  • Extension: csv (default), txt, tsv or dat.

  • Delimiter: separator between columns — comma (default), semicolon, pipe, or tab.

  • Quotation character: character that surrounds the values — double quotes (default), single quotes, or None.

  • Include header: when enabled (default), the first line of the file contains the column names.

Encoding: the file is always generated in UTF-8, a standard accepted by most systems. If the destination system requires another encoding, check with the system support team whether it can receive UTF-8.

Where the file goes

Without any additional configuration, the file stays in the platform's internal storage, available to Download or View in the run's export panel. For automatic delivery to an external destination (e.g., SFTP), configure the Output Directory in the process settings.

Usage example

A process calculates entries that need to be imported back into the ERP, which expects a CSV file separated by semicolons, without quotes. In the step, the team configures the extension csv, semicolon delimiter, quotation None, header enabled, and the file name pattern lancamentos_{referenceDate:yyyyMMdd}. With the Output Directory pointing to the company's SFTP, the file arrives ready for the ERP import routine on each run.

Best practices

  • Match delimiter and quotation with the destination system. In Brazil, semicolons are common in files opened in Excel; international systems usually expect commas with double quotes.

  • This is the recommended format for large volumes — text files do not have the line limit of spreadsheets.

  • Excel Export Step

  • Document Export Step

  • Database Export Step

  • Connect external storages (SFTP, SharePoint, OneDrive)

Was this helpful?