Welcome to PMConnection

     

Menu
· Home
· The Project Management Search Engine
· Exclusive Articles

Related Sites

Related Books 1
 
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 Structure
Posted on Saturday, August 19 @ 05:31:19 CDT by webadmin

PMConnection Articles
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 As
2. Note where the file is being saved
3. Under the Save As Type, select Web Page*
4. Click on Save.  This starts the Export Wizard
5. Choose Next, then click on Existing Map, then Next
6. Click on Export to HTML using Standard Template
7. Click on Next until it is no longer available, then click on Finish
8. Browse to where the file was saved
9. 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.


See "Getting Data From Microsoft Project to Excel" for other options.







Note:
You may find this book helpful: 
  
Ultimate Study Guide: Foundations Microsoft Project 2013

 
Related Links
· More about PMConnection Articles
· News by webadmin


Most read story about PMConnection Articles:
300 Project Manager Interview Questions


Article Rating
Average Score: 4.74
Votes: 246


Please take a second and vote for this article:

Excellent
Very Good
Good
Regular
Bad


Options

 Printer Friendly Printer Friendly


Associated Topics

PMConnection Articles

Sorry, Comments are not available for this article.


Copyright 2005-2015 PMConnection.com. All Rights Reserved.
http://www.pmconnection.com a
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.05 Seconds