Text File Export Step
The Text File Export step generates a delimited file (.csv, .txt, .tsv, or .dat) with the data prepared in the workflow. It is the most universal format for loading data into other systems—ERPs, databases, and third-party tools—and the best choice for large volumes. Text File Export is 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 workflow (up to 100 characters).
File name pattern: defines the name of the file generated with each run. It accepts the same variables as other exports: {referenceDate}, {timestamp}, {id}, {code}, {name}, {folder}, and {folderName}—for example,
titulos_{referenceDate:yyyyMMdd}.Extension:
csv(default),txt,tsv, ordat.Delimiter: separates the columns—comma (default), semicolon, pipe, or tab.
Quote character: character that encloses 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 the vast majority of systems. If the destination system requires another encoding, check with the system's support team whether it can accept UTF-8.
Where the file goes
Without additional configuration, the file is stored in the platform's internal storage, where you can Download or View it in the run's export panel. To automatically deliver it 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 semicolon-delimited CSV file with no quotes. In the step, the team sets the extension to csv, the delimiter to semicolon, the quote character to None, enables the header, and sets the file name pattern to lancamentos_{referenceDate:yyyyMMdd}. With the Output Directory pointing to the company's SFTP, the file is ready for the ERP import routine after each run.
Best practices
Match the delimiter and quote character to the destination system. In Brazil, semicolons are common in files opened in Excel; international systems typically expect commas with double quotes.
This is the recommended format for large volumes—text files do not have the row limits of spreadsheets.
Related articles
Excel Export Step
Document Export Step
Database Export Step
File repositories: which ones Dattos connects to and how to set them up