Oracle Database for Excel
The Oracle Database Add-in for Microsoft Excel integrates Microsoft Excel spreadsheets with the Oracle Autonomous AI Database to retrieve and analyze data from Analytic Views in the database. You can run Direct SQL queries to view their results in the worksheet and run Natural Language queries with Artificial Intelligence (AI) assistance.
Note
- The Download Microsoft Excel/Google Sheets
add-in is available to you under the
Downloads menu of your Database Actions instance only
if you have the
ADPUSERrole. - You require ADMIN privileges to grant roles.
- To grant yourself an
ADPUSERrole, you must log into your Database Actions instance and enter the following command in the SQL worksheet area displayed in the SQL tab under Development tools present in the Launchpad:Grant ADPUSER to USER;You can also grant roles to users using the UI options in Database Actions. For more information, see unresolvable-reference.html#GUID-856BBD92-DFEC-4C6E-A8EE-54368078F699.
- Use the Microsoft Edge browser for the best compatibility and performance.
- Install the add-in from Microsoft AppSource
The Oracle Database for Excel is available in Microsoft AppSource. - Install the add-in from Database Actions
You can install the add-in from Database Actions. This is accessed by users with Oracle Account. - Uninstall the add-in
The following section describes the steps to uninstall the Oracle Database add-in. - Using Oracle Database for Excel
After you install the add-in, a new ribbon tab, Oracle Database appears in MS Excel. - Connection management
Connections are medium of communication with your Oracle Autonomous AI Database. It contains information that helps in authenticating with database instances and accessing data from a spreadsheet. - Log Settings
The Settings icon enables you to set the log levels using the Excel add-in. - Run Direct SQL queries in an Excel worksheet
The Oracle Autonomous AI Databasefor Excel lets you run Direct SQL queries to work with your data in an Excel worksheet. - Read and Access Data Using Table Hyperlinks in Excel Sheet
Table Hyperlinks in Oracle Database provide secure, preauthenticated URLs that allow read-only access to data stored in tables, views, or the result of SQL queries. - Reporting and Analysis in Excel
You can view Reports and Analytic Views or visualizing data for analysis purpose using the Analysis and Reports menu. - Query an Analytic View in an Excel worksheet
The Query Wizard menu enables you to query an Analytic View and retrieve the results in an Excel Worksheet. Once the wizard retrieves the data, it becomes local to Excel. You can further edit the data in Excel but not write back to the Autonomous AI Database. - Data Analysis in Excel Sheet
The Data Analysis tool enables you to analyze data in the Autonomous Database by running SQL queries or querying an Analytical View using an intuitive drag-and-drop interface. You can also write custom queries to be run. You now can dynamically apply filters to the result set retrieved using the new faceted search capability on specific columns. - Natural Language in Excel Sheet
You can use Natural Language Query to query the Oracle Autonomous AI Database using the Natural Language menu in the Oracle Database for Excel . - FAQs for Troubleshooting errors with Excel Add-in
If you experience issues with Oracle Database for Excel, refer to frequently asked questions in this section to identify and resolve issues. - Oracle Database for Excel Privacy Policy Details
This topic covers details for writing policies to control access to Oracle Database resources.
Parent topic: The Data Analysis Tool