# Download a new table as CSV

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

To do so:


Choose a data table.


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

Table Storage Download Location of the Download as CSV button


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

Last updated: 10/25/2023, 6:45:14 AM