Create a mapping CSV file

G Suite Migration for Microsoft Exchange

In some situations when you're migrating data using G Suite Migration for Microsoft® Exchange (GSMME), you need 2 files: a control CSV file and a mapping CSV file. 

This article is about creating and using a mapping CSV file. For details about creating and using a control CSV file, see Create a control CSV file for user accounts.

When to use a mapping CSV file

You need a mapping file, in addition to the control CSV file, if:

  1. You're migrating calendar data; and 
  2. There are users or calendar resources in your organization whose email address in the G Suite domain is different from the email address in the source environment.

    Example: jsmith@solarmora.com and johnsmith@solarmora.com

Important: If you're migrating data (including calendar data) for a subset of users, you should also use a mapping CSV file. Use the control CSV file to map the group of users you want to migrate. Then, use the mapping CSV file to list all users and resources—even if some of the users aren’t migrated at this time. They may be listed as attendees for calendar events that you're migrating. 

How to create the mapping CSV file

  • You can use any spreadsheet software to create the CSV file.
  • We recommend that you copy the final file and save it in a text editor as a CSV file so that you can review the syntax for consistency. Some spreadsheet editors add quotation marks to cells, which you need to delete before running the migration. Adding a space after the comma is optional.
  • Make sure your CSV is correctly formatted, or the migration won't run successfully. 
  • You only need to include users in the mapping file if they have a different address in G Suite than their legacy address.

Format of the mapping CSV file

  • If you're mapping userssourceuser@domain.com, destinationuser@domain.com

    Example: jsmith@solarmora.com, johnsmith@solarmora.com

  • If you're mapping calendar resourcesexchange-resource-email, GSuite-resource-email

    Example: board-room-1@solarmora.com, solarmora.com_37r2903631@resource.calendar.google.com

To find the G Suite calendar resource email: 

  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 thenG Suiteand thenCalendar.
  3. Click Resources.
  4. Click the calendar resource name.
  5. Next to Email, copy the G Suite calendar resource email. 
Was this helpful?
How can we improve it?