How to Show Planner Buckets in Grid View
Question details
The user wants to display a Bucket column while managing tasks in the Grid view of Microsoft Planner.

- Product
- Microsoft Planner
- Device & OS
- not provided
- Scenario
- Organizing and reviewing project tasks using different list and grid layouts in Microsoft Planner.
- Observed behavior
- Microsoft Planner does not currently provide a built-in Bucket column in the Grid view, requiring users to switch to the Board view to see task bucket assignments.
Open your Microsoft Planner workspace and ensure you have the necessary permissions to switch task views and manage project boards.
Switch to Board View to Organize Tasks by Bucket
Since the Grid view does not support displaying buckets natively, utilizing the Board view is the standard method for viewing and managing tasks grouped by their assigned buckets.
Microsoft Planner currently restricts bucket visibility to the Board view. While the Grid view is excellent for a list-style overview of dates and assignments, it lacks a dedicated Bucket column by design.
Navigate to Microsoft Planner on the web and open the specific project plan you want to review.
At the top of the plan interface, click on the "Board" tab located next to "Grid" and "Charts".
In the top right corner of the Board view, click on the "Group by" option and select "Bucket" from the dropdown menu to arrange your tasks visually by their respective buckets.

Manage Your Projects Flexibly with WPS Office
If Microsoft Planner's rigid views are limiting your workflow, you can build highly customizable task trackers using WPS Spreadsheet. WPS Office is a lightweight, fully compatible, and free alternative to Microsoft Office that gives you complete control over your project grids.
- 1. Download and install WPS Office: Visit the official WPS website to download the free productivity suite.
- 2. Open WPS Spreadsheet: Launch the application and select Spreadsheet to start building your custom task tracker.
- 3. Choose a Project Template: Browse the template library for project management grids that fit your exact tracking needs, allowing you to add as many bucket columns as you want.

Frequently Asked Questions
Can I export the Planner Grid view to Excel to see the buckets?
Yes. If you export your Microsoft Planner plan to an Excel spreadsheet, the resulting file will include a 'Bucket' column for each task, allowing you to view, sort, and filter them in a grid format.
Will Microsoft add the Bucket column to Grid view in the future?
Microsoft frequently updates Planner based on user feedback. While it is not currently available, users are highly encouraged to submit this feature request to the Microsoft Feedback Portal to increase its priority.
Can I sort tasks by bucket directly in the Grid view?
No. Because the bucket data is not exposed in the Grid view interface, you cannot natively sort or group by buckets while on the Grid tab. You must use the Board view for this functionality.




