Thank you ! this has led me to realize I can also use the above method (I think) for using Google Sheets in Arcgis Pro ! will need to test all this but might actually solve a lot of my workflow issues
That's a really good point - the thought didn't occur to me to try it in Pro. It could be really helpful if it worked the way I think it does. I'll also have to try that out. Good luck!
00:09 Creating a collaborative map in ArcGIS Online with real-time updates using Google Sheets 01:02 Updating columns may require re-uploading spreadsheet, but adding rows is seamless. 01:52 Set up proper spreadsheet sharing for real-time edits in ArcGIS Online. 02:48 Uploading a Google spreadsheet link in ArcGIS Online for adding information to the map. 03:40 Ensure data format is CSV for correct map display 04:30 Updating data on maps in real-time using Google Sheets in ArcGIS Online. 05:21 Refreshing the spreadsheet ensures real-time updates on the map 06:09 Reflect changes on the map after refreshing credits: Merlin AI.
This was very helpful thank you! Would we be able to edit the fields/cells in arcgis and have edits show up on the google sheet? If so would you be able to provide a tutorial on how to do this as well? Thank you!
I actually had to test that to confirm - but it doesn't work in the reverse for the most part (edit fields in arcgis and have it reflect in the google sheet). My hunch is that it's probably due to it being cross-platform, but don't quote me on that! If you're into python scripting, you probably could create a model in an ArcGIS Notebook to have it automatically sync changes from a designated CSV - that is a little beyond my coding abilities, but it would probably work (most likely would require credits).
I might be wrong, but I don't think it currently has the ability to do that! There are extra data requirements with polygon data than with point data - one recommendation I would have is reaching out to the ESRI Community Forums (community.esri.com/) to see if anyone has been able to do this previously. Here is a link to a similar (this is not WKT data, but CSV would be a similar process: community.esri.com/t5/arcgis-online-questions/adding-polygons-to-arcgis-online-from-csv-text/td-p/240071 But typically in ArcGIS Online, for polygon data it requires a shapefile/geodatabase/web service/etc - so any table data for the most part will only work with point features. I hope that helps! Definitely make a post on the ESRI Community Forums if you have more questions! It's a really helpful community - good luck with your project!
Thank you for the video. It's informative and explained in very simple language.. Thank you Prof. Sara
I'm glad it was helpful!
thank you for your information. that helps a lot
Thank you ! this has led me to realize I can also use the above method (I think) for using Google Sheets in Arcgis Pro ! will need to test all this but might actually solve a lot of my workflow issues
That's a really good point - the thought didn't occur to me to try it in Pro. It could be really helpful if it worked the way I think it does. I'll also have to try that out. Good luck!
00:09 Creating a collaborative map in ArcGIS Online with real-time updates using Google Sheets
01:02 Updating columns may require re-uploading spreadsheet, but adding rows is seamless.
01:52 Set up proper spreadsheet sharing for real-time edits in ArcGIS Online.
02:48 Uploading a Google spreadsheet link in ArcGIS Online for adding information to the map.
03:40 Ensure data format is CSV for correct map display
04:30 Updating data on maps in real-time using Google Sheets in ArcGIS Online.
05:21 Refreshing the spreadsheet ensures real-time updates on the map
06:09 Reflect changes on the map after refreshing
credits: Merlin AI.
You rock. I struggled for over an hour until I found this video.
I'm glad it was helpful!
Thank you!!! Your video was very important for my job!!!
I'm glad it was helpful!
This was very helpful thank you! Would we be able to edit the fields/cells in arcgis and have edits show up on the google sheet? If so would you be able to provide a tutorial on how to do this as well? Thank you!
I actually had to test that to confirm - but it doesn't work in the reverse for the most part (edit fields in arcgis and have it reflect in the google sheet). My hunch is that it's probably due to it being cross-platform, but don't quote me on that!
If you're into python scripting, you probably could create a model in an ArcGIS Notebook to have it automatically sync changes from a designated CSV - that is a little beyond my coding abilities, but it would probably work (most likely would require credits).
Can you please tell me how to publish polygon layer data (Well-Known Text) with real-time edits from Google Sheets to ArcGIS Online?
I might be wrong, but I don't think it currently has the ability to do that! There are extra data requirements with polygon data than with point data - one recommendation I would have is reaching out to the ESRI Community Forums (community.esri.com/) to see if anyone has been able to do this previously. Here is a link to a similar (this is not WKT data, but CSV would be a similar process: community.esri.com/t5/arcgis-online-questions/adding-polygons-to-arcgis-online-from-csv-text/td-p/240071
But typically in ArcGIS Online, for polygon data it requires a shapefile/geodatabase/web service/etc - so any table data for the most part will only work with point features.
I hope that helps! Definitely make a post on the ESRI Community Forums if you have more questions! It's a really helpful community - good luck with your project!