Exporting

The UK's most regular instructor-led training courses.
Training information: microsoft project courses · Project training · Microsoft Project Training London
See also · microsoft project training courses · microsoft.project.course · microsoft+project+courses

Resolved · Low Priority · Version 2007

Exporting

Martin has attended:
Project Intermediate course

by - delegate Martin [2 posts] (2008 May 29 Thu, 17:13) Reply

How do I export information from Project to Excel?

Thanks

Version	Date	Location	Places available	Book	Next place rate:
Project Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 27 Tue	Southwark	8	book now	£295	£345
2003	2009 Feb 23 Mon	Southwark	8	book now	£295	£345
2003	2009 Mar 23 Mon	Southwark	8	book now	£295	£345
2003	2009 Apr 27 Mon	Southwark	6	book now	£295	£345
2003	2009 May 26 Tue	Southwark	8	book now	£295	£345
2003	2009 Jun 23 Tue	Southwark	8	book now	£295	£345
Full Schedule: See all 15 Project Advanced course dates. Bookings currently available until 22nd March 2010.

RE: Exporting

by - trainer Andrew platinum contributer [579 posts] (2008 Jun 4 Wed, 14:51) Reply

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

· What's New In Project 2007
· Tracking Work Hours in Microsoft Project
· How to Define Tasks for MS Project
· Dealing with Scope Creep in Microsoft Project
· Consulting on MS Project Gives Your Business Plan a Leg Up

Please browse our web site to find out more about
microsoft project courses and other Microsoft training courses.