Forum Discussion
How to import a Project for the Web export into Project Pro (desktop)
- wolfie42 --
I ran into this exact problem a couple of years ago, and decided it is way too much work trying to import into Microsoft Project an Excel workbook that was exported from Project for the Web. However, if this something you absolutely have to do, then copy all of the cells from the exported Excel workbook (including the column names) and then paste them into a competely new Excel workbook. Then save the new workbook. You should now find that the information appears as expected in the Import dialog in Microsoft Project. Hope this helps.
A screen shot would help but did you select an import of tasks, resources, or assignments, or perhaps, all three? Also, did you select a specific sheet in the Excel Workbook?
You also mention something about removing Project information at the top of the tab. What tab? A screen shot of your Excel Workbook would help.
John
John-project Thanks John for the quick response! There's only one worksheet so as I mentioned, the wizard auto selected it for the Source worksheet name. I only selected tasks as I mentioned.
Apparently when you export out of Project for the Web, at the top of the only worksheet in the file, it adds the info you'd find under Project Information in pro at the top, pushing the column headers to Row 9. I deleted that info so the headers were in row 1.
Unfortunately I cannot share screenshots as this is for my job and it's not allowed. I'm posting this from my personal computer since this site is blocked on my work computer. That's why I detailed out the steps, hoping that would be a fair middle ground. Happy to share any other info you need!