Import files from a Dropbox 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 Dropbox, click Import.
3. Click Connect and sign in to Dropbox as a Team Administrator.

Create a comma-separated values (CSV) file that lists the Dropbox folders 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 DropboxValue and enter an email address for each personal folder or a folder path for each team folder. Team folders import to a specified Workspace shared drive. Use a separate row for each folder.
3. If you're importing a Dropbox team folder, in the second column, add the header Target Drive FolderID. Then, enter the ID for the Workspace shared drive where you want to import the team folder. Use a separate row for each team folder.
4. If you're importing a Dropbox team folder, in the third column, add the header Target GUser and enter an email address for the Workspace user you’re importing to. Use a separate row for each folder.

   Recommended: Use multiple Target GUsers in the file to avoid data import failures and Google Drive performance issues. You can import up to 500,000 items to a single Target GUser.

   Example:

   Folder Type	Source DropboxValue	Target Drive FolderID	Target GUser
   Personal	terry@example.com	Not needed if the Source DropboxValue matches a Workspace user	Not needed if the Source DropboxValue matches a Workspace user
   Team	/folder/folder2	BDEz25J3DzFb	alan@other-company.com, emma@other-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 your CSV mapping fileclick Open.
   3. Click Tasksto confirm that the mapping 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 Dropbox folders) to map Dropbox folders and files to Workspace users. 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.

Before you begin If you're importing Dropbox Groups to Google Groups, you need to:

• Create groups in Google Groups in your Workspace account. For details, go to Create a group in your organization.
• Replicate the Dropbox Groups user memberships in Google Groups.

To create the identity map:

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 an email address for each personal folder or a folder path for each team folder that you want to import from Dropbox. Use a separate row for each folder.
3. In the second column, add the header Destination Email and enter the Workspace email address that you're importing to.

   Example:

   Source Identity	Destination Email
   emma@example.com	emma@other-company.com
   Group Team A	group-team-a@other-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 CSV 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 choose which data to copy from Dropbox:

1. To import all OneDrive 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, and then choose an option:
   • If the user's email address in Dropbox is the same as their address in Workspace, ensure that Keep their original email address is selected.
   • If the domain name for all imported users is changing, select Use a different email address domain for these accounts and select a domain from the list.

   Note: These settings don't apply to external users or Dropbox Groups.

2. To copy files by date, check the Only include files created or modified after the following date box and then select an option:
   • To copy files created after a certain date, select Created after and then select a date.
   • To copy files modified after a certain date, select Modified after and then select 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 that you select.

3. If you don't want to import all file types, check the Exclude specific file formats box, and then enter the file extensions that you want 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 greater than the following size box, enter a maximum size, and then select MB or GB.
5. Click Save.

1. Click Start data import.
2. You can review updates on the following information in real time while the data import is in progress:
   • Successful—Number of tasks that were successfully completed
   • Skipped—Tasks that were skipped because of certain data import settings, or because they were completed in a previous data import
   • Warning—Tasks that were completed but failed to complete as expected
   • Failed—Tasks that failed to import due to an error
   • Time elapsed—Time elapsed since the data import started
   • Files discovered—Number of files detected during the data import
   • Files imported—Number of files that successfully imported
   • Files skipped—Number of previously imported files that were skipped
   • Files failed—Number of files that failed to import
   • Size of imported files—Total size of imported files
   • Discovery issues—Folders from Dropbox that couldn't be crawled
   When the data import is complete, you get an email with import statistics. Any reports are attached.
3. Click View data import logs. You can export the report at any time once the data import starts.
4. If the Tasks list doesn't automatically open with the exported report, click Tasks the report link.
5. (Optional) 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 you stopped a data import aren't deleted from Google Drive.

You can run delta imports 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 Dropbox, you must exit the existing import.

To exit a 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 Dropbox.
2. (Optional) If you want to save logs and reports from a data import, click View data import logs Export folder report.
3. Click Exit import Exit 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.