Skip to content

Instantly share code, notes, and snippets.

@devarda

devarda/get_history.sh

Forked from TravelingTechGuy/get_history.sh
Created December 22, 2019 03:33
Show Gist options
  • Save devarda/05afda9d7780daa63d6087263e31c9b0 to your computer and use it in GitHub Desktop.
Save devarda/05afda9d7780daa63d6087263e31c9b0 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