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
Robert --
John's reply helped me to figure out what might be your problem. When you go to import the Excel workbook, only select the Tasks option in the Import Wizard dialog. If you select Tasks, Resources, and Assignments, then you Excel workbook MUST have three worksheets. Most of the time, you can successfully import an Excel workbook only using the Tasks option. Just a follow up to John's excellent post. Hope this helps.
John's reply helped me to figure out what might be your problem. When you go to import the Excel workbook, only select the Tasks option in the Import Wizard dialog. If you select Tasks, Resources, and Assignments, then you Excel workbook MUST have three worksheets. Most of the time, you can successfully import an Excel workbook only using the Tasks option. Just a follow up to John's excellent post. Hope this helps.
- OK Dale.. i did try out what John mentioned, but i am yet unsuccessful. I have shared the screenshots of the Map Wizard as part of John's response.
- 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.- 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.
