Skip to content
ODBC and client applications › Create data sources from other apps using ODBC driver › Additional integration resources › Web services › API implementation › API implementation and reference
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Use the ODBC driver in Excel

After installing the ODBC driver and its associated DSN, use it in Excel as a data source provider.

Before you begin

Role required: admin

Procedure

  1. In Excel, open the Data tab.

  2. Under From Other Sources, open From Microsoft Query.

Image omitted: ExcelOtherQuery.png
From Microsoft Query.

  1. Select ServiceNow as your database (the default DSN name).

  2. Clear the Use the Query Wizard to create/edit queries check box.

    Note: The Excel Query Wizard does not support the listing of columns from a table name that contain an underscore ( _ ). Clearing this check box uses the Query Builder instead, which supports the use of this character.

Image omitted: ExcelServiceNowDataSource.png
ServiceNow Data Source.
  1. Supply the ServiceNow user name and password.
Image omitted: ExcelDataSourceLogin.png
Data Source Login.
  1. Select a table from the ServiceNow instance and click Add.
Image omitted: ExcelODBCAddTable.png
Add Table.

  1. Close the dialog box.

  2. Select the table columns that the Query Builder retrieves the data from.

    Use the list above the table or enter the names directly into the columns, and then press Enter.

  3. Retrieve the data and create the Excel record by clicking the Return Data icon or selecting File > Return Data to Microsoft Office Excel.

Image omitted: QueryBuilderRetrieveData.png
Query Builder Retrieve Data.
The requested data is brought into Excel.
Image omitted: ExcelODBCResults.png
Excel ODBC Results.

Parent Topic:ODBC and client applications