Bug
The Excel To Table script tool fails after upgrading the xlrd library from the default 1.2.0 version to the 2.0.1 version. The library upgrades automatically when using Python Package Manager or conda install to install or upgrade both the pandas and psycopg2 Python packages. XLRD doc is not supporting .xlsx in 2.0.1 version. Refer to https://xlrd.readthedocs.io/en/latest/.
| Bug ID Number | BUG-000136702 |
|---|---|
| Submitted | January 12, 2021 |
| Last Modified | July 9, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 2.7 |
| Operating System | Windows OS |
| Operating System Version | 10.0 |
| Version Fixed | 2.8 |
| Status | Fixed |
Workaround
The Excel To Table tool works when the xlrd Python Package is in a version before 1.2.0, and continues to work with .xls format input tables.
Steps to Reproduce
Bug ID: BUG-000136702
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App