This is a new feature that came about from people requesting and upvoting it on the Planner UserVoice site. You can now export your Planner to Excel in order to work with it further. Here’s how that works…
In your Planner plan, click on the Ellipsis icon for more options, and select Export Plan to Excel:
Either Open or Save the spreadsheet that’s generated:
All the data from your Planner will be saved out to Excel: