Open navigation

How to connect data from CSV files

If you can't find a data source you wish to report from in Supermetrics, you can connect a downloaded dataset to your Google Sheets spreadsheet or Data Studio report. Any data in a valid CSV format can be connected as a custom data source through Supermetrics.


Before you begin

File setup

The CSV file should only contain comma-separated data. Set the field headers on the first row, and the data in matching order to the following rows.


Make sure the CSV file can be accessed directly from a URL, or alternatively, upload the CSV file to a Google Drive location.


Instructions


Google Sheets Data Studio

Before you can connect your CSV data to Google Sheets, you need to install the Supermetrics add-on.

  1. Open a new Google Sheets file
  2. Click Add-ons → Supermetrics → Launch to open the sidebar.
  3. Under Data source, select JSON/CSV/XML.
  4. Under Report configuration, fill in the URL where your CSV file is located to the Type URL field.
    • If your CSV file is located in Google Drive, use the Get link sharing option. Make sure the sharing link enables Anyone with the link view access to the file.
  5. Under Data type, select CSV.
  6. Finally, click Get data to table.
    • Your data will be inserted starting from the cell you have selected in the spreadsheet.


More resources


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.