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

This comment has been minimized.

Copy link

@jelabarre59 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

This comment has been minimized.

Copy link

@kostask kostask commented Sep 10, 2019

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

@phanirithvij

This comment has been minimized.

Copy link

@phanirithvij 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
You can’t perform that action at this time.