Connecting to OneDrive

Connecting to Google Drive

Importing from Excel

From OneDrive

From Google Drive

Upload File

From URL

Schedule your Import, Snapshots, and Data Alerts

FAQs for Excel

Connecting to Cloud Storage

Prior to completing an import from Excel, you will need to connect/authorize Coefficient permissions to access your Cloud Storage (OneDrive or Google Drive). ☁️

Connecting to OneDrive

  1. Open the sidebar and select “Import from…”

    Screenshot 2023-02-16 at 5.31.13 PM.png

  2. Select Excel from the list.

    Screenshot 2023-02-16 at 5.32.33 PM.png

  3. Select “From One Drive”.

    Screenshot 2023-02-16 at 5.36.15 PM.png

  4. Enter your username and password for your OneDrive account.

    Screenshot 2023-02-16 at 5.42.44 PM.png

    Screenshot 2023-02-16 at 5.55.32 PM.png

  5. Once authentication has been confirmed - you can proceed with your Excel import. 😎

    Screenshot 2023-02-16 at 5.44.08 PM.png

Connecting to Google Drive

  1. Open the sidebar and select “Import from…”

    Screenshot 2023-02-16 at 5.31.13 PM.png

  2. Select Excel from the list.

    Screenshot 2023-02-16 at 5.32.33 PM.png

  3. Select “From Google Drive”.

    Screenshot 2023-02-16 at 8.14.41 PM.png

  4. Click “Authorize”.

    Screenshot 2023-02-16 at 10.28.52 PM.png

  5. Select the Google account you wish to connect to.

    Screenshot 2023-02-16 at 10.29.43 PM.png

  6. Grant Coefficient access by selecting “Allow”.

    Screenshot 2023-02-16 at 10.30.42 PM.png

  7. Once access has been given, you can now select your Excel file from Google Drive to import. ✅

    Screenshot 2023-02-16 at 10.31.51 PM.png

<aside> 💡 If you've previously connected to your Google Drive, you will not be prompted to reauthorize - can select your import(s) directly.

</aside>