How to Export a Microsoft Planner Plan to Excel with Power Automate
Question details
The user wants to export an entire Microsoft Planner plan to an Excel workbook stored in a SharePoint group.

- Product
- Microsoft Planner, Power Automate, Excel
- Device & OS
- not provided
- Scenario
- Exporting task data from Microsoft Planner into an Excel spreadsheet for use in reporting or a Power BI dashboard.
- Observed behavior
- Users need an automated workflow or an effective workaround to extract Planner data and store it in an Excel file within SharePoint.
Ensure you have the necessary permissions to access the target Microsoft Planner, Power Automate, and the specific SharePoint document library where the Excel file will be saved.
Export Plans Individually and Combine in Excel
A straightforward workaround when automated flows are too complex is to export each Planner plan manually and merge them into a single workbook.
Building a custom Power Automate flow with complex connector integration can be time-consuming. A practical alternative is relying on the native export tools in Planner and combining the files afterward.
Open Microsoft Planner, navigate to your plan, click the three dots (...) at the top, and select 'Export plan to Excel'.
Upload the downloaded Excel files into your desired SharePoint group document library.
Open a master Excel workbook and copy the exported data as new worksheets to consolidate the information for Power BI.

Create a Power Automate Flow for Planner Data
Set up a flow in Power Automate to extract tasks from a specific plan and populate an existing Excel table.
Manage and Analyze Your Exported Data with WPS Office
While extracting data from Microsoft Planner requires Microsoft ecosystem tools, you can use WPS Office as a free, lightweight alternative to open, edit, and consolidate the resulting Excel workbooks with full format compatibility.
- 1. Download and Install: Download WPS Office from the official website and install it on your device.
- 2. Open Exported Files: Launch WPS Spreadsheet and open the Excel workbooks you exported from Planner.
- 3. Consolidate Data: Use WPS Spreadsheet's copy-paste or data consolidation tools to merge multiple plans into one master file.

Frequently Asked Questions
Can Power Automate export Planner tasks directly to a new Excel file?
No, Power Automate requires an existing Excel file with a pre-formatted table to insert data rows. You must create the table in SharePoint before running the flow.
Does Planner have a native export feature?
Yes, Planner allows you to export a plan to an Excel file natively. Click the three dots at the top of your plan and select 'Export plan to Excel'.
How do I combine multiple Planner exports?
You can open the individually exported Excel files and copy the data into separate sheets within a master workbook, which can then be connected to Power BI.
Can I automate combining the Excel files in SharePoint?
Automating the consolidation of multiple Excel files requires advanced Power Automate workflows using Excel connectors or Office Scripts to loop through files and append rows.




