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
| Column | What to put |
|---|---|
| SourceGoogleUser | A Google account that is a member of the shared drive (yours, or a Workspace admin's) |
| DestinationUrl | The address of a document library, or a folder inside one – exactly as the browser shows it |
| SourceFolder | shared: followed by the shared drive's name as Google shows it (case doesn't matter). Add /Folder/Subfolder to copy only part of it |
| Options | docs=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