How to Fill the Users/Groups CSV File
Learn the correct CSV format and fields for different migration types in Cloudiway.
Overview
Cloudiway uses CSV (Comma-Separated Values) files to import users and groups for migration. The correct format varies depending on the type of migration you're performing. This guide covers the required fields for each migration type.
Key Constraints
Important Limitations
- • Browser limits CSV uploads to 5,000 lines maximum
- • Split larger files and upload separately
- • Multiple uploads won't overwrite existing data
- • Use semicolon (;) as the delimiter
Large Migration Projects
Mail Migration CSV
Required Header
FirstName;LastName;SourceEmail;TargetEmail;SourceRecipientType;TargetRecipientType;BatchName
Field Descriptions
| Field | Description |
|---|---|
| FirstName | User's first name |
| LastName | User's last name |
| SourceEmail | Source mailbox email address |
| TargetEmail | Destination mailbox email address |
| SourceRecipientType | Standard, Archive, SharedMailbox, or RoomsAndEquipment |
| TargetRecipientType | Same options as source |
| BatchName | Optional - organize migrations in batches |
Example
FirstName;LastName;SourceEmail;TargetEmail;SourceRecipientType;TargetRecipientType;BatchName
John;Doe;[email protected];[email protected];Standard;Standard;Batch1
Jane;Smith;[email protected];[email protected];Standard;Standard;Batch1
Sales;Team;[email protected];[email protected];SharedMailbox;SharedMailbox;Batch2
File Migration CSV
Required Header
FirstName;LastName;SourceEmail;TargetEmail;SourceFolder;SourceRecipientType;TargetRecipientType;TargetChannelName;TargetLibrary;TargetFolder;BatchName;TargetSiteName;TargetSiteUrl
Key Field Values
SourceRecipientType
- •
None - •
Archive
TargetRecipientType
- •
OneDrive - •
SharePoint - •
Teams - •
GoogleDrive - •
GoogleSharedDrive - •
None
Example
Bob;Marley;[email protected];[email protected];MySourceFolder;Archive;OneDrive;;;MyTargetFolder;Batch1;;
Optional Fields
Site Migration CSV
Required Header
SourceName;SourceId;Location;SourceRecipientType;TargetName;TargetChannelName;TargetEmailAddress;TargetUrl;TargetRecipientType;ParentObjectId;TemplateName;Description;BatchName
Key Field Values
| Field | Options |
|---|---|
| SourceRecipientType | Classic, GoogleSite, or ModernSite |
| TargetRecipientType | ModernSite |
| ParentObjectId | Enter 0 |
Google Sites Location Format
The Location field tells Cloudiway where the Google Site file is stored. It is required for New Google Sites. The format depends on whether the site is stored in a user's My Drive or in a Shared Drive. If the wrong format is used, Cloudiway cannot read the site's sharing settings and site permissions are not migrated.
Get List fills this automatically
Site stored in a user's My Drive
owner=<owner email>&FileId=<site file ID>&DomainName=<domain> Example: [email protected]&FileId=1AbCdEfGhIjKlMnOpQrStUvWxYz012345&DomainName=contoso.com
Site stored in a Shared Drive
SharedDriveId=<Shared Drive ID>&FileId=<site file ID>&DomainName=<domain> Example: SharedDriveId=0AbCdEfGhIjKlUk9PVA&FileId=1AbCdEfGhIjKlMnOpQrStUvWxYz012345&DomainName=contoso.com
Rules
- Separate parameters with "&". Do not add spaces or quotes.
- Use either
owner=orSharedDriveId=, never both. - Include "&DomainName=<domain>" only if the site is published. For an unpublished site, end the Location after the FileId value.
Where to find each value
| Parameter | What it is | Where to find it |
|---|---|---|
| owner | Email address of the user whose My Drive contains the site | In Google Drive, right-click the site and select Share. The user shown as Owner is the value to use. |
| SharedDriveId | ID of the Shared Drive that contains the site | In Google Drive, go to Shared drives and open the drive at its top level (not a folder inside it). The ID is the last part of the browser URL: https://drive.google.com/drive/folders/<Shared Drive ID>. It usually starts with "0A". |
| FileId | ID of the Google Site file | Open the site in edit mode. The editor URL looks like https://sites.google.com/d/<FileId>/p/<PageId>/edit. Copy the value between "/d/" and the next "/". |
| DomainName | Domain the site is published under | Found in the published site URL: https://sites.google.com/<domain>/<site name>. |
How to tell where the site is stored
In Google Drive, right-click the site and select Share:
- My Drive: one user is listed as Owner. Use the owner format.
- Shared Drive: no user is listed as Owner, and the dialog shows a Members tab with the Shared Drive members. Use the SharedDriveId format.
Troubleshooting
If a site stored in a Shared Drive is configured with the owner format, the audit log shows a "File not found" error for the FileId, and Pre Processing reports "0 permissions were found in the source Google Modern Site". The site content can still migrate, but site permissions are not applied. To fix it, correct the Location to the SharedDriveId format and run Pre Processing again. If the site entry can no longer be edited after Pre Processing, contact Cloudiway Support to unlock it.
Group Migration CSV
Group migration CSV formats vary by source and target platform:
Teams/Unified Group to Teams/Unified Group
SourceName;SourceEmailAddress;SourceUrl;TargetName;TargetEmailAddress;BatchName Google Team Drives to SharePoint
SourceName;SourceId;TargetName;TargetUrl;TargetLibraryName;TargetFolderName;BatchName Dropbox to Microsoft Teams
SourceName;SourcePath;SourceId;TargetName;TargetEmailAddress;TargetChannelName;TargetVisibility;BatchName Slack to Teams
SourceName;SourceId;TargetName;TargetEmailAddress;TargetChannelName;TargetVisibility;BatchName Blank Fields
Screenshots
