Loading a Project from Excel

[PM Training 12]

Is it possible to actually create projects in MS Project by loading a row of
data from Excel? I know you can import tasks and resources, but has anyone
ever loaded (and created) projects from a spreadsheet?

We have a large number of completed projects listed on spreadsheets, and
would like to load them as completed projects in MS Project for historical
tracking.

Thanks.

 

[JackD]

Sure, just set up the columns correctly and either cut and paste or open the
excel file from project.

 

[PM Training 12]

Thanks Jack. I checked the documentation and it seems relatively
straightforward. One question I can't find: Can we load multiple projects in
one pass (one project per line)? or is it just open an excel file that has
one line of data, create the project, close that projects, then open the next
line, create the project, close the project, etc.). With a thousand projects
to create, that would be a time consuming job.

Thanks.