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

Follow these steps to Configure the Splunk Open Database Connectivity (ODBC) driver to work with Microsoft Excel on a Microsoft Windows system.

1. In Microsoft Excel, open a new worksheet.
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) drop-down list, 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 your Splunk platform instance, and click Connect. Microsoft connects to your Splunk platform server.
   
7. In the Navigator menu, select your saved search from the list, and click Load.
   

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 the Use the Query Wizard to define a query topic in the Microsoft Office documentation.