Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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;
!
@jelabarre59
Copy link

jelabarre59 commented Jan 31, 2018

Everybody says to run "sqlite" or "sqlite3", but I don't think it's installed by default as part of GChrome. I did find it in the Gimp and Inkscape directories, will have to see if those work here.

@kostask
Copy link

kostask commented Sep 10, 2019

Great! Still works in 2019 ;-) (On MacOS 10.14.6 - Google Chrome Version 76.0.3809.132)

@phanirithvij
Copy link

phanirithvij commented Nov 9, 2019

If anyone is using Brave browser on windows %LocalAppData%\BraveSoftware\Brave-Browser\User Data\Default is the path.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment