Create CSV files for your migration

To make sure source information is correctly mapped to your new Google Workspace account using Google Workspace Migration for Microsoft Exchange (GWMME), use comma-separated values (CSV) files.

About the CSV files

There are 2 types of files—whether you use one or both depends on what you want to migrate. 

• Control CSV file—Specifies the source users that get migrated and the new Google Workspace accounts their data is migrated to.
• Mapping CSV file—Transfers identities (such as users or calendar resources) on your source account to your target account. It ensures metadata and usernames are correctly transferred.

If you're migrating calendar data and one of the following is true, then you must use a mapping CSV file: 

• A user's source email address differs from the target account address.
• Users with differing email addresses are invitees in calendar events that you're migrating.

Format guidelines for files

• Put each entry on a separate row
• Don't include header rows
• Delete any automatically added quotation marks
• Don't add more than 1,000 users and calendar resources to a single file

If you plan to use multiple client machines, make a separate CSV file for each client. Each CSV file must contain a unique set of users and calendar resources.

Format the files

Expand section  |  Collapse all & go to top

Format the control CSV file

Use the following format:

• For users–Source user,Target user

  This format has some exceptions. For details, go to Examples of control CSV files.

• For calendar events and resources–Source resource address,Target resource address

  For details, go to Where do I find a calendar resource email address?

Examples of control CSV files

Migrating from Exchange servers

You don't need to enter your users' passwords in the CSV file because authentication occurs through your Exchange server administrator account.

Use the following format:

• Source user,Target user

  Example: [e-mail],[e-mail]

• If the email addresses are identical, you can exclude Target user.

  Example: [e-mail]

Google Workspace IMAP migrations

If you're migrating data from a personal Gmail account (@gmail.com account) go to Gmail migrations (below, in this section).

Use the following format:

• Source user,Target user

  Example: [e-mail],[e-mail]

Cyrus or Mirapoint IMAP migrations

Use the following format:

• Source user,Target user

  Example: [e-mail],[e-mail]

For details about migrating from Cyrus IMAP servers, go to "Special instructions for Cyrus IMAP" in chapter 6 of the GWMME Administration Guide.

Exchange IMAP migrations

For Exchange IMAP migrations (not regular Exchange migrations), use the following format: 

• Windows AD domain/Exchange admin/Source user#Admin password,Target user

  Example: solarmora/admin/[e-mail]#VjJ8zTsm,[e-mail]

In this example, the Microsoft Windows Active Directory domain is solarmora, the Exchange administrator's username is admin, and their password is VjJ8zTsm. The administrator is migrating email for the user [e-mail].

Gmail migrations

Use the following format:

• Source user#Source user password,Target user

  Example: [e-mail]#VjJ8zTsm,[e-mail]

For more information about the source user password, go to Create a CSV file of users & passwords. 

Other IMAP servers migrations

When you're using an IMAP server other than Google Workspace, Cyrus, Mirapoint, or Exchange, use the following format: 

• Source user#Source user password,Target user

  Example: [e-mail]#fKz47MCb,[e-mail]

• For source user, provide the username that the user enters in their IMAP email client to check their email. Some IMAP servers only require a username (for example, dcruz), and others require the full email address (for example, [e-mail]). If you’re uncertain, use the full email address.

PST files migrations

If you're migrating data using Personal Storage Table (PST) files, use the following format:

• PST folder name,Target user

  Example: pst-archive,[e-mail]

Format the mapping CSV file

Important: Include all user accounts and calendar resources in the file—even if some aren’t currently being migrated.

Use the following format:

• Users: Source user,Target user

  Example: [e-mail],[e-mail]

• If the email addresses are identical, you can exclude Target user

  Example: [e-mail]

• Calendar events: Source resource address,Target resource address

  For details, see the following section. 

Where do I find a calendar resource email address?

1. Sign in to your Google Admin console.

   Sign in using your administrator account (does not end in @gmail.com).

2. In the Admin console, go to Menu  AppsGoogle WorkspaceCalendar.
3. Click Resources.
4. Click a calendar resource name (for example, NYC-14-12-Boardroom-15) to view its details.

   Under Resource email, you can find the calendar resource email address. Example:  [e-mail]

_{Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.}