Use the advanced data import method for Exchange Online

1. In the Google Admin console, go to Menu Data Data import & export Data import.

   Go to Data import

   You must be signed in as a super administrator for this task.

2. For Advanced, click New batch.
3. For Wave name, enter a name for this batch of users and then click Continue.
4. For Client ID, enter the unique ID number for your Exchange Online account.
5. For Client Secret, enter the client secret value for your Azure tenant.
6. For Tenant ID, enter the unique ID number for your Azure tenant.
7. Click Connect.

Create a comma-separated values (CSV) file that lists the Exchange Online users that you want to import in this batch. You can create a new CSV file. Or, download a sample file and add information. The completed CSV file must be smaller than 10 MB and contain no more than 5,000 users.

To get details about users in your Exchange Online tenant, go to Plan for where and how you will manage your user accounts.

To create the CSV file:

1. Using your Workspace administrator account, open a spreadsheet program. Or, in the Admin console, select Download a sample CSV file.
2. Add the header Source Exchange Email and add an email address for each Exchange Online user that you want to import. Use a separate row for each email address.

   Example:

   Source Exchange Email

   kim@example.com

   alex@example.com

3. Save the spreadsheet as a CSV file.
4. Upload the file to the Admin console:
   1. In your Admin console, click Upload CSV.
   2. Select the fileclick Open.
   3. Click Tasks to confirm that the file is successfully uploaded.
5. If the CSV file doesn't successfully upload:
   1. Select the file and click Delete Yes to confirm.
   2. Create a new file and try to upload it again.

   If you encounter this issue more than once, contact Google Workspace support.

If necessary, create a second CSV file (separate from the file of Exchange Online users) to map Exchange Online users to Workspace users. You can create a new CSV file. Or, download a sample file and add rows. You don't need to add external users. Their permissions import by default. The completed CSV file must be smaller than 10 MB.

A single Exchange Online user can't be mapped to multiple users or groups in Workspace. You need to provide a one-to-one or many-to-one mapping.

An identity map is not always required. You don't need an identity map if:

• The user's email address in Exchange Online is the same as their address in Workspace. For example, the user's email address is raha@example.com for their Microsoft account and their Workspace account.
• All users keep the same username in Workspace and are mapped to another domain name. For example, all users have the domain name @example.com and are moving to the domain name @altostrat.com. The users keep their username and only the domain name changes.

If you have some users that don't need to be mapped and some that do, you can create an identity map for only the users that require mapping.

Create an identity map

1. Using your Workspace administrator account, open a spreadsheet program. Or, in the Admin console, select Download a sample CSV file.
2. In the first column, add the header Source Email and add an email address for each Exchange Online user that you want to import. Use a separate row for each user.
3. In the second column, add the header Destination Email and enter a Workspace email address for each user in the first column. Use a separate row for each user.

   Example:

   Source Exchange Email	Destination Email
   charliecruz@example.com	ccruz@other-company.com
   kailee@example.com	klee@other-company.com

4. Save the spreadsheet as a CSV file.
5. Upload the file to the Admin console:
   1. In your Admin console, click Upload CSV.
   2. Select the fileclick Open.
   3. Click Tasks to confirm that the file is successfully uploaded.
6. If the CSV file doesn't successfully upload:
   1. Select the file and click DeleteYes to confirm.
   2. Create a new file and try to upload it again.

   If you encounter this issue more than once, Contact Google Workspace support.

Adjust the following settings to choose which data to copy from Exchange Online.

1. Click Edit settings.
2. Check one or more of the following boxes to choose which data to import for all your selected users:
   • Email
   • Calendar events
   • Contacts—A new import duplicates any contacts you already imported. Contact labels are not duplicated.
3. For Date range, enter a date to start importing data from the source you selected. All calendar events and email messages sent or received after this date are copied to Workspace and all contacts are copied, regardless of creation date.
4. (Optional) To specify which email information is imported, for Email options, check any of the following boxes:
   • Include deleted emails—Import deleted email messages.
   • Include junk emails—Import email messages in spam folders.
   • Exclude specific folders—Enter the excluded folder names, separated by commas. For details, go to Exclude folders from importing.
5. (Optional) To import the Exchange Online users' calendars and events, including calendars for personal appointments, check the Copy additional calendars box. The calendars import to Other calendars in Google Calendar.
6. If you created an identity map for only some users or did not create one at all, check the Copy accounts that aren't included in the map that are discovered during the data import box to import all Exchange Online users, including those not found in the identity map.

   Then, choose an option:

   • If the user's email address in Exchange Online is the same as their address in Workspace, check the Keep their original address box.
   • If the domain name for all imported users is changing, check the Use a different email address domain for these accounts box and then select a domain from the list.
7. Click Save changes.

Exclude folders from importing

• Separately add each Exchange Online folder or subfolder name.
• If you exclude a folder, the import doesn't include its subfolders and any email messages in them.
• To exclude a subfolder, use the full path and separate the parent folder from the subfolder with a forward slash (/). For example:
  • If you want to exclude the subfolder Asia in the folder Travel, enter Travel/Asia.
  • If you also add Travel in the list, such as Travel, Travel/Asia, then all the subfolders are automatically excluded.
• To exclude a folder with a forward slash (/) in its name, replace each slash with an underscore (_). For example, to exclude Folder/with/slash, add it as Folder_with_slash.
• You can also exclude default Microsoft folders, such as Deleted Items, Inbox, or Junk email.

Start importing the current batch of users. You can import 5 batches at one time.

1. Click Run full import.

   The status changes to In progress and the following information is updated in real time:

   • Users processed—Number of users whose import is complete for all selected data types.
   • Emails discovered—Number of email messages in the Exchange Online users' accounts.
   • Emails imported—Number of email messages that were imported.
   • Emails skipped—Number of email messages that were skipped. For example, an email is marked as skipped if it was already imported in a full import and then you run a delta import.
   • Emails failed—Number of email messages that failed to import.
   • Calendars processed—Number of calendars that were imported.
   • Calendar events discovered—Number of events in the Exchange Online users' accounts.
   • Calendar events imported—Number of events that were imported.
   • Calendar events skipped—Number of events that were skipped. For example, an event is marked as skipped if it was already imported in a full import and then you run a delta import.
   • Calendar events failed—Number of events that failed to import.
2. You can navigate away from the import page without interrupting the import. Your import continues unless you cancel it.

   When the import is complete, you get an email with importn statistics. Any reports are attached.

3. (Optional) To export a report for a import in progress:
   1. Click View data import logs or Export user report.
   2. If the Tasks list doesn't automatically open with the exported report, click Tasks the report link.
   3. Click Open in Google Sheets to open the report in Sheets.
   4. For details about the reports, go to Understand Exchange Online data import reports.

To stop an import that's in progress, click Stop import. It might take a few minutes for the import to stop, and the import process does not roll back. If you are running other batches at the same time, those batches will continue to import.

Email messages, calendars, calendar events, and contacts imported before you stopped the import are not deleted from Gmail, Google Calendar, or Google Contacts.

After you successfully import a batch of data, you can run a delta import to copy any newly added or updated data to Workspace. You can also use a delta import to copy data that failed in the initial import. If you imported the same data in 2 separate batches, a delta import won't create duplicate items as long as you haven't clicked Exit import to remove one of the batches.

For details, go to Run a delta import.