Export CSV

The Export file task allows you to export a table from your data flow into a CSV file, which will be made available for download directly within the Gaio DataOS interface. It’s a practical way to share results or integrate with external systems.

How to Use

1. Add the Task to Your Flow

  • Go to the "Delivery" section in the left menu.

  • Drag the Export file task into your data flow.

  • Connect it to the table you wish to export.

2. Configure the Task

  • Task label: A name for the task (e.g., export_april_sales). For internal reference only.

  • Separator: Choose the character that will be used to separate columns in the CSV file. Gaio supports the following options:

    • Comma ( , ): Default for international use.

    • Semicolon ( ; ): Recommended for European or Brazilian formats.

    • Tab: Generates TSV (tab-separated values) files.

    • Pipe ( | ): Useful when your data contains a lot of commas or semicolons.

    • fieldsTerminatedByTILD: Uses the tilde ~ symbol as the field separator, useful for custom data integrations.

  • Compress file (ZIP) (optional): Enable this option if you want the resulting CSV file to be compressed as a .zip.

3. Save and Run

  • Click Save to store the task.

  • Click Run to execute the task in your flow.

  • When the flow runs, the file will be generated based on the settings.

  • The download will be available with the same name as the exported table.

Tips

  • The resulting file will include all columns and rows from the linked table.

  • Use Pipe or TILD separators when your data includes a lot of punctuation.

  • You can include this task in automated flows or trigger it manually as needed.

PreviousForm CardNextMap

Last updated