CSV Files

CSV (Comma-Separated Values) is a simple file format used to store tabular data. It represents data in plain text with each line representing a row and values separated by commas or another delimiter. CSV files are widely used for transferring data between different applications and systems due to their simplicity and compatibility.

title

How do I activate this integration?

1

First Step

Log in to your account, navigate to the Data sources page and click on New data source.
2

Second Step

Provide a name for the data source, an optional description, and select CSV as the type. Then click on Connect.
3

Third Step

Upload a CSV file and then click on Save Changes. This should automatically fetch the column descriptions and sample data to verify if the upload was successful.

title

What can I do with this integration?

You can import data from different sheets within your CSV document as data sources on Onvo. The integration ensures that any updates in your CSV document reflect in real-time on your dashboards.

Build interactive dashboards using your CSV data, effortlessly creating widgets based on your visualization preferences. Ask questions in natural language to explore your data, and perform data pre-processing before visualization. Integrating dashboards into your products with the SDK is also supported.

title

How do I create a dashboard using multiple sheets?

On Onvo, achieve this by creating distinct data sources for each sheet and specifying the field used for data correlation in the "fields" tab. This allows the AI to generate the necessary code for joining data without manual query writing.

Security considerations

Exercise caution and only upload CSV documents that you intend to share with Onvo to prevent unintentional data exposure.