Is there a way to import excel data into MS project?

S

soccer75

I have developed an excel spreadsheet and I'm looking for a way to export
certain fields of data from excel to MS Project. Is this possible?
 
J

John

soccer75 said:
I have developed an excel spreadsheet and I'm looking for a way to export
certain fields of data from excel to MS Project. Is this possible?

soccer75,
Yes, but to do it successfully the spreadsheet must be structured with
tasks as rows and task data (e.g. duration, start, predecessors, etc.)
as columns.

To find out more about importing Excel data into Rroject, open Project
and go to File/Open. At the bottom of the Open window select a "files of
type" as Microsoft Excel Workbook. Then select the Excel Workbook that
appears in the list and hit Open. The import wizard will be activated.
Just follow the steps in the wizard.

John
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top