Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

exporting

ResolvedVersion 2007

Martin has attended:
Project Intermediate course

Exporting

How do I export information from Project to Excel?

Thanks

RE: Exporting

Hi Martin

thanks for your question. The quickest way to get your data from Project to Excel is to select the relevant rows in Project, choose Edit > Copy Task then paste straight into Excel.

For a more structured approach you can choose File > Save as and set the type to Excel Workbook. Choose OK and follow the export wizard to choose the fields of data you'd like to export to Excel.

I hope this helps - let us know if you have any other questions.

Kind regards,

Andrew

MS Project tip:

Typing Links Between Tasks

In the Entry table, use the Precessors column to type in links. Type the previous task's ID to link. To change the link, add FS (Finish-Start), FF (Finish-Finish), and so on, and + duration to add a Lag, or - duration for a Lead time. Example: for task 5, 4FS+1w ... task 4 preceeds task 5, finish to start, with a week lag between.

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.