Forum Discussion
robertpoddar
Jul 14, 2022Copper Contributor
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...
- Jul 21, 2022Robert --
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.
robertpoddar
Copper Contributor
Hi Dale,
Your solution worked!! .. thank you so much. The import wasn't clean in terms of the right columns getting imported, but the original issue of not being able to import is resolved.
Thank you so much..
Will work on streamlining the mapped data to get the desired results.
Your solution worked!! .. thank you so much. The import wasn't clean in terms of the right columns getting imported, but the original issue of not being able to import is resolved.
Thank you so much..
Will work on streamlining the mapped data to get the desired results.
Jul 22, 2022
Robert --
You are more than welcome for the help, my friend. 🙂
You are more than welcome for the help, my friend. 🙂
- robertpoddarJul 22, 2022Copper ContributorThank you so much 🙂