topic Re: Add a Layer from the Web (.csv) - Google Sheet in ArcGIS Instant Apps Questions https://community.esri.com/t5/arcgis-instant-apps-questions/add-a-layer-from-the-web-csv-google-sheet/m-p/853115#M879 <HTML><HEAD></HEAD><BODY><P>I was given a little help which is very useful for those using the new Google Sheets.&nbsp; After selecting the Publish to the Web, you will need to modify the URL.&nbsp; Replace the last section after the / with <A href="https://docs.google.com/spreadsheets/d/1zuQLY68tktBS3BiE_kAKoNhvjEXzPzxyEOrte6uhU2o/export?format=csv" title="https://docs.google.com/spreadsheets/d/1zuQLY68tktBS3BiE_kAKoNhvjEXzPzxyEOrte6uhU2o/export?format=csv">/export?format=csv</A> </P><P>This will allow you to add the Layer from Web in ArcGIS Online as a csv file and then allows you to select the fields of Latitude and Longitude.</P></BODY></HTML> Thu, 16 Oct 2014 18:37:09 GMT DavidAlger1 2014-10-16T18:37:09Z Add a Layer from the Web (.csv) - Google Sheet https://community.esri.com/t5/arcgis-instant-apps-questions/add-a-layer-from-the-web-csv-google-sheet/m-p/853114#M878 <HTML><HEAD></HEAD><BODY><P>I am trying to add my google sheet to ArcGIS Online.&nbsp; I have the sheet published to the web:</P><P><A href="https://docs.google.com/spreadsheets/d/1zuQLY68tktBS3BiE_kAKoNhvjEXzPzxyEOrte6uhU2o/pubhtml" title="https://docs.google.com/spreadsheets/d/1zuQLY68tktBS3BiE_kAKoNhvjEXzPzxyEOrte6uhU2o/pubhtml">AAH_Groups</A> </P><P>I have some Latitudes and Longitudes, but I am not able to select the fields in ArcGIS to let the program know where to look.&nbsp; Any suggestions?</P></BODY></HTML> Tue, 14 Oct 2014 22:05:40 GMT https://community.esri.com/t5/arcgis-instant-apps-questions/add-a-layer-from-the-web-csv-google-sheet/m-p/853114#M878 DavidAlger1 2014-10-14T22:05:40Z Re: Add a Layer from the Web (.csv) - Google Sheet https://community.esri.com/t5/arcgis-instant-apps-questions/add-a-layer-from-the-web-csv-google-sheet/m-p/853115#M879 <HTML><HEAD></HEAD><BODY><P>I was given a little help which is very useful for those using the new Google Sheets.&nbsp; After selecting the Publish to the Web, you will need to modify the URL.&nbsp; Replace the last section after the / with <A href="https://docs.google.com/spreadsheets/d/1zuQLY68tktBS3BiE_kAKoNhvjEXzPzxyEOrte6uhU2o/export?format=csv" title="https://docs.google.com/spreadsheets/d/1zuQLY68tktBS3BiE_kAKoNhvjEXzPzxyEOrte6uhU2o/export?format=csv">/export?format=csv</A> </P><P>This will allow you to add the Layer from Web in ArcGIS Online as a csv file and then allows you to select the fields of Latitude and Longitude.</P></BODY></HTML> Thu, 16 Oct 2014 18:37:09 GMT https://community.esri.com/t5/arcgis-instant-apps-questions/add-a-layer-from-the-web-csv-google-sheet/m-p/853115#M879 DavidAlger1 2014-10-16T18:37:09Z