topic Re: &quot;No data found&quot; when creating layer from Excel sheet in ArcGIS Online Questions https://community.esri.com/t5/arcgis-online-questions/quot-no-data-found-quot-when-creating-layer-from/m-p/708336#M35117 <HTML><HEAD></HEAD><BODY><P>Hi Dan,</P><P></P><P>This is very helpful advice and I appreciate your taking the time to read my question. I'm going to try the Excel to table method next time. This time I did do the direct import, and what was fouling it up was a stray special character. All resolved now.</P><P></P><P>Thanks,</P><P>Erin</P></BODY></HTML> Wed, 29 Jul 2020 18:03:39 GMT ErinCheever 2020-07-29T18:03:39Z "No data found" when creating layer from Excel sheet https://community.esri.com/t5/arcgis-online-questions/quot-no-data-found-quot-when-creating-layer-from/m-p/708334#M35115 <HTML><HEAD></HEAD><BODY><P>I am trying to create a layer by uploading an Excel sheet. I have latitude/longitude coordinates that are formatted as numbers. The locations do not display in the layer I created and when I open the table I see "No data found"</P></BODY></HTML> Wed, 29 Jul 2020 14:24:46 GMT https://community.esri.com/t5/arcgis-online-questions/quot-no-data-found-quot-when-creating-layer-from/m-p/708334#M35115 ErinCheever 2020-07-29T14:24:46Z Re: "No data found" when creating layer from Excel sheet https://community.esri.com/t5/arcgis-online-questions/quot-no-data-found-quot-when-creating-layer-from/m-p/708335#M35116 <HTML><HEAD></HEAD><BODY><P>did you try Excel to table, then make XY event layer? or did you try directly?</P><P>I would also make sure that you format the columns explicitlu if you didn't since it doesn't take much to foul up a spreadsheet</P></BODY></HTML> Wed, 29 Jul 2020 15:45:18 GMT https://community.esri.com/t5/arcgis-online-questions/quot-no-data-found-quot-when-creating-layer-from/m-p/708335#M35116 DanPatterson 2020-07-29T15:45:18Z Re: "No data found" when creating layer from Excel sheet https://community.esri.com/t5/arcgis-online-questions/quot-no-data-found-quot-when-creating-layer-from/m-p/708336#M35117 <HTML><HEAD></HEAD><BODY><P>Hi Dan,</P><P></P><P>This is very helpful advice and I appreciate your taking the time to read my question. I'm going to try the Excel to table method next time. This time I did do the direct import, and what was fouling it up was a stray special character. All resolved now.</P><P></P><P>Thanks,</P><P>Erin</P></BODY></HTML> Wed, 29 Jul 2020 18:03:39 GMT https://community.esri.com/t5/arcgis-online-questions/quot-no-data-found-quot-when-creating-layer-from/m-p/708336#M35117 ErinCheever 2020-07-29T18:03:39Z