{"id":178101,"date":"2012-02-21T23:30:16","date_gmt":"2012-02-21T23:30:16","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=178101"},"modified":"2024-04-02T15:47:20","modified_gmt":"2024-04-02T22:47:20","slug":"using-google-docs-in-your-arcgis-online-maps","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/using-google-docs-in-your-arcgis-online-maps","title":{"rendered":"Using Google Docs in your ArcGIS Online maps"},"author":7641,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23851,37511],"tags":[29641,30411,26911],"industry":[],"product":[36551],"class_list":["post-178101","blog","type-blog","status-publish","format-standard","hentry","category-data-management","category-sharing-collaboration","tag-csv","tag-google","tag-spreadsheets","product-arcgis-online"],"acf":{"short_description":"In a previous post, we covered how you can use a spreadsheet (CSV file) from a Web location to add a layer to your ArcGIS Online map.","flexible_content":[{"acf_fc_layout":"content","content":"
\n

\"\"<\/p>\n

This blog article has been deprecated and is no longer updated.<\/p>\n

It has been replaced by: Add Google Drive files to your ArcGIS Online maps and content<\/a>.<\/p>\n

\n"},{"acf_fc_layout":"content","content":"

In a previous post, we covered how you can use a spreadsheet (CSV file) from a Web location to\u00a0add a layer\u00a0to your ArcGIS Online map. You can do the same using Google Docs by following these simple steps.<\/p>\n

In this example we have a Google Docs spreadsheet of crime locations containing latitude and longitude values. Under\u00a0File<\/em>\u00a0choose\u00a0Publish to the Web<\/em>.<\/p>\n

\"Image<\/span><\/p>\n

In the next dialog change the link setting from the default option of Web page:<\/p>\n

\"Image<\/p>\n

To CSV by opening the drop-down list, as shown below:
\n\"Choose<\/p>\n

Then copy the URL so you can add it to your map:<\/p>\n

\"Copy<\/p>\n

Adding from Google Docs using the ArcGIS.com Map Viewer<\/strong><\/p>\n

Using the map viewer\u00a0click\u00a0Add<\/em>, then choose\u00a0Add Layer from Web<\/em>:<\/p>\n

\"Add
\nChoose\u00a0CSV and paste the Google Docs URL, as shown below, then click\u00a0Add Layer<\/em>:<\/p>\n

\"Add<\/p>\n

Once added, you can rename, configure the pop-up, and change symbols, just like any other layer. Below we\u2019ve chosen to symbolize the crimes from our Google Docs spreadsheet based on the time of day:<\/p>\n

\"Symbolize<\/p>\n

Add from Google Docs using ArcGIS Explorer Online<\/strong><\/p>\n

Using Explorer Online click\u00a0Add Content<\/em>\u00a0and choose\u00a0Import<\/em>, then\u00a0CSV<\/em>:<\/p>\n

\"ArcGIS<\/p>\n

Choose\u00a0Enter URL<\/em>, as shown below:<\/p>\n

\"Enter<\/p>\n

Then paste the Google Docs URL into the input. Once\u00a0you\u2019ve added your Google Docs spreadsheet you can rename it, change symbols, configure pop-ups, and use the layer in Explorer Online dashboards and presentations.<\/p>\n

Like other URL-based CSV sources, when the map is opened or refreshed any changes to the layer\u2019s source will be\u00a0displayed in the map.<\/p>\n

For more information see:<\/p>\n