Skip to main content

No project description provided

Project description


Extracts, transforms, and loads your data from Google Takeout into an SQLite DB.


getl is available on PyPI

Install via pip

$ pip install getl

Or via easy_install

$ easy_install getl

Or directly from getl’s git repo <>

$ git clone git://
$ cd getl
$ python install

Basic usage

Download your data with Google Takeout using the format JSON and unzip the file.

Currently only Location History works but I will implement more extractors shortly.

>>> from getl import Getl
>>> getl = Getl('path/to/unzipped/google/takeout/data')
>>> getl.load_location_history()
>>> getl.sql('SELECT COUNT(*) FROM locations')[0][0]
>>> getl.sql('SELECT timestamp FROM locations LIMIT 5;')
[('2018-07-27 14:04:24',), ('2018-07-23 11:34:12',), ('2018-07-17 09:47:19',), ('2018-07-13 23:56:44',), ('2018-07-12 09:54:13',)]
>>>'foo.db') # Saves SQLite db to disk

Running Test

$ python tests/

Python compatibility

Requires Python 3.0 or greater

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

getl-0.3.tar.gz (3.6 kB view hashes)

Uploaded Source

Built Distribution

getl-0.3-py3.7.egg (9.1 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page