2 support issues
- All
- Questions
- Suggestions
- Problems
Nitya Géry
Jul 14, 2022
bite
bite
Stephen Digby
Apr 23, 2020
Converting Google Map URL's (contained in csv file from google takeout of "saved") to Geloactions
Google Takeout exports a csv for each saved list including an entry for each location BUT the URL in the CSV is not the same as the URL in google Maps.
The GPS has been removed e.g.
CSV export contains:
https://www.google.com/maps/place/Nakamise+Shopping+Street+(Orange+Street)/data=!4m2!3m1!1s0x60188ec130fbdd3d:0x5135221a7fa19dbc
But google maps URL was:
https://www.google.com/maps/place/Nakamise+Shopping+Street+(Orange+Street)/@35.7118413,139.7942655,17z/data=!3m1!4b1!4m5!3m4!1s0x60188ec130fbdd3d:0x5135221a7fa19dbc!8m2!3d35.7118413!4d139.7964542
The GPS is very useful for exchanging data and for archive (i.e. when the location listed goes out of business, the GPS retains the info about where it was).
The GPS can be easily extracted from the Google Maps URL using a function like:
=MID(C2,SEARCH("@",C2)+1,FIND("/",C2,SEARCH("@",C2))-SEARCH("@",C2)-5)
Request to google: Please include the GPS in google takeout
Request to users: Does any one know how to convert the CSV export URL's to the full URL ?
Is the GPS hidden somewhere in the "data" string at the end of the CSV URL ???
e.g. data=!4m2!3m1!1s0x60188ec130fbdd3d:0x5135221a7fa19dbc
(I have hundreds of list locations)