Connecting to Google Drive

Import using CSV

Upload File

Pick from Google Drive

Import from URL

Schedule your Import, and Snapshots, and Add Data Alerts

FAQs for CSV

Do you have data from your CSV files needed to be transferred to Google Sheets? Now, CSV files can be used to import data to your sheets through our CSV Integration. This allows you to either upload your file, select from your own Google Drive or even use a URL and have it imported to your sheets in no time. 🎉

Connecting to Google Drive

When you begin a CSV import for the first time, you will need to connect/authorize Coefficient to your Google Drive account successfully.

Note: You can still use the “Import from URL” option even without connecting to your Google Drive and it should allow you to import from another CSV file.

  1. Launch the Coefficient Sidebar and select “Import from...”

Untitled

  1. From the listed data sources, select “CSV” then click “Upload File” from the options.

    Untitled

  2. “Authorize” Coefficient to connect to your Google Drive.

    Untitled

  3. Coefficient will prompt you to confirm the account you want to connect.

    CSV1.png

  4. “Allow” Coefficient access to your account. Once you complete this step you will be taken back to Sheets to upload your CSV from Google Drive.

    CSV2.png

Import using CSV

There are 3 different ways to import data using Coefficient’s CSV integration, Upload File, Pick from Google Drive, and Import from a URL.

Upload File

  1. Inside the sidebar, select “Import from…”

    Untitled

  2. From the data sources listed, select “CSV”. (usually found towards the bottom of the list)

    Untitled

  3. Select “Upload File”.

    Untitled

  4. A window will appear allowing you to drag and drop you file into the area provided, or you can select the file from your device.

Untitled