Adding CSV file from Google Drive to ArcGIS online Map Viewer

When adding a spreadsheet to AGOL, it tends to work better by doing it from the Content page.

1. Click Add Item and then From a Cloud Drive.
2. Follow the prompts to authorize AGOL to access your Google Drive.
3. On the next menu, you will be able to sort/filter your Drive for files that are compatible with AGOL. Note that you can even import Google Sheets themselves, without needed to export or save as a CSV, if that happens to apply to you. Find your file and continue. Note that I am using a Google Sheet, but the process is the same.

4. AGOL will do a quick analysis of the data, and will make its best guess at the fields and data types are.

   • If your data has coordinate fields, it will usually catch that and default to those for the output point locations.

   • If it doesn't pick your fields automatically, you do have the option of manually specifying which fields serve as the location.

5. Give your content item a name, tags, &c., and complete the process. Your spreadsheet should now be its own content item in your AGOL Organization.

Final note! As with other uploaded content items, you do have the ability to update the data down the road without making a new layer. Simply click Update Data, and you can reconnect to the original file in your Drive to update the layer.

To have the web map load the CSV data directly from Google Drive, you need to

1. Share it with "anyone"
2. Figure out the exact URL to the CSV export/download, which should be something like https://drive.google.com/uc?export=download&id=1kn3kP3gr24OI-4UrUDjNEwQXf-OOhZyG (but with a different id).
3. In the Map Viewer, "Add layer from Web".

See for example https://www.arcgis.com/home/webmap/viewer.html?webmap=438724faf68c4c0e874e14bd20b36196