Using Oracle Autonomous Database for Excel

After you install the add-in, a new ribbon tab, Oracle Autonomous Database appears in MS Excel.

You can connect to multiple Autonomous Databases, work with Analytic Views, tables, and Views, and view the data in the worksheet.

This ribbon provides buttons that let you connect to the Autonomous Database.

Click Connections to connect to an Autonomous Database. You must Refer to the Connection management for more details.

Click Settings to view the logging level settings of the Excel Add-in. You can also clear the logs or export the log files by copying the logging information to the clipboard.

Click About to view the Add-in and the supported Excel versions. The About window also displays whether the spreadsheet is connected to the database. It also shows version information for the database and Oracle Rest Data Services.

Click Direct SQL to run custom SQL queries.

Click Table Hyperlinks to read and access tabular data using table hyperlinks.

Click Data Analysis to query an existing Analytic View and run queries.

Click Natural Language to run Natural Language Queries on Tables.