Splunk® ODBC Driver

Install and Use Splunk ODBC Driver

Configure the Splunk ODBC driver to work with Microsoft Excel on macOS

To use the Splunk Open Database Connectivity (ODBC) Driver to get Splunk platform data into Microsoft Excel on macOS:

  1. Download and install ODBC Manager, if you have not done so already.
  2. In Microsoft Excel, open a new worksheet.
  3. Click the Data tab.
  4. In the Data tab, click New Database Query > From Database. An ODBC manager window appears.
  5. In the ODBC manager window, select the System DSN button, and select Splunk ODBC from the System Data Sources list.
  6. Click OK. A Splunk ODBC window appears.
  7. In the Splunk ODBC window, enter the username and password for your Splunk platform instance, and click OK. Microsoft connects to your Splunk platform server.
  8. In the Microsoft Query menu, expand Splunk connection > All, select your saved search from the list, and click Return Data, or click Run.
    This screenshot shows the list of available tables. The list includes the user's Splunk saved search.
  9. Select where you want to put the data, and click OK

The saved search may load slowly. Performance depends on the computing power of the client machine, network speed, search complexity, and data volume.

For more information, see Use the Query Wizard to define a query in the Microsoft Office documentation.

Last modified on 13 February, 2023
Access data models using the Splunk ODBC Driver   Configure the Splunk ODBC driver to work with Tableau Desktop on macOS

This documentation applies to the following versions of Splunk® ODBC Driver: 3.1.0, 3.1.1

Was this topic useful?

You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters