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.
Yes, I downloaded the desktop version. I did the following:
1. Downloaded the Google Sheet plan as an Excel file (.xlsx).
2. Launched the MS Project Desktop client.
3. Click on "File" option and selected "New from Excel Workbook"
4. Import Wizard dialog box appeared
5. Chose "New Map"
6. Selected "As a new project" option to import the file.
7. Selected "Tasks, Resources, Assignments" as types of data to be imported.
8. In the next screen of the Import Wizard, i am unable to select the column under the "From: Excel field" and hence not able to map it "To: Microsoft Project field"..
this is where i am getting stuck at.
Robert --
Can you send us a screenshot of the Import Wizard dialog where you are not able to map one or more Excel fields with a Microsoft Project field? It would help us to troubleshoot your problem. Let us know and we will try to help you.
Can you send us a screenshot of the Import Wizard dialog where you are not able to map one or more Excel fields with a Microsoft Project field? It would help us to troubleshoot your problem. Let us know and we will try to help you.