Converts google timeline day data files (KML) into a single CSV file
JavaScript
Switch branches/tags
Nothing to show
Clone or download
Permalink
Failed to load latest commit information.
test screenshot Dec 1, 2015
.gitignore initial commit Nov 28, 2015
README.md Update README.md Feb 3, 2016
index.js support for JSON format Feb 8, 2016
package.json fixed timezone issue Dec 1, 2015

README.md

google-timeline-to-csv

Converts Google Timeline data to CSV. This allows temporal analysis of the data, with CartoDB's Torque for instance. It can handle multiple individual day files and merge them as one CSV file, or one single Takeout KML file. Note: this might be possible using ogr2ogr, but not out of the box AFAIK (using some KML driver). A simple customized node script seemed a faster and saner way.

Check out the demo on CartoDB.

Usage

  • Go on the Google Timeline page

  • Download the kml files for each day you need (select a day, click on the cog icon on the bottom right, choose 'Export this day to KML'), or download your whole history as a single kml file.

  • clone this repo and install dependencies :

npm i
  • Run the script :
./index.js [directory containing individual day files] > target_file.csv
./index.js [single kml file] > target_file.csv
  • Import to CartoDB

  • Have fun :) (remember that there is a limit of 500k rows per table by default)