Create a mapping CSV file
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:
- You're migrating calendar data; and
- 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: firstname.lastname@example.org and email@example.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 users—firstname.lastname@example.org, email@example.com
Example: firstname.lastname@example.org, email@example.com
- If you're mapping calendar resources—exchange-resource-email, GSuite-resource-email
Example: firstname.lastname@example.org, email@example.com
To find the G Suite calendar resource email:
- From the Admin console Home page, go to AppsG SuiteCalendar.
- Click Resources.
- Click the calendar resource name.
- Next to Email, copy the G Suite calendar resource email.