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

importing project

Forum home » Delegate support and help forum » Microsoft Project Training and help » Importing to project

Importing to project

ResolvedVersion 2007

David has attended:
Project Introduction course

Importing to project

If you had indented tasks in excel, will they be imported as summary tasks

Edited on Fri 13 Feb 2009, 11:49

RE: Importing to project

Hi David

Thanks for your question. In short no, the import process doesn't automatically pick up on indents in Excel. The way to achieve this would be in Excel to create a column called Outline Level and use it to indicate how indented an item should be. For example the an Excel sheet with two columns

Column A:
Outline Level
=========
1
2
2
1
2

Column B:
Name
====
A summary
A sub task
Another sub task
A new summary
That also has a sub task

Will result in a plan that looks like this:

A summary
A sub task
Another sub task
A new summary
That also has a sub task

To import the sheet in Project choose File > Open and set the text type to Excel and follow the wizard.

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

Kind regards,
Andrew

Thu 19 Feb 2009: Automatically marked as resolved.

MS Project tip:

Enter a Date

You can enter today's date (or tomorrow's date) in a date field, by simply typing in the word 'today'or 'tomorrow' and Project will insert the date for you.

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.09 secs.