Export to Excel

Ability to export Plan data to Excel

9,248 votes

Anonymous shared this idea · December 16, 2015 · Flag idea as inappropriate… · Admin →

Completed ·

AdminPlanner Team (Product Manager, Planner) responded · June 24, 2019

Hello!
The export to Excel feature is complete! for more info check out our blog: https://techcommunity.microsoft.com/t5/Planner-Blog/Export-your-entire-plan-to-Excel-for-powerful-analysis-sharing/ba-p/717431

many of you are now asking for import from excel. Please vote for this feature and add your comments here: https://planner.uservoice.com/forums/330525-microsoft-planner-feedback-forum/suggestions/11730708-import-tasks-from-excel

Cheers,
The Planner Team

Show previous admin responses (7)

In development ·

AdminPlanner Team (Product Manager, Planner) responded · June 19, 2019

Thanks for your feedback and patience.

We’ve begun rolling out the Export to Excel feature, and are releasing it out slowly to ensure that there are no issues. If you don’t see this option yet, don’t worry – you’ll be seeing this soon!

Cheers,
The Planner Team

In development ·

AdminPlanner Team (Product Manager, Planner) responded · May 28, 2019

Hello!

Thanks for your feedback and patience. This feature is currently in development and we’re hoping to wrap up work soon and start rolling out to users. Barring any unforeseen issues, we should be done by end of June.

We will update this thread as soon as it has been rolled out to all users.

Cheers,
The Planner Team

Started ·

AdminPlanner Team (Product Manager, Planner) responded · April 02, 2019

Hello!

As an update, we have started working on this feature. Your feedback on this thread helped us greatly with understanding the design and requirements for our first iteration. Thank you for your comments and feedback! We will update this thread with any major updates.

Please continue to let us know what we can do to improve Planner.

Cheers,
The Planner Team

Scheduled ·

AdminPlanner Team (Product Manager, Planner) responded · November 02, 2018

Hello and thank you for your feedback!

We have designed and scoped our first iteration for for customer ask – your comments below on what you’d like to see have helped us a lot!

This item has made it’s way up our backlog and we’re hoping to start on it soon. We don’t have an ETA to share on this yet.

Cheers,
The Planner Team

Planned ·

AdminPlanner Team (Product Manager, Planner) responded · July 10, 2018

As an update, this feature is still working its way up our backlog but we till have a few items to deliver first.

We appreciate your patience and feedback greatly!

Cheers,
The Planner Team

Planned ·

AdminPlanner Team (Product Manager, Planner) responded · January 23, 2018

Thank you for your feedback and patience!

As an update, we haven’t reached this feature on our roadmap yet, but are wrapping up some larger items this month that will get us closer. We’ve been discussing how to best implement this feature, and love reading the comments on this thread. Please continue sharing how you would use an export to Excel feature and what you’d like the spreadsheets to look like!

Cheers,

The Planner Team

Planned ·

AdminPlanner Team (Product Manager, Planner) responded · September 22, 2017

Thank you for the feedback! We love that our customers are interested in utilizing Planner in this way.

As a first step, we have added exporting to Excel to our roadmap and have changed the title of this thread to focus the conversation on this feature. Our team would love to hear more about the specific scenarios you would like to use this for so that we can build the best possible experience around this!

Thanks!

1121 comments

Comments are closed

An error occurred while saving the comment

Tracy Wright commented · February 04, 2020 12:25 · Flag as inappropriate

The comments made within task cards don't seem to show up in the export. Is there any way to do that?

Submitting...
Rafael commented · February 04, 2020 05:03 · Flag as inappropriate

The import function is extremely necessary

Submitting...
Anonymous commented · February 03, 2020 11:50 · Flag as inappropriate

Being able to change the view from Kan ban card (board) view to table view (like an excel table) would be hugely helpful or a Planner addin for Excel would be awesome. For large task lists this is really needed. I used SmartSheet Kan Ban's quite a lot and it was incredibly valuable to switch between spreadsheet view and card view.

Submitting...
RAJESH KARTHA commented · February 03, 2020 11:47 · Flag as inappropriate

We need import option.

Submitting...
Alison commented · January 31, 2020 01:13 · Flag as inappropriate

It would be helpful if you could import from excel too since the functionality to automatically pull tasks through from Microsoft Project is not feasible yet.

Submitting...
Anonymous commented · January 30, 2020 02:19 · Flag as inappropriate

Planner is solid but to move our teams over from other tools we need and import function

Submitting...
Alex H commented · January 28, 2020 09:07 · Flag as inappropriate

I second that on the import/upload feature. It would be killer!!

Submitting...
Lynn Sheridan commented · January 27, 2020 09:33 · Flag as inappropriate

upload or import of tasks would be super helpful when trying to plan a large scale project

Submitting...
Rafael Lopez commented · January 23, 2020 14:14 · Flag as inappropriate

Please create a connector to see all Planner tasks in Power BI

Submitting...
Karen D commented · January 21, 2020 11:35 · Flag as inappropriate

Please add a feature where you can Import Excel spreadsheets to Planner.

Submitting...
Lisa Murmann commented · January 20, 2020 03:11 · Flag as inappropriate

and while you are at it - why not include a "flow template" to easily connect a plan to a "summary" dashboard in PowerBI unless you make the Planner dashboard more usefull and customizable... Gant charts etc

Submitting...
Anonymous commented · January 19, 2020 11:07 · Flag as inappropriate

One would expected an Excel import implementation into Planner first as a no brainer.

Submitting...
Thevuthasan Senthuran commented · January 16, 2020 07:35 · Flag as inappropriate

Please add a feature where you can import Excel to Planner. The Export feature is nice but it would be even better to have the ability to also import.

Submitting...
Mark Compton-James commented · January 16, 2020 05:48 · Flag as inappropriate

Please add a feature where you can Import Excel spreadsheets to Planner.

Submitting...
BRIAT commented · January 15, 2020 04:43 · Flag as inappropriate

how to export several plans in one time?

Submitting...
Christine commented · January 14, 2020 14:27 · Flag as inappropriate

Love how you can pivot from various views (Board, Chart and Schedule). However, the one key capability missing is the ability to have a tabular (excel) like view along with ability to import/export to Excel. Adding Gantt view would be great too.

Submitting...
AD commented · January 10, 2020 09:14 · Flag as inappropriate

Please add a feature where you can Import Excel spreadsheets to Planner.

Submitting...
Anon commented · January 08, 2020 14:53 · Flag as inappropriate

I receive tasks from various persons in different formats including excel and projects. Definitely need to be able to import from both to planner for ease of use.

Submitting...
Anonymous commented · January 07, 2020 13:47 · Flag as inappropriate

Can you add a feature where you can Import Excel spreadsheets to Planner?

Submitting...
Alan commented · December 29, 2019 11:15 · Flag as inappropriate

No please! Add the feature to export ALL plans! You made it only plan by plan!!

Submitting...