Blog Post

Microsoft 365 Insider Blog
2 MIN READ

Migrate your Google forms to Microsoft Forms

Linda_C's avatar
Linda_C
Icon for Microsoft rankMicrosoft
Aug 25, 2024

(Originally published on Feb 28, 2024 by Tristan Xia)

 

Hello, Microsoft 365 Insiders! I’m Tristan Xia, a Product Manager on the Forms team. I’m excited to share that, as an Admin, you can migrate your Google forms to Microsoft Forms.

 

Migrate your Google forms to Microsoft Forms

 

The ability to migrate your Google forms to Microsoft Forms is now available in the Microsoft 365 admin center, as a tenant-level feature that enable you to bulk migrate your Google forms to Microsoft Forms. Individual users can then access the migrated forms on the Forms website.

 

In the initial phrase, we’re leveraging the existing document migration process in the Microsoft 365 admin center to support forms migration under personal Google drives.

Google form migration E2E flow

 

How it works

  1. To prepare for the migration, review your Google forms and responses prior to the migration, and then verify all information is intact once the process is complete.

    Review Google forms before migration

  2. In the Microsoft 365 admin center, add, select, and copy the targeted drives for migration.
  3. To specify a destination storage within OneDrive for individual forms, use the admin center UX.

    Specify individual forms destination

  4. To specify multiple different storage destinations with OneDrive, upload a CSV file.

    Specify forms destination in bulk via CSV file

  5. Migrate the forms under the selected drives.
  6. Once the migration is complete, review the summary report or download the full report in Excel.

Following the migration, instruct users in your organization to go to the Forms website to access all the migrated forms in one collection (Migrated Forms from Google).

Check migrated forms on the Forms website

 

 

Availability

This feature is available to all Admins whose organizations hold a Microsoft 365 Business or Education subscription. 

 

Feedback   

If you have any feedback or suggestions, please feel free to contact us:  formsfeedback@microsoft.com

 

You can also fill out this registration form to join our Forms community: https://forms.office.com/r/5TxHZy9cn2

 

Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!

Updated Aug 25, 2024
Version 1.0
Forms
web
  • zachtuman's avatar
    zachtuman
    Copper Contributor
    Oct 23, 2024

    This is awesome, excited to use this in our next migration.

     

    After testing this out in the migration manager, I would like to retract my previous comment. This feature is half-baked: Migrating a form works fine, but the when the sheet data is migrated over, the migration manager creates two .xlsx files from the original one. The first is stored in the user's OneDrive Documents and only contains the response selections without metadata (time, responder email, etc.), the second is stored in a new subfolder called "Migrated Forms Responses from Google", it does contain metadata and appears at first to be connected to the Form. 

    When you view the form responses in MS Forms, the form lists 0 responses (even if there were responses migrated to the xslx docs). There's a button "Open migrated results in Excel" which when clicked opens the second xlsx doc with the migrated results. That's good, but when new responses are collected on the migrated form a THIRD xlsx doc is created in the user's OneDrive to track all new responses and the "Open migrated results in Excel" button disappears, being replaced by a link to the third xslx doc. 

    You can copy/paste the responses from the second xslx doc to the third, and the form continues to work, but the MS Form responses page does not update with the copied information.

    Additionally, every xslx doc in the "Migrated Forms Responses from Google" says  it was created by someone named "Yanan Shi" who I assume is the engineer who coded this solution and the name of the account in the backend that actually performs the migration of forms data. 

    I don't usually complain about Microsoft's quirky solutions as long as they are easy to communicate to users. I have no idea how I'm going to explain this "functionality" to 200 different users across the company migrating from Google drive. I appreciate that Microsoft takes the time to create solutions like this which do not directly generate revenue, and the Migration Manager has been a game changer for us as our company evolves, but I won't become complacent to companies releasing features that barely work.

    tl;dr Good luck if you use this, test it thoroughly and have a plan. Hope it's fixed soon.