Field values with formulas in .xls files appear as nulls in ArcGIS Pro

Description

Table fields in Microsoft Excel (.xls) files added in ArcGIS Pro display nulls if the fields are formatted with certain formulas. However, the same table displays field values in ArcMap.

Cause

This issue may occur due to unsupported field types used for formulas in the Microsoft Excel document. The field type specified in the Microsoft Excel table does not determine the field type used in ArcGIS Pro. ArcGIS Pro uses Geospatial Data Abstraction Library (GDAL) drivers and the supporting OGR Vector Formats to read Excel files. When a Microsoft Excel table is added to ArcGIS Pro, GDAL determines the field type used. Formulas that are not supported by the field type in ArcGIS Pro appear as null values in the attribute table.

Solution or Workaround

• Save the .xls document into another format such as .xlsx or .csv before adding it to ArcGIS Pro.
• Copy and paste all the fields into a new Microsoft Excel document, and use computed values for the fields instead of formulas before adding it to ArcGIS Pro.