Export data
You can export Adobe Workfront data from lists, reports, dashboards, and searches.
Some of the reasons to export data are:
- You want to provide a hard copy of your data to someone outside of Workfront.
- You want to send the results of a report as an attachment to an external user.
- You want to create an external back-up of your Workfront data.
- There is a limit to display only 2,000 results on one page inside the Workfront web application. If your report produces more than 2,000, you can export the report to any of the available formats and view all the results in the report in one list.
You can either export a report manually, from the Workfront interface, or you can schedule a delivery for a report and that report will be sent to you at a later time. For more information on scheduling delivered reports, see Report delivery overview.
The information in this article does not apply to the following exports:
-
Exporting information from chart reports.
For more information about exporting a chart report, see Add a chart to a report.
-
Exporting information from the Gantt chart.
For more information about exporting the Gantt chart, see Export the Gantt Chart to PDF.
-
Exporting information from the Resource Planner.
For more information about exporting the information from the Resource Planner, see “Export Option” in Resource Planner navigation overview.
Access requirements
| table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header | |
|---|---|
| Adobe Workfront package | Any |
| Adobe Workfront license |
Light Review |
| Access level configurations |
View or higher access to Reports, Dashboards, and Calendars to export reports View or higher access to the objects you view in a list to export the list |
| Object permissions |
View or higher permissions to a report or dashboard to export the report or the dashboard View or higher permissions to the objects you view in a list to export the list |
For more detail about the information in this table, see Access requirements in Workfront documentation.
Prerequisites
The report must be created before you can export its data.
For more information on creating reports, see Create a custom report or Create a copy of a report.
Export formats and limits
Export formats export-formats
Information can be exported in the following formats:
- PDF (Landscape or Portrait)
- Excel
- Excel (.xlsx)
- Tab Delimited
Export limits export-limits
There are several limitations around the way reports display in Workfront as well as the way they export through a manual export, a delivered report, or through the API.
-
50,000 cells: The maximum number of cells allowed in a report export for Excel files.
-
50,000 rows: The number of rows of data allowed in a report export for PDF and Tab Delimited files.
- For Excel files, this limit is 65,000 rows.
- For Excel(.xlsx) files, this limit is 100,000 rows.
- These limits exclude the column headings, as well as rows for groupings in the report. For instance, if you have 6 groupings in a report, and 50,000 rows of data, the exported file will have 50,000 rows.
note important IMPORTANT Exporting a report that includes a collection reference within a column may result in an error, even if the report is otherwise within the listed export limits. If the referenced collection is too large, the export process times out and subsequently results in an error. To avoid this error, either exclude columns that reference large collections or reduce the size of the referenced collections before exporting. If your report has more items than these limits, you receive an error that the export is not successful. Reduce the number of items you see on the screen to a number less than or equal to these limits to be able to export the results.
If your report has more than 50,000/ 65,000/ 100,000 rows and you want to export all the data, we suggest that you use filters or prompts to obtain smaller loads of data, and perform multiple exports.
For information on using filters, see Filters overview.
For information about using prompts, see Add a prompt to a report.
-
These limits apply to:
-
A manual export of a report.
-
A scheduled report.
-
An export through an API integration.
-
Data exported through a kick-start.
For more information about exporting data via kick-starts, see Export data from Adobe Workfront via Kick-Starts.
note NOTE You can export 50,000 rows in a kick-start file, although you can export the data only to an Excel format file. -
Exporting utilization information for a project.
For more information about exporting utilization information for a project, see Overview of the Resource Utilization report.
-
-
10MB file size: File size limit for any exported report scheduled for delivery. If an exported file attached to an email is larger than 5MB, a link where the file can be downloaded is emailed instead of the attached exported report.
-
65,530 hyperlinks: This is a limit imposed by Excel on documents that contain more than 65,530 hyperlinks. These documents cannot be opened when they are exported manually, or sent in a delivered report. Note that an Excel document may have just 200 rows of data, but if there are more than 65,530 links inside the document, the document does not open. This limit exists on Excel files only, not on the other supported formats.
-
256 columns: This is a limit imposed by Excel on documents that contain more than 256 columns. These documents cannot be exported manually, or sent in a delivered report. This limit exists on Excel files only, not on the other supported formats.
note important IMPORTANT Exporting a report that includes a Reports column may result in an error even if the report is otherwise within the listed export limits. If you are using the export feature to share a report containing a Reports column with others, consider sharing the report by making it public instead. For more information on making a report public, see Share a report in Adobe Workfront. If you are using the export feature to evaluate data externally, we recommend using Workfront Data Connect instead. For more information, see Workfront Data Connect overview.
If you attempt to export data beyond the limit, you might not receive all of the expected data in the export. Rather, a modified report is produced within the limit.
Additionally, reports that take longer than 60 minutes to run will be halted.
If you have concerns or issues regarding your limit, please contact Workfront Technical Support.
Export data
Export data from a report or list export-data-from-a-report-or-list
-
Go to the report or list you want to export.
-
Select the items you want to export. Selecting individual items exports only the items you select.
For example, in a project, select the tasks you want to export.
Or
Leave all items deselected to export the entire list.
-
Click Export, then select a format.