It is possible to export a task list to Excel. The export will generate an Excel file containing a table listing the most important task fields for the selected tasks. The export to Excel also supports custom fields. Custom fields will be added to the Excel file as additional columns.
You can export your tasks to Excel in the following locations:
- All tasks from a specific project
Export tasks from a project
To export all tasks from a project, you can do the following:
- Navigate to your project
- Click Export to Excel in the toolbar at the top of the screen
- Click the Generate Excel button to generate the Excel file
Comments
4 comments
Is it possible to extract ALL Projects and all its tasks all at once?
Columns:
Project Name - Task # - details...
any update please? can we do this using the Enterprise license?
Hi Mark,
It is currently not possible to export all projects and tasks to Excel all at once. You can however export each project individually to Excel.
The Enterprise version allows you to request an export of all your projects and tasks in a machine readable format (JSON).
ok, on the Enterprise version where we can request for an export of all projects and tasks - we are not programmers - how can we read JSON formatted files? what reader should we use? can you kindly elaborate on that? we're thinking of upgrading to Enterprise but its hard to decide if we don't have much information before we upgrade.
Also, could you give sample output of JSON file interpreted in a reader/tool?
if we upgrade, our expectation is same to my original question, can we possibly export ALL projects with its respective tasks in one excel file? Columns would have this -> Project Name, Task Number, Status, Owner, etc . --> is it achievable in the Enterprise license?
Please sign in to leave a comment.