<div>
If your smartphone is connected to a goegle account then you can retreive your location history here:<br />
maps.google.com/locationhi<wbr />story<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w46/1210523/download-copy-of-all-your-data.jpg" target="_blank" title="download-copy-of-all-your-data.jpg (59 KB)"><img alt="download-copy-of-all-your-data.jpg" class="file-block lazyload" style="max-width: 580px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w46/1210523/download-copy-of-all-your-data.jpg" /></a>Deselect everything exept your Location History you can download it in History.json and then use that data.<br />
<br />
regards!<br />
<br />
grtz,<br />
<br />
Davy
</div>


download-copy-of-all-your-data.jpg

<div>
Tks. euh... what's History.Json ? how to use it?
</div>


<div>
Hi François,<br />
<br />
History.json is the export of your locations that you visited.<br />
You can use the following Json parser:<br />
<a href="https://www.codeproject.com/Articles/828911/Recursive-VBA-JSON-Parser-for-Excel" rel="ugc">https://www.codeproject.com/Articles/828911/Recursive-VBA-JSON-Parser-for-Excel</a><br />
<br />
<br />
<a href="https://github.com/VBA-tools/VBA-JSON" rel="ugc">https://github.com/VBA-tools/VBA-JSON</a><br />
A tutorial on how to use VBA-JSON:<br />
<a href="https://www.youtube.com/watch?v=CFFLRmHsEAs&feature=youtu.be" rel="ugc">https://www.youtube.com/watch?v=CFFLRmHsEAs&feature=youtu.be</a><br />
<br />
grtz,<br />
<br />
Davy
</div>


<div>
Hi François,<br />
<br />
Another method is to export to KML.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w46/1210683/KML.JPG" target="_blank" title="KML.JPG (18 KB)"><img alt="KML.JPG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w46/800_1210683/KML.JPG" /></a><br />
Then use the following method to import in to excel:<br />
1- Download the kml file <br />
2- rename the file to .xml <br />
3- from excel 2007 go to Data &gt;&nbsp;From Other Sources &gt;&nbsp;From XML Data Source <br />
4- Browse to where you saved the file to impoort into excel. <br />
5- Excel will prompt that it can find the schema and will try to make it by it's own, accept it. <br />
and you should see your data imported successfully <br />
Hope this few steps help you to acheive your task
</div>


KML.JPG

<div>
<div class="content wysiwyg-content">
as all of us know, Google take care of where you are going while your mobile follow you. <br />
I want to grab this information (destination,dates and number of miles) into Excel.<br />
Any idea?
</div>
</div>


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?

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

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

Google

Mobile web development, also known as responsive web design, is an approach to web design aimed at crafting sites to provide an optimal viewing and interaction experience—easy reading and navigation with a minimum of resizing, panning, and scrolling—across a wide range of devices (from desktop computer monitors to mobile phones). A site designed with RWD adapts the layout to the viewing environment by using fluid, proportion-based grids, flexible images, and CSS3 media queries.

Mobile

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

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

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