Skip to content

Instantly share code, notes, and snippets.

@hollychen503

hollychen503/get_history.sh

Forked from TravelingTechGuy/get_history.sh
Created August 18, 2016 14:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hollychen503/6898763d51a558e7c35ca68851b358c4 to your computer and use it in GitHub Desktop.
Save hollychen503/6898763d51a558e7c35ca68851b358c4 to your computer and use it in GitHub Desktop.
Download ZIP
Get your Chrome history as a CSV file
Raw
get_history.sh
#!/bin/bash
# Locate the history file in your profile, and copy it to the same folder as this script.
# On Mac: ~/Library/Application\ Support/Google/Chrome/Default/History
# On Windows: C:\Users\YOUR USER NAME\AppData\Local\Google\Chrome\User Data\Default\History
sqlite3 History <<!
.headers on
.mode csv
.output out.csv
select datetime(last_visit_time/1000000-11644473600,'unixepoch') as 'date',url from urls order by last_visit_time desc;
!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment