Forum Discussion
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 Sheet plan into MS Project? I downloaded the Google Sheet as an Excel file. Tried to import it, but I am unable to map the data.
I am subscribed to Project Plan 3.
thanks
Robert.
- 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.
- Robert --
Since you have a Project Plan 3 subscription, did you download and install the Project Online Professional application (aka the Microsoft Project desktop application)? If not, you will need to do that. Once done, you will be able to import your project from the Excel workbook into Microsoft Project. 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.
