Connect to a CSV file

Learn how to connect to a CSV file and use it as a data source for generating insights and metrics

Neli Ivanova avatar
Written by Neli Ivanova
Updated over a week ago

Overview

CSV or comma-separated values file is a popular way to store data in textual files. Many systems, such as spreadsheets and SaaS applications offer a way to export data in a CSV format.

Quantive can import any CSV file and use it as a data source for generating insights and metrics.


Example

The following is an example of a CSV file:

Name,Position,Salary
John Peters,CEO,100000
Mark Jacobs,CFO,95000
Tony Shaw,VP Sales,70000

In this example, the first row - Name,Position,Salary, is the header row that gives the names to the columns.


Prerequisites

The CSV file that you import must have headers.


Procedure

Perform the following:

  • In Quantive, navigate to Settings > Data Sources screen

  • Click the Select data source button

  • From the Choose a connector dialog, select the Files tab and then CSV file

  1. Enter a name for this data source.

  2. In the URL field, enter the publicly accessible URL of the CSV file.
    For example, this could be a file shared on pCloud or Github Gists.
    Please note that files from Dropbox aren't supported for this connector and files from Google Drive would need to be converted to .csv first.

  3. Click Connect data source.

Did this answer your question?