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.
How do I activate this integration?
First Step
New data source
. Second Step
Connect
. Third Step
Save Changes
. This should automatically fetch the column descriptions and sample data to verify if the upload was successful. 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.
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.