Exporting Data to Excel From Wrike
|
Availability: Legacy Free, Legacy Professional, Legacy Business, Legacy Enterprise; Unavailability: ; |
|
Availability: Free, Team, Business, Enterprise, Pinnacle. ; Unavailability: ; |
Export all your tasks and subtasks with their statuses, dependencies, assignees, start and due dates, duration, and time log entries to an Excel file.
All users (except for Collaborators, Contributors, and Viewers) can export data from Wrike to Excel.
Important
-
Attachments and comments aren't exported to Excel.
-
You can export blueprints.
-
If the task is tagged with several subfolders/subprojects, the row of that task will show up for each subproject/subfolder in the XLS file.
-
The tags of subtasks are being inherited by default and are greyed out in Wrike. This is called a ghost tag. When you export your table to Excel, ghost tags will not be listed in the "Location" column for the subtasks in the exported file. Subtasks will have a parent folder/project/space tag only if manually tagged with one. If the subtask is tagged with the same parent folder/project/space as its parent task, the subtask will appear in the XLS document two times. The “Key” cell will be the same for both these rows.
-
Formula custom fields are not included when using the 'Export Project to Excel' option.
Tip
There's an export limit based on the maximum size of an Excel file. The limit is 65,000 rows and 256 columns. If you try to export more data items than this number, you will get an error message: "The generated Excel file has too many rows, please reduce the number of tasks for export". In this case, we suggest exporting separate sub-projects/sub-folders.
-
Navigate to the folder, project, or space that you'd like to export.
-
Click the three-dot menu button in the top 1.
-
Hover over Export 2.
-
Select Excel 3.
-
A pop-up appears, where you can choose how data should be exported:
-
Projects, folders and filtered tasks 4 — Exports tasks, nested projects, folders, and all of their fields.Tasks will be filtered by filters from your current view.
-
Projects, folders and all tasks 5 — Exports tasks, nested projects, folders, and all of their fields.
-
-
Select one of the options, then click Export 6.
-
Click the download link at the bottom of the screen to download your file.
-
Your file is downloaded to your computer’s default location for all downloaded files.
Note
-
The hypertext in the text custom fields will not be exported when you export data to Excel; only the hyperlink will be included.
-
In the exported Excel file, Folders and Projects follow the same order as the Navigation panel, and Tasks retain the “by Priority” sorting. To have tasks appear in Excel exactly as they do in the Table view, use the Export this table to Excel option.