Download a new table as CSV

You can download a data table in the Data tables interface as a CSV.

To do so:

1

Choose a data table.

2

Click the Download as CSV button can be found above the top right hand corner of the data table.

Location of the Download as CSV button

3

The CSV will be downloaded as data_table_{name}.csv, where {name} is the name of the data table in snake case.

Downloaded CSV Characteristics

Workato takes a "what-you-see-is-what-you-get" (WYSIWYG) approach to downloading a data table as CSV. Therefore:

• Date and datetime data types follow the workspace timezone, which aligns with what's displayed in the data table interface
• Date format is YYYY-MM-DD and datetime format is YYYY-MM-DD hh:mm:ss.sss
• Values starting with = (ex. "=10530") are escaped with ' in front of the = declaration (ex. "'=10530")
• Values with , (ex. “33 Main Rd, USA 01349”) are surrounded with "
• Boolean is presented as true or false
• Only columns that are visible in the data table are included in the CSV file
• The order of columns follows what's displayed in the data table interface