Skip to content

Instantly share code, notes, and snippets.

@maxrp

maxrp/chromehistory2csv.sh

Created September 1, 2015 20:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save maxrp/e89bd119741fa76761c3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save maxrp/e89bd119741fa76761c3 to your computer and use it in GitHub Desktop.
Download ZIP
Dump chrome history with last visit times
Raw
chromehistory2csv.sh
#!/bin/bash
sqlite3 "${1}" <<!
.headers on
.mode csv
SELECT urls.url, urls.title, urls.visit_count, datetime(urls.last_visit_time / 1000000 + (strftime('%s', '1601-01-01')), 'unixepoch')
FROM urls, visits WHERE urls.id = visits.url;
!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment