Fr. Vandecan
asked on
Exports Routes (locations & miles & dates) from Google to Excel
as all of us know, Google take care of where you are going while your mobile follow you.
I want to grab this information (destination,dates and number of miles) into Excel.
Any idea?
I want to grab this information (destination,dates and number of miles) into Excel.
Any idea?
ASKER
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
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
maps.google.com/locationhi
Deselect everything exept your Location History you can download it in History.json and then use that data.
regards!
grtz,
Davy