Exports Routes (locations & miles & dates) from Google to Excel

If your smartphone is connected to a goegle account then you can retreive your location history here:
maps.google.com/locationhistory
Deselect everything exept your Location History you can download it in History.json and then use that data.

regards!

grtz,

Davy

Tks. euh... what's History.Json ? how to use it?

Hi François,

History.json is the export of your locations that you visited.
You can use the following Json parser:
https://www.codeproject.com/Articles/828911/Recursive-VBA-JSON-Parser-for-Excel


https://github.com/VBA-tools/VBA-JSON
A tutorial on how to use VBA-JSON:
https://www.youtube.com/watch?v=CFFLRmHsEAs&feature=youtu.be

grtz,

Davy

Hi François,

Another method is to export to KML.


Then use the following method to import in to excel:
1- Download the kml file
2- rename the file to .xml
3- from excel 2007 go to Data > From Other Sources > From XML Data Source
4- Browse to where you saved the file to impoort into excel.
5- Excel will prompt that it can find the schema and will try to make it by it's own, accept it.
and you should see your data imported successfully
Hope this few steps help you to acheive your task