Welcome to PMConnection


· Home
· The Project Management Search Engine
· Exclusive Articles

Related Sites
There isn't content right now for this block.

Related Products

The Self-Driving Project: Using Artificial Intelligence to Deliver Project Success

Citizen Development: The Handbook for Creators and Change Makers
A Guide to the Project Management Body of Knowledge: PMBOK 7th Edition 2021

PMP Project Management Professional Exam Study Guide

Microsoft Project Step by Step


Microsoft Project


Managing Enterprise Projects: Using Project Online and Microsoft Project Server

MS Project: How to Export to Excel from MS Project and Retain the Outline Structure
Posted on Saturday, August 19 @ 04:31:19 EDT 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.

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.71
Votes: 248

Please take a second and vote for this article:

Very Good


 Printer Friendly Printer Friendly

Associated Topics

PMConnection Articles

Sorry, Comments are not available for this article.

Copyright 2005-2024 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.09 Seconds