# Get spatial data from Google server **URL:** \ **Category:** Support\ **Created:** [August 5, 2020, 9:16am UTC](https://forum.getodk.org/t/get-spatial-data-from-google-server/28922 "2020-08-05T09:16:55Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![mrossouw](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/97f17d/32.png) [@mrossouw](https://forum.getodk.org/u/mrossouw)\ **Post date:** [August 5, 2020, 9:16am UTC](https://forum.getodk.org/t/get-spatial-data-from-google-server/28922/1 "2020-08-05T09:16:55Z")
Good day Everyone, I would like to know if there is an easy away to get the spatial data from the Google server in a GIS format? At the moment the co-ordinates for path or polygon are stored in a single cell, making it impossible to just import it to a GIS program without separating it into columns. Regards Malherbe Rossouw ---
**Author:** ![Joaquin\_Linares](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/joaquin_linares/32/12720_2.png) [@Joaquin\_Linares](https://forum.getodk.org/u/Joaquin_Linares)\ **Post date:** [August 5, 2020, 5:19pm UTC](https://forum.getodk.org/t/get-spatial-data-from-google-server/28922/2 "2020-08-05T17:19:43Z")
Buen dia. si lo que quieres es usar un programa de mapas como qgis o arcgis puedes a tu hoja de excel darle un formato para trabajarlo alli. [https://desktop.arcgis.com/es/arcmap/10.3/manage-data/tables/formatting-a-table-in-microsoft-excel-for-use-in-arcgis.htm](https://desktop.arcgis.com/es/arcmap/10.3/manage-data/tables/formatting-a-table-in-microsoft-excel-for-use-in-arcgis.htm) lee esto para mas referencia. pero para mas info sobre las preguntas y como creas los poligonos mira: [https://xlsform.org/en/#gps](https://xlsform.org/en/#gps) ---
**Author:** ![mathieubossaert](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/mathieubossaert/32/6131_2.png) [@mathieubossaert](https://forum.getodk.org/u/mathieubossaert)\ **Post date:** [August 5, 2020, 5:34pm UTC](https://forum.getodk.org/t/get-spatial-data-from-google-server/28922/3 "2020-08-05T17:34:58Z")
Hi @mrossouw, when you get a chance, please take some timle to [Introduce yourself here!](https://forum.getodk.org/t/introduce-yourself-here/6671) As @Joaquin_Linares said (as far as I understand 😉 ) you can easily map point from to coordinates columns with a GIS software, but for linestring or polygon it it not so easy. You should take a look at those case studies about generating kml, geojson or wkt within your form : - [ODK geoshape/geotrace/geopoint to WKT](https://forum.getodk.org/t/odk-geoshape-geotrace-geopoint-to-wkt/21062/1) - [ODK geoshape/geotrace/geopoint to KML](https://forum.getodk.org/t/odk-geoshape-geotrace-geopoint-to-kml/18985) - [ODK geoshape/geotrace/geopoint to GeoJSON](https://forum.getodk.org/t/odk-geoshape-geotrace-geopoint-to-geojson/21046) ---
**Author:** ![Joaquin\_Linares](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/joaquin_linares/32/12720_2.png) [@Joaquin\_Linares](https://forum.getodk.org/u/Joaquin_Linares)\ **Post date:** [August 5, 2020, 5:38pm UTC](https://forum.getodk.org/t/get-spatial-data-from-google-server/28922/4 "2020-08-05T17:38:03Z")
aplica si uso odk en hojas de googlesheets? ---
**Author:** ![mathieubossaert](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/mathieubossaert/32/6131_2.png) [@mathieubossaert](https://forum.getodk.org/u/mathieubossaert)\ **Post date:** [August 5, 2020, 5:41pm UTC](https://forum.getodk.org/t/get-spatial-data-from-google-server/28922/5 "2020-08-05T17:41:05Z")
Yes it only use xforms calculations. But you can try the examples forms given in the case studies. ---
**Author:** ![Joaquin\_Linares](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/joaquin_linares/32/12720_2.png) [@Joaquin\_Linares](https://forum.getodk.org/u/Joaquin_Linares)\ **Post date:** [August 5, 2020, 5:41pm UTC](https://forum.getodk.org/t/get-spatial-data-from-google-server/28922/6 "2020-08-05T17:41:50Z")
Esta increíble, muchas gracias. ---
**Author:** ![mrossouw](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/97f17d/32.png) [@mrossouw](https://forum.getodk.org/u/mrossouw)\ **Post date:** [September 3, 2020, 7:43am UTC](https://forum.getodk.org/t/get-spatial-data-from-google-server/28922/7 "2020-09-03T07:43:19Z")
Hi @mathieubossaert. Thanks for the information. I will have a look at them. ---
**Author:** ![mrossouw](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/m/97f17d/32.png) [@mrossouw](https://forum.getodk.org/u/mrossouw)\ **Post date:** [December 9, 2020, 12:55pm UTC](https://forum.getodk.org/t/get-spatial-data-from-google-server/28922/8 "2020-12-09T12:55:37Z")
Just an update for other people that have the same issue. In QGIS there is an plugin with the name ODKtrace2WKT. It will extract all the shape co-ordinates from the csv file and plot it in QGIS. Hope it helps Malherbe