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?
- If no, proceed to the driver installation decision tree.
- If yes, proceed to answer question 2 and question 3.
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.
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.
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.
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.
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:
- ArcGIS Pro 3.3 or later
- Beginning with the ArcGIS Pro 3.3 release, the Microsoft .NET Desktop Runtime 8.0.2 Windows x64 must be installed prior to installing ArcGIS Pro. For more information, see the ArcGIS Pro software requirements.
- The Microsoft Access Database Engine 2016 Redistributable 64-bit driver for Excel will work with the Microsoft .NET Desktop Runtime 8.0.2 Windows x64 installer without additional installation requirements.
- 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 x86 must also be installed.
- When accessing Excel files from ArcGIS Pro 3.3 or later, and ArcMap 10.x client installed on the same machine will require downloading and using a silent mode installation for the following four driver installers:
- 64-bit and 32-bit Microsoft Access Database Engine 2016 Redistributable drivers
- 64-bit and 32-bit Microsoft .NET Desktop Runtime 8.0.2 installers
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.
- 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.
- 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
- Save the downloaded file(s) locally to your computer, such as on the C: drive.
- Using the Windows search box on the taskbar, type Command Prompt.
- Right-click the Command Prompt application and click Run as administrator.
The command prompt opens to a default directory.
- Type cd C:\ to change the directory to the drive where you saved the downloaded file.
- 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).