Skip to content

Instantly share code, notes, and snippets.

@nealmcb
Forked from TravelingTechGuy/get_history.sh
Created October 12, 2020 12:17
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 nealmcb/32928f9e3d2c375ddb4ddbbcb16c9c5d to your computer and use it in GitHub Desktop.
Save nealmcb/32928f9e3d2c375ddb4ddbbcb16c9c5d 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