How to Fill the Users/Groups CSV File
Learn the correct CSV format and fields for different migration types in Cloudiway.
Last updated: 2025-01-15 How To
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
For migrations with more than 5,000 users, split your CSV file into multiple files
and upload them sequentially. Data from subsequent uploads is added to your existing list.
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;john.doe@source.com;john.doe@target.com;Standard;Standard;Batch1
Jane;Smith;jane.smith@source.com;jane.smith@target.com;Standard;Standard;Batch1
Sales;Team;sales@source.com;sales@target.com;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;B.Marley@source.com;B.Marley@target.com;MySourceFolder;Archive;OneDrive;;;MyTargetFolder;Batch1;;
Optional Fields
Leave unnecessary fields blank. Fields like TargetChannelName, TargetLibrary, and TargetSiteUrl
are only needed for specific target types.
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
For Google Sites, use one of these Location formats:
owner=email@domain.com&FileId=XXXXX&DomainName=domain.com
SharedDriveId=XXXXX/FileId
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
Leave unnecessary fields blank in all formats. Only populate the fields relevant to your migration scenario.
Screenshots
