Forum Discussion
Solved
Importing a plan from Google Sheet
Hi, Earlier I was using Smartsheet project management tool and now corporate has moved us into MS Project Online. I had exported a Smartsheet plan into Google Sheet. How do I import the Google...
- Robert --
I ran into this exact problem when I exported a project from Project for the Web to an Excel workbook. When I tried to import the workbook into Microsoft Project, the From: Excel field rows were blank in the Import Wizard dialog.
Oddly enough, I was able to resolve the problem by copying and pasting the contents of the original Excel workbook into a totally new blank workbook and then saving it with a different name. I would suggest that you try this method to see if it resolves your problem as well. Hope this helps.
If I may step in. Reading your previous post about not being able to select Excel fields, could it be as simple as failing to select a "Source Worksheet Name"? And bear in mind that if you intent to import tasks, resources and assignments, those elements need to be on separate Worksheets in Excel.
John
Hi John-project
I selected the "Source Worksheet" and also selected the "Tasks" checkbox. I am unable to pull down the list in the "From: Excel field" and also map "To Microsoft Project field". Attaching the screenshot of my map wizard.
- robertpoddar,
It sounds like Dale may have the solution for you. However if you are still having issues, VBA is a fallback solution and I'd be happy to help you with that.
John- Hi John.
The solution that Dale provided worked. In the sense i was able to import the data into the MS Project.
The issue is that i am not getting the desired results, which i need to further fine tune the importing of data.
Thank you so much for helping me..- robertpoddar,
You're welcome and thanks for the feedback. Please mark Dale's response as the answer.
John