CSV

Section header image mobile

Do you have data from your CSV files that need 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

Import using CSV

From Google Drive

Upload File

Import from URL

Schedule your Import, Snapshots, and Add Automations

FAQs for CSV

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...”

Screenshot 2023-11-22 at 7.15.34 AM.png

2. From the listed data sources, select “CSV”.

Screenshot 2023-11-23 at 3.25.34 AM.png

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

AFSAWF.png

 

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

DBSFV.png

5. “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.

GERG.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.

From Google Drive

1. Open the Coefficient Sidebar and select "Import from".

Screenshot 2023-11-22 at 7.15.34 AM.png

2. Select "CSV" from the options.

Screenshot 2023-11-23 at 3.25.34 AM.png

3. Select “From Google Drive”

Screenshot 2023-11-23 at 3.19.47 AM.png

 

4. A window will appear allowing you to select a file from one of your Drive folders.CSV3.png

5. The sidebar will populate with the column headers in your file (you can uncheck/check to remove/add them to the import. You can also open/change the file here as well.

Untitled.png

6. Customize the import with additional filtering and even set it to skip the first row to define the headers.

ℹ️ NOTE: If your source file doesn't begin with a header row, skip non-header rows to specify where the header row begins.

Untitled (1).png

7. Congratulations on your successful import from Google Drive 🎉Untitled (4).png

ℹ️ NOTE: If you add a new CSV file to Drive with the same (exact) name as the source file, Coefficient will pick up the updated file when the import is refreshed.

Upload File

1. Open the Coefficient Sidebar and select "Import from".

Screenshot 2023-11-22 at 7.15.34 AM.png

2. Select "CSV" from the options.

Screenshot 2023-11-23 at 3.25.34 AM.png

3. Select “Upload File”.

Screenshot 2023-11-23 at 3.17.13 AM.png

 

4. A window will appear allowing you to drag and drop your file into the area provided, or you can select the file from your device.Screenshot 2023-11-23 at 3.18.34 AM.png

5. The sidebar will populate with the column headers in your file (you can uncheck/check to remove/add them to the import. You can also open/change the file here as well).

Untitled.png

6. Customize the import with additional filtering and even set it to skip the first row to define the headers.

ℹ️ NOTE: If your source file doesn't begin with a header row, skip non-header rows to specify where the header row begins.

Untitled (1).png

7. Congratulations on your successful CSV import with Coefficient! 🎉Untitled (2).png

Import from URL

1. Open the Coefficient Sidebar and select "Import from".

Screenshot 2023-11-22 at 7.15.34 AM.png

2. Select "CSV" from the options.

Screenshot 2023-11-23 at 3.25.34 AM.png

3. Select “Import from URL”

Screenshot 2023-11-23 at 3.20.15 AM.png

 

4. Paste the URL in the text box provided.

Screenshot 2023-11-23 at 3.23.31 AM.png

5. The sidebar will populate with the column headers from your source file (you can uncheck/check to remove/add them to the import. You can also open the source file by clicking the arrow enclosed in a box button.

Untitled.png

6. Customize the import with additional filtering and even set it to skip the first row to define the headers.

ℹ️ NOTE: If your source file doesn't begin with a header row, skip non-header rows to specify where the header row begins.

Untitled (1).png

 

7. Congratulations on your successful URL import! 🎉Untitled (4).png

Schedule your Import, Snapshots, and Add Automations

Once you have pulled your data into Sheets using Coefficient, you can set up the following:

1. Schedule your ImportScheduled_Refreshes.png

2. Turn on SnapshotsSnapshot.png

3. Set Up Automations

AutomationswithGPT.png

FAQs for CSV

There is an error in my URL import. What could be the reason?

  1. Check the format of the URL - it should return a CSV file and not HTML.
  2. If you publish your file to the web using Google Sheets - make sure that the file does not have any restrictions that block you from using its content. (permissions)
  3. Inspect the content type of your file and make sure it is comma-separated/delimited values. (Coefficient does not currently support other delimiters). The file extension should also end in “.csv”.
  4. If all of these are correct and you still experience errors, please contact support@coefficient.io for further assistance.

Was this article helpful? 0 out of 0 found this helpful