Planner Premium Sub Tasks Export to Excel

Low Foon, Tamara 60 Reputation points
2026-09-21T17:43:41.5633333+00:00

When you export a plan with tasks and sub tasks to Excel from Planner Premium, can the sub tasks export to their own rows?

Microsoft 365 and Office | Project | For business | Other
0 comments
Answer accepted by question author
Kai-L 19,920 Reputation points Microsoft External Staff Moderator
2026-09-21T19:19:20.4333333+00:00

Dear Tamara,

From my research, the native Export to Excel option does not currently document or provide a setting to export premium-plan subtasks as separate rows. Microsoft lists exported fields such as task ID, title, description, bucket, status, dates, assignments, priority, and labels, but does not list subtask hierarchy as a separate-row export option.  Planner Premium supports summary tasks and subtasks, but that hierarchy does not translate into individually configurable rows through the standard Excel export. 

If you need every subtask on its own row, the practical route is to pull the data from where premium plan data is stored in Dataverse and flatten the parent and child structure in Excel or Power BI. That does require someone with the right access to build the query, so it is worth checking whether your organization has that capability.

I hope this helps. Looking forward to your reply.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.