About Oracle Database for Spreadsheet Add-ins

Oracle Database for Spreadsheet Add-ins is a supplementary feature that facilitates seamless integration of a spreadsheet application with your Oracle Autonomous AI Database in Oracle Cloud Infrastructure.

Advantages

Spreadsheet Add-ins enable a secure connection to your database instance in Oracle Cloud from a spreadsheet. You can then run queries on your database and retrieve the results in worksheets for analysis and reporting. This eliminates the need to manually export data and import it into the spreadsheet.

You can edit query results in the worksheet, but those edits are local to the spreadsheet and are not written back to the database. However, you can modify database objects or data using Direct SQL if you have the required privileges.

Note:

Oracle recommends using Spreadsheet Add-ins only with a properly licensed or officially free version of the spreadsheet application.

Features and Functions

Spreadsheet Add-ins offer a host of features and functionalities that include:

  • Natural Language Queries

    Run queries on your database with Artificial Intelligence (AI) assistance. See Run Natural Language Queries.

  • Direct SQL Queries

    Run SQL queries on your database directly from a spreadsheet. Retrieve and manage your data using Spreadsheet Add-ins. See Run Direct SQL Queries.

  • Data Analysis

    Analyze data in your database by running custom queries on tables, views, Analytic View, and catalogs using an intuitive drag-and-drop interface and viewing them in different visual representation. See Perform Data Analysis using Spreadsheet Add-ins.

  • Table Hyperlinks

    Access and share read-only data using Table Hyperlinks, either by creating a Table Hyperlink from query results or by using a Table Hyperlink shared with you. See Access and Share Data using Table Hyperlinks.

  • Connections

    Set up connections in Spreadsheet Add-ins and connect to your database from a spreadsheet. You can import, export, and manage connections in the add-in. See Manage Connections.

  • Log Settings

    You can configure log settings in Spreadsheet Add-ins and export log files for diagnosis and troubleshooting. See Manage Settings

For common features and options in Spreadsheet Add-ins, see UI Options in Spreadsheet Add-ins.

Connect to your database from a spreadsheet to use the features of the add-in.

Note:

Before sharing query results or data with others, verify that it does not contain any personal information or sensitive data.

The About Window

This window displays basic information about the add-in that includes:

  • Version information for Spreadsheet Add-ins, Oracle REST Data Services (ORDS) application, ORDS schema, database major, and database minor

    Add-in for Excel also displays additional version information for Supported ExcelApi and Supported RibbonApi.

  • Connection status indicating whether the spreadsheet is connected to the database

  • URL of Autonomous AI Database and schema

Types of Spreadsheet Add-ins

Oracle provides the following add-ins for your spreadsheet applications.

  • Oracle Database Add-in for Microsoft Excel
  • Oracle Database Add-on for Google Sheets

Install the add-ins and integrate your spreadsheets with Autonomous AI Database. For more information, see Installation Options for Spreadsheet Add-ins.

Parent topic: Use Oracle Database for Spreadsheet Add-ins