- Exporting information from chart reports.
For more information about exporting a chart report, see "Chart Reports."
- Exporting information from the Gantt chart.
For more information about exporting the Gantt chart, see "Exporting 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 "Understanding the Areas of the Resource Planner."
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 below-mentioned formats and get 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 "Setting Up Report Deliveries."
Information can be exported in the following formats:
- PDF (Letter Landscape or Portrait, Legal, Ledger and A4)
- Excel (.xls)
- Excel (.xlsx)
- Tab Delimited
NOTE dashboards can be either be printed or exported only to a .pdf file.
[! This information is shared between "Exporting Data" and "Setting Up Report Deliveries."]
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 rows: The number of rows of data allowed in a report export for .pdf and Tab Delimited files.
For Excel .xls 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 or data, the exported file will have 50,000 rows.
NOTE 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 "Creating and Customizing Filters."
For information about using prompts, see "Working with Prompts."
- 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 "Exporting Data from Workfront via Kick-Starts"
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 "Exporting Utilization Information for a Project" in "Tracking Project Progress with a Utilization Report."
- 5MB 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.
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.
- In a list, 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.
Leave all items unselected to export the entire list.
- In the Export drop-down list, select a format.
The options available to you for PDF export depend on the locale settings in your Workfront user settings:
- North America - letter (default), legal, ledger, A4
- All locations outside of North America - A3, A4 (default), letter, legal, ledger
- North America - letter (default), legal, ledger, A4
- (Conditional) Depending on the operating system you use, you might have the option of opening or saving the file. Either open the file with the associated application or save it to your hard drive.
- Continue with "Using the Exported Document."
You can print the information from a dashboard, or you can export it as a .pdf file.
For more information about exporting data from a dashboard, see "Printing Dashboards."
Whether you export a list of objects or a report, your exported file will have a file name and a title. You can find the exported file on your computer by referring to the file name. The title of the report will give users an indication of what the exported file represents when you share it with them.
When you export a list of objects, the type of the object is displayed on the exported file in the file name and in the title of the list.
When you export a list of task or issues, the File Name can be one of the following:
- When you export Task and Issue Lists in a Project:
- The_project_name_Exported_Tasks (in PDF, Excel, Excel (.xlsx), or Tab delimited formats)
- The_project_name_Exported_Issues (in PDF, Excel, Excel (.xlsx), or Tab delimited formats)
- When you export Task and Issue Lists in a Task (subtasks):
- The_project_name_the_task_name_Exported_Tasks (in PDF, Excel, Excel (.xlsx), or Tab delimited formats)
- The_project_name_the_task_name_Exported_Issues (in PDF, Excel, Excel (.xlsx), or Tab delimited formats)
When you export a list of any other objects from a project to a PDF file, the file name of the exported document indicates the type of objects you exported.
For example, the file name may be:
- Exported_Users, when exporting the People tab on the project (in PDF, Excel, Excel (.xlsx), or Tab delimited formats)
- Exported_Risks, when exporting a list of Risks on the project (in PDF, Excel, Excel (.xlsx), or Tab delimited formats)
When you export a report, the file name of the exported report is:
The_report_name (in PDF, Excel, Excel (.xlsx), or Tab delimited formats)
When you export a list of objects, only the file in the PDF format will have a title. If you export a list or a report to Excel, Excel (.xlsx), or Tab delimited formats, the file does not have a title.
When you export Task and Issue Lists in a Project to a PDF file, the title of the exported document is one of the following:
- Project name - Exported Tasks
- Project name - Exported Issues
When you export Task and Issue lists in a Task to a PDF file, the tile of the exported document is one of the following:
- Project name - Task Name - Exported Tasks
- Project name - Task Name - Exported Issues
When you export a list of any other objects from a project to a PDF file, the title of the exported document indicates the type of objects you exported.
For example, the title may be:
- Exported Users, when exporting the People tab on the project.
- Exported Risks, when exporting a list of Risks on the project.
A report which is exported to a PDF file will have a title. If the report is exported to Excel, Excel (.xlsx) or Tab delimited formats, the exported report will not have a title. The title of the exported file is the name of the report as it appears in the Workfront web application.
NOTE If the report has a description, it will be included in the exported file.
A timestamp is displayed on the exported document from the context of the user who exported the item.
The timestamp includes:
- Time zone when the item was exported
Depending on the type of document you export, timestamps are displayed in various locations:
- PDF: Timestamps are displayed on the footer of each page and in the file name.
- Excel: Timestamps are displayed in the file name.
You always receive the default tab of a report when a report is sent or scheduled for a delivery, unless the report has a special view.
If your report has special formatting in the web application, the report should be delivered with the special formatting when the Details and the Matrix tabs are delivered for .pdf and Excel files only.
For more information on how to customize formatting in a report, see "Using Conditional Formatting in Views".
When you export a list in Workfront to PDF or Excel format, any working links that exist in the original document remain live in the exported document. Links can point to any object in Workfront that supports linking.
If your system administrator has added customized branding to your Workfront instance for the Global Navigation Bar, the exported .pdf files also include your personalized logo.
Data which is exported in any other formats cannot be personalized with your logo.
For more information about branding your Workfront instance and the Global Navigation Bar, see "Branding the Workfront Site."