Create CSV files for your migration

Google Workspace Migration for Microsoft Exchange

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.

You must use a mapping CSV file if you're migrating calendar data and: 

  1. A user's source email address differs from the target account address.
  2. 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:

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: dcruz@solarmora.com,danicruz@solarmora.com

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

    Example: dcruz@solarmora.com

Google Workspace IMAP migrations

If you're migrating data from a personal Gmail account (@gmail.com account) go to Migrating from other IMAP servers (below in this section).

The format you use depends on whether you need to use passwords. For details about when to add passwords, go to Step 2: Set up access for apps.

Choose a format:

  • If there are no passwords in the file (administrator's account authorizes when you set up GWMME), use the format Source user,Target user.

    Example: dcruz@example.com,dcruz@solarmora.com

  • If you add passwords to the file, use the format Source user#Password,Target user.

    Example: dcruz@example.com#VjJ8zTsm,dcruz@solarmora.com

Cyrus or Mirapoint IMAP migrations

Use the following format:

  • Source user,Target user.

    Example: dcruz@solarmora.com,danicruz@solarmora.com

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/dcruz@solarmora.com#VjJ8zTsm,dcruz@solarmora.com

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 dcruz@solarmora.com.

Exchange Online (Office 365) IMAP migrations

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

  • Exchange admin email/Source user#Admin password,Target user.

    Example: admin@solarmora.com/dcruz@solarmora.com#VjJ8zTsm,dcruz@solarmora.com

In this example, the Exchange Online administrator's email address is admin@solarmora.com, and their password is VjJ8zTsm. The administrator is migrating email for the user dcruz@solarmora.com.

Migrating from other IMAP servers

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: dcruz@solarmora.com#fKz47MCb,dcruz@solarmora.com

  • 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, dcruz@solarmora.com). If you’re uncertain, use the full email address.

Migrating from PST files

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

  • PST folder name,Target user.

    Example: pst-archive,dcruz@solarmora.com

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: dcruz@solarmora.com,danicruz@solarmora.com

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

    Example: dcruz@solarmora.com

  • Calendar events: Source resource address,Target resource address.

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

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. From the Admin console Home page, go to Appsand thenGoogle Workspace and thenCalendar.
  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:  solarmora.com_37r2903631@resource.calendar.google.com


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.

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue

true
Start your free 14-day trial today

Professional email, online storage, shared calendars, video meetings and more. Start your free Google Workspace trial today.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
73010
false