Skip to content

Instantly share code, notes, and snippets.

@vioan
Forked from TravelingTechGuy/get_history.sh
Created February 19, 2021 21:58
Show Gist options
  • Save vioan/c6f01470650c580414893d7996b729c6 to your computer and use it in GitHub Desktop.
Save vioan/c6f01470650c580414893d7996b729c6 to your computer and use it in GitHub Desktop.
Get your Chrome history as a CSV file
#!/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