topic Formatting Question in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/formatting-question/m-p/786224#M7182 <HTML><HEAD></HEAD><BODY><P>Can anyone tell me how to format the excel spreadsheet in Survey123 so I don't get double quotes for what should be an inch symbol? I'm pulling data from the info.csv table to populate fields. See example attached.&nbsp;</P><P></P><P><IMG alt="" class="jive-emoji image-1 jive-image j-img-original" src="/legacyfs/online/478475_Survey123 Connect for ArcGIS.jpg" /></P></BODY></HTML> Wed, 15 Jan 2020 18:53:43 GMT MichelleDuncan2 2020-01-15T18:53:43Z Formatting Question https://community.esri.com/t5/arcgis-survey123-questions/formatting-question/m-p/786224#M7182 <HTML><HEAD></HEAD><BODY><P>Can anyone tell me how to format the excel spreadsheet in Survey123 so I don't get double quotes for what should be an inch symbol? I'm pulling data from the info.csv table to populate fields. See example attached.&nbsp;</P><P></P><P><IMG alt="" class="jive-emoji image-1 jive-image j-img-original" src="/legacyfs/online/478475_Survey123 Connect for ArcGIS.jpg" /></P></BODY></HTML> Wed, 15 Jan 2020 18:53:43 GMT https://community.esri.com/t5/arcgis-survey123-questions/formatting-question/m-p/786224#M7182 MichelleDuncan2 2020-01-15T18:53:43Z Re: Formatting Question https://community.esri.com/t5/arcgis-survey123-questions/formatting-question/m-p/786225#M7183 <HTML><HEAD></HEAD><BODY><P>Hi Michelle</P><P></P><P>When working on a CSV in Excel, it can enclose text strings in double quotes " " (particularly if the string contains spaces). The quote mark used in the string (used for inches) could be confusing things. Try opening the CSV in a text editor to see if it shows something like&nbsp;"CROSS PLATE ANCHOR 24""". A simple fix would be to find/replace all the triple quotes with double quotes in the text editor.</P><P></P><P>Hope this helps</P><P>Best,</P><P>Jim</P></BODY></HTML> Fri, 17 Jan 2020 06:06:13 GMT https://community.esri.com/t5/arcgis-survey123-questions/formatting-question/m-p/786225#M7183 Jim-Moore 2020-01-17T06:06:13Z