How to use Table Reports to export data to XLSX or CSV, as well as download attachments.
To export data, you'll need to create a Table Report based on the appropriate Workflow(s) and underlying Field(s) that contain data within those Workflows. Please review this article for an overview of how to create a Table Report.
Exporting Record Data from a Table Report
Once you've developed the appropriate Table Report to export data from, navigate to that Table Report. At the bottom of the Table Report, you'll see two download options (CSV and XLSX). If at least one Attachment Field is included on the Table Report, you'll see the ATTACHMENT option as well.
This option is preferred for quicker downloads, especially when dealing with high numbers of Records and/or Fields.
Note: selecting download CSV will not download the attachments themselves, but will include the attachment names. See below for downloading attachments.
This option will download data directly into an Excel (.xlsx) file versus the above (.csv). Most modern versions of Excel or Google Sheets will be able to open these file types.
Note: selecting download XLSX will not download the attachments themselves, but will include the attachment names. See below for downloading attachments.
Exporting Individual Attachments from Table Reports
Exporting individual attachments is also possible via Table Reports. Navigate to the Table Report and select the attachment name. Doing so will prompt the download to your local drive.
Exporting Multiple Attachments (Bulk Downloading) from Table Reports
You also have the ability to bulk download multiple attachments from a Table Report by clicking the ATTACHMENTS button, as indicated below. A ZIP file download will be initiated containing attachment(s).
There are some current caveats, however:
When you select the "ATTACHMENTS" button as indicated in the above screenshot, it will ONLY download the attachments appearing on that page of the Table Report.
You will need to select download attachments on every page if you have multiple pages of data in the Table Report
The file names will be prepended with an ID unique to the attachment, and appended with versioning (e.g., z9c2n3u1_Filename.docx_v1.docx)
Please sign in to leave a comment.