convery.py

"""
Converts google latitude backup json files to CSV files.

Usage:
python convert.py < latitude.json > latitude.csv
"""

import sys
import json
import csv

field_names = [
    'kind',
    'altitude',
    'longitude',
    'latitude',
    'accuracy',
    'speed', 
    'timestampMs']

i = json.loads(sys.stdin.read())
out = csv.DictWriter(sys.stdout, field_names)
for location in i['data']['items']:
    out.writerow(location)