Import files from a OneDrive account

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 Microsoft OneDrive, click Import.
3. Click Connect to Microsoft OneDrive and sign in as a Global Administrator with your Microsoft account. If you can't connect, make sure you're using a Global Administrator account to sign in to Microsoft.

The data import tool copies files, folders, and permissions from a list of Microsoft OneDrive source users to target Google Workspace users. You can create a comma-separated values (CSV) file for the list, or you can update an existing file to match the required formatting.

To get details about users in your One Drive tenant, go to Manage Microsoft 365 user accounts.

Tip: Click Download sample CSV file to get an example file you can use.

If you're creating your own file:

1. Open a spreadsheet program.
2. In the first column, add the header Source OneDrive User.
3. On separate rows, add the emails of Microsoft OneDrive users that you want to import. You can import up to 1000 users at a time. Additional users will require a separate import.
4. Save the spreadsheet as a CSV file.
   Note: The file must be smaller than 10 MB.

Example:

5. Upload the file:
   1. In your Admin console, click Upload CSV.
   2. Select your CSV mapping file click Open.
   3. Click Tasks to confirm that the mapping file is successfully uploaded.

      Note: If the CSV file doesn't load successfully, go to (Optional) Step 3: Delete a CSV file.

If there is an error during the CSV upload or the upload gets stuck, you can delete the current configuration and upload a new one.

1. Select the CSV file you want to remove.
2. Click Delete .
3. Click Yes to confirm that you want to delete the CSV file.
4. To upload a new import map for teams, go to Step 2: Set import scope. To upload a new identity map, go to Step 4: Create and upload an identity map.

This step is optional if the Unmapped identities setting is turned on.

You use an identity map to connect users on the source account to users on the target account. To get details about users in your One Drive tenant, go to Manage Microsoft 365 user accounts. You can also download a list of your organization's Google Workspace users.

Tip: Click Download sample CSV to get an example CSV file that you can use.

1. Open a spreadsheet program.
2. In the first column, add the header Source Email.
3. In the second column, add the header Destination Email.
4. Using valid email addresses, add your organization's Microsoft OneDrive source accounts and their target accounts in Google Workspace.
5. Save the spreadsheet as a CSV file.
   Note: The CSV file must be smaller than 10 MB.

Example:

6. Upload the file
   1. In your Admin console, click Upload CSV.
   2. Select your CSV mapping file click Open.
   3. Click Tasks to confirm that the mapping file is successfully uploaded

Notes:

• External users do not need to be added to the identity map. Their permissions are imported by default.
• If the CSV file doesn't load successfully, go to (Optional) Step 3: Delete a CSV file.

You can use settings to filter the files you want to remove from the scope of import. You can set a date range to import only files created or modified after a certain date. You can also exclude files with specific extensions. Finally, you can choose to import only files that are smaller than a certain size. These settings help you manage your import and ensure that you only move the files you need.

The map all users setting is enabled by default, along with the Keep the source domain option. As an administrator, you can disable these settings by unchecking them and then clicking Save.

1. To map all users, including those not found in the identity map, ensure that the Copy accounts that aren't included in the map that are discovered during the data import box is checked. Choose an option:

• If the user's email address on the source account is the same as their address in Google Workspace, ensure that Keep the source domain is selected.
• If the domain name for all imported users is changing, select Select a different domain for importing the data and then select a domain.

This setting applies only to users that belong to the customer. External users are mapped to themselves unless you provide a different mapping in the identity map. To learn more, go to Step 4: Create and upload an identity map.

The date range filter applies only to individual files, not folders. All folders will import, whether or not they contain files that meet the date range criteria.

2. To filter files by date, check the Date range box and then select an option:

• To filter files by their creation date, select Created by and then select a date.
• To filter files by the date of their last update, select Modified by and then enter a date.

The data import tool copies files from the selected date to the date that you start the import. Dates are based on your local timezone.

3. If you don't want to import all file types, check the Exclude specific file formats box, and then enter the file extensions you want to exclude. Separate different file extensions with a comma, for example, tmp, log, bak.
4. If you don't want to import larger files, check the Exclude files larger than box, enter a maximum size, and then select Mb or Gb.
5. Click Save.