Anyone know if I can export tasks in a project into an excel sheet?
Is not possible to export tasks directly to an excel sheet, but you can export them in CSV format and import the CSV file in excel.
You can find more information on how to export tasks in CSV format in this guide article.
I hope this information helps
@Frankie_Leonard, If you need more flexible export to CSV (for Excel), you can use Asana2Go from any List view (My Tasks, Project, Search Results). See the CSV - Detailed format as an example, but you can customize your own CSV output easily.
See https://medium.com/asana-consulting-trilogi-solutions for more articles and videos on Asana2Go. Disclaimer: I’m the creator.
I really like what you have done with Asan2Go. It does make exporting the information far easier; particularly for someone with no coding experience and new to Asana like myself.
My query to you is, can you export a table with all subtasks. That could be two or three levels of subtasks deep? Potentially also with comments under each subtask…?
Apologies; I probably should have put an @lpb at the start of my previous reply…
Hi @Phil_Bowles, and thanks for the nice remarks on Asana2Go!
In answer to your questions, I’m assuming you’re talking about CSV export, not an HTML/PDF output (both are possible:
- table with all subtasks: Yes, this is possible, though I don’t have a pre-made format for that. Examples of HTML output that do this are “Table - Including Subtasks” and “List - Sections/Tasks/Description/Subtasks”
- …two or three levels of subtaks deep: No, sorry, just one level deep
- …with comments: Sorry, Comments aren’t supported.
Hope that’s clear.
Thank you for your reply.
So to your knowledge, there is no way of getting subtasks two or three levels deep out of Asana?
I checked the resource you linked to, and I found how to export a project. But not how to export a Task. Did I miss it?
So far the only solution I found to this problem is to convert tasks to projects, and then exporting them.