Use CSV files with the data migration service

To make sure legacy information is correctly mapped to your new G Suite account using the data migration service, upload a comma-separated values (CSV) file so that you don't have to manually enter usernames and calendar resources every time you migrate data. It also allows you to migrate multiple users at the same time. 

Formatting the CSV files

Follow these guidelines when you create the CSV file:

  • Only include the legacy email address if it differs from the G Suite email address.
  • Use the full email address (including domain).
  • Include a password unless you are migrating from Gmail, Microsoft® Exchange, or Office 365™.

You can use a spreadsheet application, such as Google Sheets or Microsoft Excel®, or a text file to create the CSV file.  

Formatting a text file

If you are using a text file, use the following format:

G Suite email address,Legacy email address,Legacy email password
G Suite calendar resource,Legacy calendar resource

Formatting a spreadsheet

If you are using a spreadsheet application, enter the information for each record on a separate line, using individual cells for the following information: 

  • G Suite email address
  • Legacy email address
  • Legacy email password

Don't include headers or use commas to separate the fields. Use line breaks to separate each entry.

How to use the CSV files

If you're migrating multiple users or calendar events, you'll be prompted to upload 2 CSV files: 

  1. A CSV file to map usernames and calendar events. This file is used to ensure that your legacy usernames and calendar resources map correctly to their new G Suite usernames and calendar resources. 

    CSV file for mapping users

     

  2. A CSV file of the users and calendar events you want to migrate. You can make a copy of the original CSV file and add any usernames that don't need to be mapped (for example, those users who will keep the same email address in your new G Suite domain or who have already been migrated). 

      CSV file for mapping users and calendar events

How do I find the calendar resource email address in G Suite?

  1. Sign in to the Google Admin console.
  2. Click Apps > G Suite > Calendar > Resources.
  3. Click the resource name to see its email address. 

 

Was this article helpful?
How can we improve it?