Bug
When uploading a Microsoft Excel file containing data with leading zeroes, the leading zeroes are dropped when the file is published as a hosted layer. Even if the data type is changed to a string, the data type is detected as Double in ArcGIS Online, and the leading zeroes are removed.
| Bug ID Number | BUG-000158649 |
|---|---|
| Submitted | May 29, 2023 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Online |
| Version found | February 2023 |
| Operating System | N/A |
| Operating System Version | N/A |
| Status | Non-Reproducible |
Additional Information
This issue is not reproducible in the current version of ArcGIS Online. If experiencing this issue, contact Esri Support Services.Workaround
Add a character before the leading zero in the first 10 elements of the Microsoft Excel file before publishing. By doing so, the column is recognized as a string in ArcGIS Online, and the leading zeros are not removed.
Steps to Reproduce
Bug ID: BUG-000158649
Software:
- ArcGIS Online
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