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.
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 Microsoftdrivers need to be installed and if a silent installation of the additional driver specified is needed.
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
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:
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.
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).
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).
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.