How to decide a field type when uploading xlsx to ArcGIS Online via ArcGIS for Excel?

[hitsujir_dev]

I add a xlsx file to Microsoft Excel and share it with ArcGIS Online via ArcGIS for Excel plugin.
I procedd these steps below.

・ArcGIS for Excel: Share a layer to ArcGIS
https://doc.arcgis.com/en/microsoft-365/latest/excel/share-a-layer-to-arcgis.htm

I know that users are unable to choose "field type" when sharing ArcGIS Online, so try to set a dummy first line and control their filed types. I was looking for documents how to decide a field type in ArcGIS for Excel, but found only ArcGIS Pro document.

https://pro.arcgis.com/en/pro-app/latest/help/data/excel/work-with-excel-in-arcgis-pro.htm#GUID-E4C3...

I observed both their "all" values(especially, Text or Number) and "The format of a cell" in Excel affect their field types, but need more information...

[ChristopherCounsell · Accepted solution]

https://doc.arcgis.com/en/microsoft-365/latest/excel/data-types-formats-and-categories.htm#ESRI_SECT...

You can set the cell format in Excel and ArcGIS for Excel should interpret it as per the above.

However, when sharing to ArcGIS Online, the cell values need to be valid for the field type. If your data does not align with the format it may convert it to string or later return an error.

https://support.esri.com/en-us/knowledge-base/problem-generic-errors-from-uploading-and-published-cs...

[hitsujir_dev]

@ChristopherCounsell Thank you for sharing the reference page and Tech article. These are so useful!

I understood that "There was an error." messages is displayed when sharing with ArcGIS Online(I often face it, too), so it is difficult to control field types of xlsx/csv with a first dummy line.
I will prepare data while referencing microsoft-365 help page.

Regards,
hitsujir