Import files from a SharePoint Online 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 SharePoint Online, click Import.
3. Click Connect to Microsoft SharePoint Online 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 SharePoint Online sites to shared drives in Workspace. Create a comma-separated values (CSV) file that lists the SharePoint Online sites that you want to import. You can create a new CSV file. Or, download a sample file and add rows. The completed CSV file must be smaller than 10 MB.

To create the CSV file:

1. Using your Workspace administrator account, open a spreadsheet program. Or, in the Admin console, click Download a sample CSV file.
2. In the first column, add the header Source SharePoint URL and enter the URL for each SharePoint Online site or site collection. Use a separate row for each URL.

   Subsites are automatically included. Additional sites require a separate data import. To avoid duplication errors, only include parent sites or subsites in your file.

   You can find all the URLs at Manage sites in the SharePoint admin center.

3. In the second column, add the header Target Drive FolderID and enter a unique ID for the shared drive where you want to import each Source SharePoint URL.

   You can find existing shared drive IDs on the Manage shared drives page in the Google Admin console.

4. In the third column, add the header Target GUser and enter a Workspace email address for the user who has Manager permission for each Target Drive FolderID.

   Example:

   Source SharePoint URL	Target Drive FolderID	Target GUser
   https://company. SharePoint.com/SiteMain/	1dyUEebJaFnWa3Z4n 0BFMVAXQ7mfUH11g	Kim@your-company.com
   https://company. SharePoint.com/ SiteComms/Events	3xyUVNbJaFn9Ym2PL 0BFMoQXm7PK09vFl	Alex@your-company.com

5. Save the spreadsheet as a CSV file.
6. Upload the file to the Google Admin console:
   1. In your Admin console, click Upload CSV.
   2. Select the fileclick Open.
   3. Click Tasksto confirm that the file is successfully uploaded.
7. 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.

Create a second CSV file (separate from the file of SharePoint Online sites) to map SharePoint Online users, SharePoint Online site groups, and Microsoft 365 groups to Workspace users and groups. 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.

Before you begin:

If you're mapping SharePoint Online site groups to Google Groups, you need to:

• Create groups in Google Groups for your Workspace account.
• Replicate the same user memberships in Google Groups as those in SharePoint Online site groups.

To create the CSV file:

1. Using your Workspace administrator account, open a spreadsheet program. Or, in the Admin console, click Download a sample CSV file.
2. In the first column, add the header Source Entity and enter each email address and group name that you want to import from SharePoint Online or 365. Use a separate row for each user or group.
3. In the second column, add the header Destination Email and enter a Workspace email address that will receive data import information from each user or group in the first column.

   Example:

   Source Entity	Destination Email
   Kim@example.com	Kim@your-company.com
   groupA@example.com	groupA@your-company.com
   SiteComms Visitors	groupsitecomms@your-company.com

4. Save the spreadsheet as a CSV file.
5. Upload the file to the Google Admin console:
   1. In your Admin console, click Upload CSV.
   2. Select your mapping fileclick Open.
   3. Click Tasksto confirm that the mapping 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.

Use the following settings to specify which data to copy from SharePoint Online:

1. To import all SharePoint Online users and 365 groups, 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 and choose an option:
   • If the email address for the Microsoft account is the same as the address inGoogle Workspace, select Keep their original email address.
   • If the domain name for all imported users and 365 groups is changing, select Use a different email address domain for these accountsselect a domain.
2. To copy files by date, check the Only include files created or modified after the following date box and choose an option:
   • To copy files created after a certain date, select Created by and then select a date.
   • To copy files modified after a certain date, select Modified by and then enter a date.

   Note: Date settings are based on your local time zone and apply only to individual files, not folders. All folders import, regardless of the date you select.

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

Starting a data import grants domain-wide delegation and creates a client ID for Data import in Workspace. For more information, go to Control API access with domain-wide delegation.

1. Click Start import.

   You can review updates on the following information in real time while the data import is in process:

   • Discovered tasks—Number of tasks that were successfully completed
   • Warning—Number of tasks that were completed but failed to complete as expected
   • Failed—Number of tasks that failed to import due to an error
   • Skipped—Number of tasks that were skipped because of certain data import settings or because they were completed in a previous import
   • Successful—Number of tasks that were successfully completed
   • Sites processed—Number of sites that were completely imported
   • Files discovered—Number of files detected during the import
   • Files imported—Number of files that were successfully imported
   • Files skipped—Number of previously imported files that were skipped
   • Files failed—Number of files that failed to import
   • Discovery issues—Number of folders from the source account that couldn't be crawled
   • Time elapsed—Time elapsed since the data import started
   When the data import is complete, you get an email with import statistics. Any reports are attached.
2. You can export the following reports at any time once the data import starts:
   1. To troubleshoot errors, click View data import logs.
   2. To monitor data import progress and statistics per site, click Export site report.
   3. If the Tasks list doesn't automatically open with the exported report, click Tasksthe report link.
   4. Click Open in Google Sheets to open the report in Google Sheets.

If you need to stop a data import while it's in progress, click Stop import.

Stopping a data import might take a few minutes, and it doesn't roll back the import process. Any files that imported before the stop won't be deleted from Google Drive.

You can run a data import and review information about a completed data import in the Admin console until you exit the import. If you need to start a new data import from SharePoint Online, you must exit the existing import.

To exit a completed data import:

1. If you want to import any new or updated files before you exit, follow the steps in Run a delta import for SharePoint Online.
2. (Optional) To save reports from a data import, click View data import logsExport site report.
3. Click Exit importExit and delete import.

Avoid duplicate files

If you exit a data import and then start a new import for the same data set, the second import might create duplicate files in Workspace. To prevent duplication, avoid creating 2 separate imports for the same data set.