How to Connect Excel to an Oracle Database

Download Article

Import raw Oracle data into a spreadsheet you can sort and filter

Written by Nicole Levine, MFA

Last Updated: July 2, 2024 References

Download Article

Oracle Client Setup

|

Connecting to the Database in Excel

This wikiHow teaches you how to connect an Excel workbook to an Oracle database using Power Query. Note that the Oracle connector is only available in Microsoft 365 Apps for Enterprise Edition, Office 2019 Professional Plus, and Office 2016 Professional Plus. ^{[1]
X
Trustworthy Source
Microsoft Support
Technical support and product information from Microsoft.
Go to source}

Connecting Excel to Oracle: Fast Facts

Install both the Oracle Instant Client and the Oracle ODBC package, and add the install directory to your system path. To connect to the Oracle database in Excel, go to Data > Get Data > From Database , select From Oracle Database . Not all versions of Excel support Oracle DBs.

Part 1

Part 1 of 2:

Installing the Oracle Client and DB Connector

Download Article

1
Download the Oracle Instant Client. Go to https://www.oracle.com/database/technologies/instant-client/downloads.html and click the download link for your operating system and processor type/architecture. You can opt for the Basic or Basic Light version—the only difference is that Basic Light only includes English error messages and Unicode, ASCII, and Western European character set support. ^{[2]
X
Research source}
- To find your architecture on Windows, type "System Information" into the Windows search bar, and check the value of "System type."
- If you're using a Mac, you'll see separate download links for Intel and ARM processors. If you have an Apple silicon processor, choose the ARM download. You can find your processor type in the Apple menu > About this Mac . ^{[3]
  X
  Research source}
2
Install the client.
- Windows
  - Unzip the files.
  - Move the files to an easy-to-remember location, such as C:\Oracle\instantclient_23_4.
  - Add the directory to the PATH environment variable . ^{[4]
    X
    Research source}
- Mac
  - Double-click the DMG file to mount it.
  - Open a Terminal and enter the directory of the mounted package using the cd command. For example, cd /Volumes/instantclient-basic-macos.x64-19.16.0.0.0dbru . ^{[5]
    X
    Research source}
  - Type ./install_ic.sh and press Return .
  - Add the install directory to your path using the command export PATH=$PATH:/Users/user-name/Downloads/instantclient_23_3 . Replace "user-name" with your username, and the version of Instant Client with the version you downloaded.
Advertisement
3

Download the ODBC package. Return to the Oracle Instant Client download page and click the version you installed. Click the latest version number, then scroll down to the "ODBC Package" section. Click the download link to save the file.
4
Install the ODBC driver.
- Windows
  - Extract the ZIP file and copy its contents to the directory where you installed the Instant Client.
  - Run the odbc_install.exe file in the instant client directory. If you get a security warning, click More and allow it to run anyway.
- Mac
  - Mount the DMG file.
  - Open a Terminal and enter the directory of the mounted package using the cd command. For example, cd /Volumes/instantclient-obdb-macos.x64-19.16.0.0.0dbru .
  - Type ./install_ic.sh and press Return .