Install the drivers to work with Microsoft Excel files

You can open Microsoft Excel tables directly in ArcGIS Pro and work with them as you would do with other tabular data sources. For example, you can add Excel files to a map, open them in the fields view, and use them as inputs to geoprocessing tools. For more details, see Work with Microsoft Excel files in ArcGIS Pro.

Working with Microsoft Excel tables in ArcGIS Pro does not require that Microsoft Excel or Microsoft Office be installed on the same machine as ArcGIS Pro.

The only requirement to access and work with Excel files in ArcGIS Pro is that the appropriate drivers must be downloaded and installed correctly on the computer on which ArcGIS Pro is installed.

Depending on the configuration, a silent installation may be necessary to install the appropriate driver correctly. Attempts to access an Excel file in ArcGIS Pro without the appropriate driver installed will produce a Required Microsoft driver is not installed error.

Determine the drivers to install

Review and answer the following questions regarding the client machine configuration where ArcGIS Pro is installed to determine the appropriate drivers to install. Your answers will help you decide whether or not you need to install one or more drivers and whether a silent installation of one of those drivers is necessary to access and use Excel files in ArcGIS Pro 3.3.

Note:

Microsoft .NET Desktop Runtime 8.0.2 Windows x64 must be installed before installing ArcGIS Pro 3.3.

  • Question 1 — Are any Microsoft Office products currently installed on the same client machine on which ArcGIS Pro is installed?

  • Question 2 — Microsoft Office is installed in one of two ways: Microsoft Installer (MSI) or Click-to-Run (CTR). You must know the type of installer used because if your Microsoft Office products were installed using CTR (such as Microsoft Office 365), Microsoft side-by-side detection will prevent the installation of the 32-bit or 64-bit driver from proceeding. The note below will help you determine if the Microsoft Office products were installed on the client machine using either MSI or CTR.

    Tip:

    How do you tell if your installer type is MSI or CTR?

    (These instructions apply to any Microsoft Office application, such as Word or Excel).

    Using Word, choose File and then select Account. Under the Product Information section, within About Word, it will either show Click-to-Run or nothing after the build number. If there's nothing after the build number, it's an MSI install; otherwise, "Click-to-Run" will display if this installer type was used.

    About Word indicates the installer type of your Microsoft Office products

  • Question 3 — What is the bit version of the installed Microsoft Office products on the client machine, 32-bit or 64-bit?

    Tip:

    How do you tell if the bit level of your installation is 32-bit or 64-bit?

    (These instructions apply to any Microsoft Office application, such as Word or Excel).

    Click the About Word icon.

    About Word

    This will open the About Microsoft Word window. The top line contains the combined version and build number; at the end, it displays whether it's 32-bit or 64-bit.
    About Microsoft Word window Indicates the bit version of the installed Microsoft Office product

Driver Installation Decision Tree

Based on your answers to the questions above, use the following decision tree to help you determine if one or more Microsoft drivers need to be installed and if a silent installation of the additional driver specified is needed.

Microsoft driver installation decision tree guide to access Excel files from ArcGIS Pro 3.3
Some client machines and Microsoft Office configurations may require silent installs of additional drivers before Excel files from ArcGIS Pro can be accessed. Access a higher-resolution decision tree guide
Tip:

See the Guide to connecting to Excel files in ArcGIS Pro blog post if you need additional details, steps, or guidance to answer these questions.

Install the Microsoft Access Database Engine drivers

Microsoft Access Database Engine technology helps bridge communication and external data transfers between files that are proprietary to the Microsoft Office system and other non-Microsoft Office applications such as ArcGIS Pro.

To access and work with Excel files in ArcGIS Pro, you must download and install the Microsoft Access Database Engine 2016 Redistributable driver on your computer. This driver can be downloaded in 32-bit (x86) or 64-bit (x64) versions from the Microsoft Download Center. You can access a list of supported operating systems that use this driver and detailed installation instructions.

Click Download on the page and choose one of the following download options:

  • Microsoft Access Database Engine 2016 Redistributable 64-bit driver—(AccessDatabaseEngine_X64.exe)
  • Microsoft Access Database Engine 2016 Redistributable 32-bit driver—(AccessDatabaseEngine.exe)
    Caution:

    If the Microsoft Access Database Engine 2016 Redistributable 32-bit driver (AccessDatabaseEngine.exe) for Excel is installed, the 32-bit Microsoft .NET Desktop Runtime 8.0.2 Windows must also be installed.

Caution:

Based on the version of ArcGIS Pro you are using, review and adhere to the following information:

Perform a silent mode installation

Microsoft policy only allows you to install drivers of the same bit version as the installed Microsoft Office products. If you try to install the downloaded AccessDatabaseEngine.exe file on a machine that already has a Microsoft 64-bit application installed, you will receive an error message that you can't install a 32-bit version of the database engine because you currently have 64-bit Microsoft Office products installed. A similar error message appears if you try installing the AccessDatabaseEngine_X64.exe file on a machine with Microsoft 32-bit application installed.

To work around this situation, complete the following steps to perform a silent mode installation of the downloaded files:

Caution:

Ensure that the ArcGIS Pro application is closed before performing a silent installation.

  1. From the Windows taskbar search box, type Settings. In the Apps & features pane, search for Microsoft Access Database Engine 2016 to determine if any previous installations of the 64-bit or 32-bit Microsoft Access Database Engine 2016 Redistributable drivers exist. If so, remove these previous installations by right-clicking on them and choosing Uninstall.
  2. From the Microsoft Download Center, download the Microsoft Access Database Engine 2016 Redistributable driver(s).
    Tip:

    If you are planning to access Excel files from ArcGIS Pro 3.3 or later, and an ArcMap 10.x client installed on the same client machine will require a silent mode install of each of the following downloaded driver files.:

    • 32-bit and 64-bit Microsoft Access Database Engine 2016 Redistributable drivers
    • 32-bit and 64-bit Microsoft .NET Desktop Runtime 8.0.2 installers

  3. Save the downloaded file(s) locally to your computer, such as on the C: drive.
  4. Using the Windows search box on the taskbar, type Command Prompt.
  5. Right-click the Command Prompt application and click Run as administrator.

    The command prompt opens to a default directory.

  6. Type cd C:\ to change the directory to the drive where you saved the downloaded file.
  7. To run the .exe file(s) as a silent installation, type AccessDatabaseEngine.exe /quiet or AccessDatabaseEngine_X64.exe /quiet, depending on the file(s) you've selected to download from the Microsoft Download Center.
    Tip:

    It is recommended that the 32-bit driver(s) be installed first, then proceed with installing the 64-bit driver(s).

  8. It is recommended that you restart your computer after the installation.

    Note:
    To confirm the new driver(s) have been installed, in the Windows taskbar search box, type Settings. In the Apps & features pane, search for Microsoft Access Database Engine 2016. Additionally, the current date of the silent installation should be displayed. If it isn't there or you have any problems with the installation information listed above, see Guide to connecting to Excel files in ArcGIS Pro for additional installation instructions or contact support services.