Jul 13 2022 10:45 PM
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.
Jul 14 2022 05:04 AM
Jul 17 2022 09:50 PM
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.
Jul 18 2022 07:54 PM
Jul 18 2022 11:21 PM
Yes, I am beginning to gather that we can't import a project plan from Google Sheet. Currently, i am going through a painful process of manually entering the project plan in MS Project, as I need to soon share the plan with the stakeholders.
In parallel, i am keeping my fingers crossed that someone can throw some light as to why I am unable to map the Excel columns with the MS Project columns.
Jul 19 2022 07:43 AM
Jul 19 2022 09:12 AM
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
Jul 19 2022 10:27 AM
Jul 21 2022 01:47 AM
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.
Jul 21 2022 01:49 AM
Jul 21 2022 05:24 AM
SolutionJul 21 2022 06:36 AM
Jul 22 2022 02:35 AM
Jul 22 2022 02:37 AM
Jul 22 2022 06:25 AM
Jul 22 2022 07:30 AM
Jul 22 2022 07:32 AM
Jul 21 2022 05:24 AM
Solution