Copy Data from Microsoft Project and Paste into Excel

 
Project Management: A Systems Approach to Planning, Scheduling, and Controlling
  
 
Ultimate Study Guide: Foundations Microsoft Project 2010 (Exam 70-178)

 
PMP Exam Prep: Rita's Course

  
  
PgMP: Program Management Professional Exam Guide

 
Implementing and Administering Microsoft Project Server 2010

MS Project: Copy Data from Microsoft Project and Paste into Excel
Posted on Saturday, November 15 @ 00:23:02 CST by webadmin
1. Create a view that contains the desired data
2. Select the data you would like to copy within Microsoft Project

3. Click on >Edit, >Copy Task (Ctrl-C)
4. Within Excel, click on Paste

Note that the selected information is pasted accurately, but it lacks the column headings, the WBS or outline structure and it does not retain the bold formatting for Summary Tasks or the Project Summary Task. Also note that the date format now includes the time.
This approach is quick and simple but makes it very tough to decipher the details of this project. Additional work or formatting may be required to get this file in a workable state.

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

Social Bookmark this page

RSS Feed for Exclusive Articles

Associated Topics

Sorry, Comments are not available for this article.

View the original article here