Converting an Excel spreadsheet to a Project Task Sheet

[R Benjamin]

I have been given an 11,000 line Excel spreadsheet
containing a list of phases, activities, tasks, and
subtasks, in which each line is indented one cell to the
right of its higher level predecessor. I am trying to
convert this into a Microsoft Project task sheet. If I
copy a set of lines, all of which are on the same level,
e.g. tasks, to the Project worksheet, Project accepts
them without any problem. If I try to copy a set with two
or more levels, e.g. tasks and subtasks, I get an error
message indicating an incorrect value or out-of-range
condition in the Duration column, the column to the
immediate right of the Task Name column.

I suspect that Project sees the values in the Excel sub-
task cells as incorrectly formatted Duration values. Does
anyone know how to copy and paste an entire Excel
spreadsheet with this kind of structure into a Project
task list?

 

[Guest]

That's what I suspected. I DID find a shortcut, however,
after posting my query. With minor variations, the Excel
list repeats the same sequence of activities, tasks, sub-
tasks, etc. several times. By cutting and pasting the
first list into Project, with the dependency indentations
I need, I created, in effect, a template for all of the
subsequent repeats. I am now copying and pasting the
correctly formatted Project task repeatedly until I have
enough iterations..

-----Original Message-----
Hello,

You will have to take out the task and subtasks to make

one long column instead of several columns. Project
won't take the info in any other way.