Skip to content

Instantly share code, notes, and snippets.

@ognalysis
Forked from TravelingTechGuy/get_history.sh
Created May 14, 2021 17:21
Show Gist options
  • Save ognalysis/dd7edf315578538f49d84dfb811353db to your computer and use it in GitHub Desktop.
Save ognalysis/dd7edf315578538f49d84dfb811353db 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