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!
- wolfie42,
On my system the wizard auto-selects "none" for the worksheet. I must manually select "sheet1" in order to see Excel data. Are you saying on your system the wizard auto-selects "sheet1"?
You didn't answer my initial question about what type of data you want to import. Did you select "tasks", "resources", "assignments", some combination thereof, or did you not make a selection?
John- Not sure what to say. Mine doesn't select none. It auto selects what is "sheet1" for you. When you export from Project for the Web it auto names the tab to "Project tasks" and this is what the Wizard auto selects.
And yes. I answered you twice already. Feel free to take another look above. Starting to feel like you think I'm a complete idiot lol. I've been an expert user of Project Pro for a couple of decades. I've imported many excel files successfully so I understand how to use the Wizard. I have an IT background for 30+ years, databasing, coding, project managing, QA, wireframing and on and on. But I've never worked with the Project for the Web version. The info I provided is clear and accurate. I was looking to see if anyone else had experienced this odd situation, not for someone to automatically think/assume I'm doing something wrong.
Appreciate your time and if you have any helpful ideas on what the cause is, please feel free to share!- wolfie42,
No, I do not think you are an idiot. My apologies, upon a re-read I see you did answer my original question, and I failed to pick up on it. Now who's looking like an idiot 🙂
My next thought was to suggest you do what Dale outlined, he's got extensive experience with Project for the Web whereas I'm a Project desktop user only. Please try his suggestion and if it works, please mark his response as the answer.
John