Skip to main content

Move Files from SharePoint to Google Team Drive

Moving Documents from SharePoint to a Google Team Drive

Windows 10 Instructions (with notes for Win 7 steps)

Connect to SharePoint (SP) and Identify the Documents You Need to Copy

    1. Log into your SP site.

    2. Review your site’s documents and determine the files you need to copy. YOU SHOULD ONLY COPY YOUR DOCUMENT FILES (Word, Excel, pdf’s., etc.) NOT THE SHAREPOINT SPECIFIC FILEs (i.e. files with an aspx extension).

    1. Copy the SharePoint site’s address (URL) to the clipboard (select address, right-click on it and choose Copy).

Open Windows Explorer and add a network location that connects to your SP content

    1. Open File Explorer and select This PC. (Win 7: Computer)

    2. Click on Add a network location at the top of page. (Win 7: Select File > Add a network location)

  1. Click Next in the Network Location Wizard window.

  1. Click Next to select the “Choose a custom network location” option.

  1. Paste your SP site’s address in the “Internet or network address” box.

  1. Remove the address text to the far right, after the site name. In the example above the text “SitePages/Home.aspx” needs to be removed.

  2. Click Next. You may be prompted to login to Sharepoint again.

  1. Type a name for the network location.

  1. Click Next.

  2. Click Finish.

  3. A new explorer window opens displaying the content of your SharePoint site.

  1. Determine which files you need to copy to a Google Team Drive. YOU SHOULD ONLY COPY YOUR DOCUMENT FILES (Word, Excel, pdf’s., etc.) NOT THE SHAREPOINT SPECIFIC FILEs (i.e. files with an aspx extension).

Create a Google Team Drive and Copy your SP Document Files

    1. Login to your Organizational Google Account https://mydrive.umsl.edu.  If you have never accessed your organizational (UMSL) Google account, please refer to instructions here.

    2. Create a Team Drive.  Please see section IV for more information about, and how to give others access to, Google Team Drives.

      1. Select Team Drives in the left-hand menu.

      2. Click the New button above the left hand menu.

  1. Type a name for your Team Drive.

  1. Click CREATE.

Select and Copy Your Files

    1. In the Files Explorer window, select the document files you want to copy to your Google Team Drive.

    2. Drag and drop the files to your Team Drive.

You will see a box displaying the progress and results of your copy. If there is a problem with a file copy/upload, it will be noted in the progress box as a failed upload.

You can click the icon to get details about which file(s) did not upload.

The failure will probably be due to file size.  You may also see “Connection lost” for a large file upload. Your Google drive storage space is unlimited, but copying a single file >=50MB from the network location mapped to SP will result in a failed upload.

    1. If you need to copy files from SP that are >=50MB then continue with the steps in D below.  Otherwise, go to the Add Members instructions.

To copy files >=50 MB from your SP site:

    1. Open your SP site in browser.

    2. Select the file(s) you want to copy by checking the box to the left of the name.

    3. From the Documents tab, select Download a Copy. Download to your local C: drive.

    1. After you download the file(s) then drag/drop (copy) them to your Team Drive.

Add Others/Members to your Team Drive and Set Permissions

Files in a Team drive belong to a team instead of an individual.  But you have to add members to your team drive.  When you add members the default permission level is full access to and ownership of all files on the drive.  See the table below for permission level details.

Full accessEdit accessComment accessView access

Can view files and folders

Y

Y

Y

Y

Can comment on files

Y

Y

Y

N

Can edit files

Y

Y

N

N

Can create and upload files, can create folders

Y

Y

N

N

Can add people to Team Drives or remove them

Y

N

N

N

Can add people to specific files

Y

Y

N

N

Can move files and folders

Y

N

N

N

Can delete files and folders

Y

N

N

N

Can restore files from trash

Y

Y

N

N

Add members to your Team Drive

  • Open your Team Drive and click Add members.
  • In the first section, start typing a name or email to choose an entry from the directory.
  • In the second section, use the drop-down arrow to change permissions.
  • An email notification will automatically be sent when you click Send.  In the third section you can type a custom message you would like to include in the email. If you don’t want an email to be sent, then click in the “Skip sending notification” box.
  • Click SEND.

Change Permissions

  • When you are on your Team Drive, you will see the number of members on the drive indicated at the top of the page.  Click on the members link.

  • The column to the right of the name indicates the permission level.  Click on the permission level to see a list of options and choose a new permission.
  • Click DONE.

More information about Google Team Drives