ConvertGoogleHistory.py

import json
import csv
import sys
from datetime import datetime
import os


def make_reader(in_json):
    # Open location history data
    json_data = json.loads(open(in_json).read())

    for segment in json_data['semanticSegments']:
        if 'visit' in segment:
            latitude, longitude = segment['visit']['topCandidate']['placeLocation']['latLng'].replace('°', '').split(', ')
            time = datetime.strptime(segment['startTime'], '%Y-%m-%dT%H:%M:%S.%f%z')
            yield [time.isoformat(), float(longitude), float(latitude)]

        if 'activity' in segment:
            for type in ['start', 'end']:
                latitude, longitude = segment['activity'][type]['latLng'].replace('°', '').split(', ')
                time = datetime.strptime(segment[f'{type}Time'], '%Y-%m-%dT%H:%M:%S.%f%z')
                yield [time.isoformat(), float(longitude), float(latitude)]

        if 'position' in segment:
            latitude, longitude = segment['LatLng'].replace('°', '').split(', ')
            time = datetime.strptime(segment['timestamp'], '%Y-%m-%dT%H:%M:%S.%f%z')
            yield [time.isoformat(), float(longitude), float(latitude)]

        if 'timelinePath' in segment:
            for point in segment['timelinePath'][:1]:
                latitude, longitude = point['point'].replace('°', '').split(', ')
                time = datetime.strptime(point['time'], '%Y-%m-%dT%H:%M:%S.%f%z')
                yield [time.isoformat(), float(longitude), float(latitude)]


def getFullPath(inPath):
    if not os.path.isabs(inPath):
        script_path = os.path.abspath(__file__)
        path, file = os.path.split(script_path)
        inPath = os.path.join(path, inPath)
    return inPath


# Read i/o file names
input_file = 'location-history.json'
output_file = 'location-history.csv'

# Read data from JSON file
reader = make_reader(input_file)
# Add the Headers
features = [['Time', 'Longitude', 'Latitude']]
for row in reader:
    features.append(row)

# Write data to CSV file
writer = csv.writer(open(output_file, 'w', newline=''))
writer.writerows(features)

Worked as charm, thank you as lot.

@sitz I get this error

KeyError: 'semanticSegments'

my json file from google takeout from yesterday looks like this:
` "deviceId": "XXXXXXX",

"rawSignal": {
  "signal": {
    "position": {
      "point": {
        "latE7": 4XXX9000302,
        "lngE7": 1XXX4936499
      },
      "accuracyMm": 172000,
      "altitudeMeters": 93.0,
      "source": "GPS",
      "timestamp": "2024-02-29T14:11:32.692Z"
    }
  },
  "additionalTimestamp": "2024-02-29T14:28:05.610Z",
  "metadata": {
    "platform": "ANDROID"`