Note: The steps listed in this article will be updated soon to reflect the new Microsoft Planner experience, which is currently rolling out to customers. Learn more about the new Planner in Frequently asked questions about Planner. If you're working from a Government Cloud Communities (GCC), GCC High, or Department of Defense (DoD) environment, continue referring to the instructions in this article.
If you want to sort, filter, report on, or share your Planner plan with people who aren't members of the plan, you can export your plan to Excel.
-
In your plan header, select the three dots (…), then choose Export plan to Excel.
-
When asked what you want to do with "[Plan name].xlsx", choose either Open or Save. When you open your plan, it will include the Plan name, Plan ID, and Date of export, as well as all of your tasks and their details.
Once you have an Excel spreadsheet of your plan, you have more options for interacting with your plan data, including:
-
Filter: Filter on one or more columns of data to find values quickly and control not only what you want to see, but what you want to exclude. Get started with filtering in Excel
-
Sort: You can sort your Excel data on one column or multiple columns. You can sort in ascending or descending order. Get started with sorting data in an Excel worksheet
-
Conditional formatting: Highlight cells with a certain color, depending on the cell's value. Apply conditional formatting in Excel
-
What-If Analysis: Explore various results for your data: Change the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Introduction to What-If Analysis
-
PivotTable: A PivotTable is a powerful tool that allows you to calculate, summarize, and analyze data so you can see comparisons, patterns, and trends. Create a PivotTable to analyze worksheet data
-
Tables: You can analyze a related set of data in quickly and easily with Tables. Overview of Excel tables
-
Charts: A simple Excel chart can help you visualize your data and make immediate impact on your audience. Create a chart from start to finish
You can also:
-
Aggregate task data from multiple plans into one Excel chart to do analysis across plans
-
Export again to Microsoft Power BI for even greater sorting and reporting functionality
-
Share to non-members: You can share your Excel file and charts with people who you don't want to be members of the plan
