Quick script to convert the Google Location History "Records.json" into a format compatible with kepler.gl

kelpergl-location-history.py

import csv
import json

# Open the JSON file and read its contents
print('Loading data...')
with open('Records.json') as json_file:
    data = json.load(json_file)

# Create a CSV file and write the headers
print('Processing data...')
with open('Records.csv', 'w', newline='') as csv_file:
    writer = csv.writer(csv_file)
    writer.writerow(['timestamp', 'latitude', 'longitude'])

    # Loop through each location in the JSON data and write it to the CSV file
    for location in data['locations']:
        timestamp = location['timestamp']
        try:
            latitude = location['latitudeE7'] / 10**7
            longitude = location['longitudeE7'] / 10**7
        except KeyError:
            continue
        writer.writerow([timestamp, latitude, longitude])

print('CSV file created')
input('Press enter to exit')