Install Add-in for Microsoft Excel from Trusted Catalogs

Explains how to install Oracle Database Add-in for Microsoft Excel on a standalone Excel application from Office Add-ins Trusted Catalogs.

Note:

Oracle recommends installing Spreadsheet Add-ins from an official store. If online stores are restricted or not available in your organization, you can download the add-in from Database Actions and install it manually.

Prerequisites for Windows and Mac

You have Microsoft Excel 365 installed in your system.

Download the Spreadsheet Add-ins installer, oracleplugin.zip, from Database Actions and extract the add-ins installer to a directory. For more information, see Download Spreadsheet Add-ins from Database Actions.

Before starting the installer, close the Excel application or any open workbooks if they are running.

Install Add-in for Excel in Windows

Note:

Oracle Database Add-in for Microsoft Excel is supported on Microsoft Windows 10 and Microsoft Windows 11 operating systems running Microsoft Excel 365.

  1. Open Windows File Explorer or Command Prompt and go to the directory where the add-ins installer is extracted.

  2. Run this file to start the installer script.

    install.cmd

    Note:

    The installer requires elevated privileges to run. If Windows displays a User Account Control message, click Yes to continue.

    The add-ins installer performs the following tasks:

    • Opens Command Prompt in elevated mode.

    • Checks whether Add-in for Excel is already installed on your system. If an existing installation is found, the installer provides options to repair or uninstall it. If no installation is found, it proceeds with a fresh installation.

      Note:

      When you run a repair installation of Add-in for Excel, if it removes the existing connections from the add-in, import the connections again.

    • Creates a network share and adds the add-in information to Trusted Catalogs in Microsoft Office Trust Center. The Excel application then identifies the add-in and displays Oracle Database Add-in for Microsoft Excel in Office Add-ins.

    After completion, close the Command Prompt window for the add-ins installer.

  3. Start the Excel application and open a workbook.

  4. On the Home tab select Add-ins and click Get Add-ins or More Add-ins depending on the Microsoft Office version.

    Alternatively, you can enable the Developer menu and click the Add-ins option.

  5. On the Office Add-ins window go to the SHARED FOLDER tab, select Oracle Database Add-in for Microsoft Excel.

    If the add-in is not listed, click the Refresh button to reload the page.

  6. Click Add to install the add-in on Excel.

On successful installation, Microsoft Excel displays a new tab Oracle Database.

See Also:

Remove Spreadsheet Add-ins

Install Add-in for Excel in Mac

Note:

Oracle Database Add-in for Microsoft Excel is supported on Apple Mac operating system running Microsoft Excel 365.

Create a new Add-in folder and extract the add-ins installer zip file into it.

Note:

Creating a dedicated Add-ins folder helps to keep the installation files organized. However, you can extract the installer to any directory.

  1. Open a Terminal window and go to the directory where the add-ins installer is extracted.

  2. Run this file to start the installer script.

    install.sh

    Right-click install.sh, select Open With > Other > Enable: All Applications > Utilities and click Terminal.

    The add-ins installer checks whether Add-in for Excel is already installed on your system. If found, the installer removes the existing installation and installs the version included in the extracted ZIP file. If the add-in is not installed, the installer proceeds with a fresh installation. Unlike the Windows installer, the Mac installer does not provide repair or uninstall options.

    After completion, close the Terminal window for the add-ins installer.

  3. Start the Excel application and open a workbook.

  4. On the Insert tab click My Add-ins and select Oracle Database Add-in for Microsoft Excel.

On successful installation, Microsoft Excel displays a new tab Oracle Database.

See Also:

To uninstall the add-in see Remove Spreadsheet Add-ins.

Parent topic: Installation Options for Spreadsheet Add-ins