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

Note: 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.