For Microsoft Planner

Export every Planner plan to one Excel file.

Planner already exports to Excel — one plan, one file, from that plan's menu. What it has never done is give you every plan in a single spreadsheet. That is this.

30-day free trial · no credit card · from $19/month for the whole organisation

Every plan in scope · one row per task · one file

Watch the export follow your scope

Narrow the view to your direct reports and the Excel export narrows with it — 88 tasks down to 29 across 6 plans, without touching the export dialog.

Team Workload Trends view — cumulative created, completed and net-open task lines across every Microsoft Planner plan, with completions per week below.

1:13

Jumps to the scope-and-export beat at 0:56. Rewind for the full 73-second walkthrough.

What lands in the file

One row per task, with every reference resolved to something a human can read — plan and bucket names rather than GUIDs, people rather than object ids.

Column	What's in it
Title	The task name
Plan	Which plan it came from — the column that makes a combined file usable
Bucket	The bucket name within that plan
Assignees	Everyone assigned, comma-separated
Status	Not started · In progress · Completed
% Complete	Planner's own progress value
Priority	Urgent · Important · Medium · Low
Labels	Your plan's labels, by name, comma-separated
Start · Due	The task's dates
Created · Completed	Included when Planner has recorded them

The file is named for what it holds and when it was taken, so a folder of weekly exports stays legible months later.

The file matches what you're looking at

Export takes the current view under its current filters. Narrow to one person, one plan or one label and the spreadsheet narrows with you; clear the filters and it is every task in every plan you can see. There is no separate "all plans" mode to find, because an unfiltered export already is the cross-plan file.

Long lists are truncated on screen so the page stays fast. The file never is — it always carries every row in scope.

Or print a report for people who don't use Planner

Any view prints straight to PDF, with a header that states which view it is, the scope it covers in words, the date it was produced and how fresh the data is. A report you forward explains itself, without a covering email telling someone what they are looking at.

See the reports

How people do this today

All of these work, and one of them may well be the right answer for you.

Route	What it actually costs
Export each plan, then stitch	Native and free. Also one file per plan, by hand, every time you need it — there is a manager in the Microsoft forums doing this across 70 plans every week.
A Graph script	Total control over the output. Someone has to write it, own the app registration behind it, and rerun it on demand.
A Power Automate flow	Works, and it can be scheduled. You maintain the flow, and you watch Power Platform request limits as the number of plans grows.
Team Workload	Sign in, set the scope you want, click export.

Questions

Can you export all Microsoft Planner plans to one Excel file?

Not with Planner alone. Planner's own export works one plan at a time, from that plan's menu, producing one file per plan. Getting every plan into a single spreadsheet means exporting each plan and stitching the files together by hand, building a Graph script or Power Automate flow, or using a cross-plan tool. Team Workload writes one file covering every plan in the current view.

Does Microsoft Planner have a built-in export to Excel?

Yes, per plan — open a plan, use its menu, and Planner exports that plan's tasks to a spreadsheet. There is no built-in option that spans plans, which is exactly why people with a lot of plans end up exporting each one and combining them by hand.

Does the export include every task, or only what's on screen?

It follows your filters, not the screen's truncation. Whatever scope, plan and label filters are active narrow the file the same way they narrow the view — but long lists that get shortened on screen for speed are still complete in the file.

Can you export a Planner report to PDF?

Yes. Any view prints to PDF with a self-describing header — which view, what scope, the date produced, and how fresh the underlying data is.

Whose tasks end up in the export?

Only tasks in the plans you already have access to in Microsoft Planner. The app does not widen your permissions — it reads the same plans you can open yourself, and never creates, edits or deletes a task.