https://community.esri.com/t5/arcgis-survey123-questions/exporting-data-as-an-excel-document-inserts/m-p/1579787#M61005 <P>I am trying to use "esriFieldTypeTimestampOffset" and "esriFieldTypeDateOnly" in the bind::esri::fieldType column to cut down on end user confusion about time zones; however, when exporting data from the Survey123 data website to an Excel document, the new field types have a leading backtick in the cells. The leading backtick is not present when exporting as a CSV, so I don't think it's in the data itself but is instead being added to the Excel cells in that column during the export process.</P><P>This happens whether I use dateTime or date in "Type" column and whether or not I also add dateTime and date to the bind::type column. It also happens whether or not I add "once" (e.g., "once(now())") to the calculation or leave it as "now()" or "today()".</P><P>Just FYI - it is NOT an apostrophe. It's actually what I assumed it was at first and tried to use the Text to Columns Excel feature to remove it. When that didn't work, I realized it was the backtick.</P><P>Anyone have any idea why it does this? Or, better yet, how to stop it? Attached is an admittedly messy copy of the exported results as I tried to play around with the fields.</P><P>Thanks!</P> Tue, 28 Jan 2025 23:42:23 GMT LMedeirosUI 2025-01-28T23:42:23Z https://community.esri.com/t5/arcgis-survey123-questions/exporting-data-as-an-excel-document-inserts/m-p/1579787#M61005 <P>I am trying to use "esriFieldTypeTimestampOffset" and "esriFieldTypeDateOnly" in the bind::esri::fieldType column to cut down on end user confusion about time zones; however, when exporting data from the Survey123 data website to an Excel document, the new field types have a leading backtick in the cells. The leading backtick is not present when exporting as a CSV, so I don't think it's in the data itself but is instead being added to the Excel cells in that column during the export process.</P><P>This happens whether I use dateTime or date in "Type" column and whether or not I also add dateTime and date to the bind::type column. It also happens whether or not I add "once" (e.g., "once(now())") to the calculation or leave it as "now()" or "today()".</P><P>Just FYI - it is NOT an apostrophe. It's actually what I assumed it was at first and tried to use the Text to Columns Excel feature to remove it. When that didn't work, I realized it was the backtick.</P><P>Anyone have any idea why it does this? Or, better yet, how to stop it? Attached is an admittedly messy copy of the exported results as I tried to play around with the fields.</P><P>Thanks!</P> Tue, 28 Jan 2025 23:42:23 GMT https://community.esri.com/t5/arcgis-survey123-questions/exporting-data-as-an-excel-document-inserts/m-p/1579787#M61005 LMedeirosUI 2025-01-28T23:42:23Z