Microsoft Excel
Excel is a spreadsheet application from Microsoft that allows users to create, edit, and collaborate on spreadsheets. With its integration capabilities, you can connect Excel to various data sources and build dynamic dashboards and reports for visualizing and analyzing data.
How do I activate this integration?
First Step
Log in to your Onvo account, navigate to the Data sources page and click on New data source.
Second Step
Provide a name for the data source, an optional description, and select
Excel as the type. Then click on Connect.
Third Step
Upload an excel file and then click on 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 Excel document as data sources on Onvo. The integration ensures that any updates in your Excel document reflect in real-time on your dashboards.
Build interactive dashboards using your Excel 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 Excel documents that you intend to share with Onvo to prevent unintentional data exposure.