MK Nepal Solutions

Google Drive: copy a shared drive into a SharePoint library (CSV example)

How to write the CSV line for a Google shared drive, what ends up in the destination, and the options.

The CSV line

In O365 Migration → Google Drive → Bulk import (CSV):

SourceGoogleUser,DestinationUrl,SourceFolder,Options
you@yourcompany.com,https://contoso.sharepoint.com/sites/Support/Shared%20Documents,shared:Team Shared - Customer Support,docs=office
ColumnWhat to put
SourceGoogleUserA Google account that is a member of the shared drive (yours, or a Workspace admin's)
DestinationUrlThe address of a document library, or a folder inside one – exactly as the browser shows it
SourceFoldershared: followed by the shared drive's name as Google shows it (case doesn't matter). Add /Folder/Subfolder to copy only part of it
Optionsdocs=office for Word/Excel/PowerPoint instead of PDF; add ;conflict=replace to overwrite on a re-run (the default copies only newer files)

What you get

Everything inside the shared drive – all folders, subfolders and files – goes straight into the destination library or folder. No extra folder named after the drive is created.

Before you run it

  • Open the destination address in a browser. If the app says The destination must be a document library, the address is a page or subsite: open the library and copy its address up to the library name (drop /Forms/AllItems.aspx).
  • After you import the CSV, the app checks each line: fix any line that isn't marked Ready before you start.
Was this article helpful?

Updated 2026-11-21