A Guide to the Project Management Body of Knowledge: PMBOK 5th Edition 2013

PMP Exam Prep: Rita's Course

Microsoft Project 2016 for Dummies

Microsoft Project 2016

Ultimate Study Guide: Foundations Microsoft Project 2013

The Ultimate Application Administrators Guide for Project Online

MS Project: How to Export to Excel from MS Project and Retain the Outline StructurePosted on Saturday, August 19 @ 05:31:19 CDT by webadmin

We've all been there. You would like to share your MS Project schedule with someone electronically, but they do not have access to MS Project. You tried saving the file as an .xls, but when you open the file in Excel, you realize it has lost it's outline structure and bold formatting for the summary rows. This makes the schedule very tough to decipher.

The steps below will allow you to export to Excel and retain the outline structure and bold formatting of MS Project.

1. Click on File, Save As2. Note where the file is being saved3. Under the Save As Type, select Web Page*4. Click on Save. This starts the Export Wizard5. Choose Next, then click on Existing Map, then Next6. Click on Export to HTML using Standard Template7. Click on Next until it is no longer available, then click on Finish8. Browse to where the file was saved9. Change the file extension from .html to .xls**10. The plan will now open in Excel and the outline structure will be intact.

*This feature is not available within Microsoft Project 2007.**To show the file extension you may need to Explore Windows, then choose Tools, Folder Options, View Tab, and uncheck "Hide exstensions for known file types".

Updates or modifications can now be made to this file in Excel and sent back to you for incorporating into your schedule. If the output does not contain fields that you need, simply perform the steps again, only select a different export template in step 6. Or you could create your own export map by selecting New in step 5.