Configure the Splunk ODBC driver to work with Microsoft Excel

To use the Splunk ODBC Driver to get Splunk data into Microsoft Excel:

  1. Open a new worksheet in Excel.
  2. Click the Data tab.
  3. In the Data tab, click Get Data > From Other Sources, and click From ODBC.
  4. In the From ODBC window, select Splunk ODBC from the Data source name (DSN) dropdown menu, and click OK.
  5. In the Navigator window, select ODBC > All from the Display Options menu.
  6. In the ODBC driver window, enter the username and password for Splunk instance, and click Connect. Microsoft connects to your Splunk Enterprise server.
    This screenshot shows the configuration menu. The list includes Username and Password.
  7. In the Navigator menu, select your saved search from the list, and click Load.
    This screenshot shows the list of available tables. The list includes the user's Splunk saved search.

Note: The saved search may load slowly.

For more information, see "Use the Query Wizard to define a query" on the Microsoft Office website.