https://community.esri.com/t5/arcgis-for-excel-questions/how-to-decide-a-field-type-when-uploading-xlsx-to/m-p/1546016#M247 <P><A href="https://doc.arcgis.com/en/microsoft-365/latest/excel/data-types-formats-and-categories.htm#ESRI_SECTION1_DC718093F6434AD5950F0496635DD6E2" target="_blank">https://doc.arcgis.com/en/microsoft-365/latest/excel/data-types-formats-and-categories.htm#ESRI_SECTION1_DC718093F6434AD5950F0496635DD6E2</A></P><P>You can set the cell format in Excel and ArcGIS for Excel should interpret it as per the above.</P><P>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.</P><P><A href="https://support.esri.com/en-us/knowledge-base/problem-generic-errors-from-uploading-and-published-csv-000024821" target="_blank">https://support.esri.com/en-us/knowledge-base/problem-generic-errors-from-uploading-and-published-csv-000024821</A></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 07 Oct 2024 03:25:19 GMT ChristopherCounsell 2024-10-07T03:25:19Z https://community.esri.com/t5/arcgis-for-excel-questions/how-to-decide-a-field-type-when-uploading-xlsx-to/m-p/1546005#M246 <P>I add a xlsx file to Microsoft Excel and share it with ArcGIS Online via ArcGIS for Excel plugin.<BR />I procedd these steps below.</P><P>・ArcGIS for Excel: Share a layer to ArcGIS<BR /><A href="https://doc.arcgis.com/en/microsoft-365/latest/excel/share-a-layer-to-arcgis.htm" target="_blank" rel="noopener">https://doc.arcgis.com/en/microsoft-365/latest/excel/share-a-layer-to-arcgis.htm</A></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sample.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/116577i49AB2FC2353DF97C/image-size/large?v=v2&amp;px=999" role="button" title="sample.png" alt="sample.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">sample.png</span></span></P><P>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.</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/help/data/excel/work-with-excel-in-arcgis-pro.htm#GUID-E4C38438-93DC-472A-9A36-0A64E48FF16B" target="_blank" rel="noopener">https://pro.arcgis.com/en/pro-app/latest/help/data/excel/work-with-excel-in-arcgis-pro.htm#GUID-E4C38438-93DC-472A-9A36-0A64E48FF16B</A></P><P>&nbsp;</P><P>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...</P> Mon, 07 Oct 2024 02:13:50 GMT https://community.esri.com/t5/arcgis-for-excel-questions/how-to-decide-a-field-type-when-uploading-xlsx-to/m-p/1546005#M246 hitsujir_dev 2024-10-07T02:13:50Z https://community.esri.com/t5/arcgis-for-excel-questions/how-to-decide-a-field-type-when-uploading-xlsx-to/m-p/1546016#M247 <P><A href="https://doc.arcgis.com/en/microsoft-365/latest/excel/data-types-formats-and-categories.htm#ESRI_SECTION1_DC718093F6434AD5950F0496635DD6E2" target="_blank">https://doc.arcgis.com/en/microsoft-365/latest/excel/data-types-formats-and-categories.htm#ESRI_SECTION1_DC718093F6434AD5950F0496635DD6E2</A></P><P>You can set the cell format in Excel and ArcGIS for Excel should interpret it as per the above.</P><P>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.</P><P><A href="https://support.esri.com/en-us/knowledge-base/problem-generic-errors-from-uploading-and-published-csv-000024821" target="_blank">https://support.esri.com/en-us/knowledge-base/problem-generic-errors-from-uploading-and-published-csv-000024821</A></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 07 Oct 2024 03:25:19 GMT https://community.esri.com/t5/arcgis-for-excel-questions/how-to-decide-a-field-type-when-uploading-xlsx-to/m-p/1546016#M247 ChristopherCounsell 2024-10-07T03:25:19Z https://community.esri.com/t5/arcgis-for-excel-questions/how-to-decide-a-field-type-when-uploading-xlsx-to/m-p/1546060#M248 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/412943">@ChristopherCounsell</a>&nbsp;Thank you for sharing the reference page and Tech article. These are so useful!</P><P>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.<BR />I will prepare data&nbsp;<SPAN>while referencing</SPAN>&nbsp;microsoft-365 help page.<BR /><BR />Regards,<BR /><SPAN>hitsujir</SPAN></P> Mon, 07 Oct 2024 09:05:43 GMT https://community.esri.com/t5/arcgis-for-excel-questions/how-to-decide-a-field-type-when-uploading-xlsx-to/m-p/1546060#M248 hitsujir_dev 2024-10-07T09:05:43Z