laptop and a wrench

Bug

If a column in an XLSX or XLS file contains data of the form #-#-## and is set as a string field during an import, this produces an empty data table in ArcGIS Online.

ArcGIS Online
Bug ID Number BUG-000154183
SubmittedDecember 5, 2022
Last ModifiedAugust 5, 2024
Applies toArcGIS Online
Version foundNovember 2022
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusNon-Reproducible

Additional Information

This issue is not reproducible in ArcGIS Online. If the issue occurs, contact Esri Support Services, as additional information is required for further investigation.

Workaround

  • If the field type is not changed from Date to String, the data is shown in the table.
  • Saving the file to CSV UTF-8 resolves this issue, as the field then defaults to String.

Steps to Reproduce

Bug ID: BUG-000154183

Software:

  • ArcGIS Online

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options