Google Map's Timeline records where I (or at least my phone) has been throughout the day every day. Given a particular location, I'd like to see a list of times when I've been there. To get tax credit for days not spent working in a municipality I need to prove that I was out of the city on each day.

  • 2
    did you ever get this figured out? – ashleedawg Aug 12 '18 at 8:55

No, Google Maps doesn't let you do that. It frustrated me as well, so I've written a python script that does just that.

You can find it here: https://github.com/matthieuheitz/google-data-analyses/blob/master/get_visit_times.py

You give it the point of interest (latitude/longitude), a date range, and you get what you want!

A brief overview of what is involved, if you have not used Python before:

  1. Install Python (the basic GUI provided is adequate)
  2. Install numpy (Windows guide)
  3. Edit get_visit_times.py with the basic Python editor with your:

    a. Location of your Google Location History JSON file

    b. Desired date range with dates in the format YYYY,M,D

    c. Point of Interest (Use the "right-click > What's here" feature on Google maps to get the GPS coordinates, and paste into the Python script)

    d. Timestamp grouping (output detail verbosity)

  4. Run the script (Run tab > Run module)

An example of the output (with medium detail (level 2), and the timeframe set to one day) is:

Loading 'C:\<your folder path>\Location History.json' ...
JSON file loaded
Extracting relevant data...
Total of points: 310779
Number of close points: 72
Point 124834  --  Date: 2018-11-24 00:24:03  --  Distance to POI: 1532m
    Group of 60 points
Point 129468  --  Date: 2018-12-01 02:58:17  --  Distance to POI: 1401m
    Group of 12 points
| improve this answer | |

You can upload your Google location history (just follow the instructions) to this website: http://theyhaveyour.info/ then you can zoom in to find the location you are interested in and if you click on it you can see the list of the "timepoints" for that location.

| improve this answer | |
  • I tried this. When I opened the LocationHistory.json file on the site it said "Not quite! LocationHistory.json does not look right. Extract LocationHistory.json from your zip file and drop it here." I downloaded the location history twice and opened both on theyhaveyour.info, trying both the .zip and .json files. – blearyeye Feb 8 '17 at 19:46
  • The problem is probably file size. It's 291MB. – blearyeye Feb 8 '17 at 20:14
  • Worked for me with a 387 MB json file – user1251007 Oct 17 '18 at 19:50
  • It's a good website, but I feel that a lot of it is not working properly (time filters for example) – matthieu Apr 12 '19 at 0:36

https://social.technet.microsoft.com/Forums/en-US/ad13ae2c-d437-4d53-8622-923943938ca4/converting-json-to-csv?forum=winserverpowershell shows a way to do it in PowerShell.

$in = Get-Content -Raw -Path  '<input file>.json'
$injson = convertfrom-json $in
$injson.Locations | export-csv locations.csv -notypeinformation

locations.csv has 4 columns: timestampMS, latitudeE7, longitudeE7, accuracy

| improve this answer | |

Maybe the Elcomsoft Cloud eXplorer can do it.

Its mentioned in this article Google Timeline: How Law Enforcement Can Use Google Data.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.