Export history from chome browser

Question

I'd like to be able to export the history from chrome so I can keep track of things like, for example, how many wikipedia articles I've looked at in the last week - all I'm really looking for is a url and a timestamp (I'm on a mac, if it turns out you can do this from the command line)

Where would I start? Would be great if it was the sort of thing that I could run as a cronjob...

Solution 1

Close Chrome, then enter the following in your command line (the exact paths will vary, the following are for Mac OS X):

/usr/bin/sqlite3 ~/Library/Application\ Support/Google/Chrome/Default/History > history.log <<EOF
select * from urls;
EOF

The history will then be in a file called history.log in your home directory (or any directory you switched to in Terminal)

Or for a user-friendly alternative, I recommend the History Trends Unlimited extension mentioned in the answer below.

Solution 2

Also take a look at the History Trends Unlimited extension (full disclosure: I'm the developer). It does some of the analysis for you, but also has the option to export your history so you can do your own.

Solution 3

I just created a Chrome extension that exports your Chrome history in csv and json called Export History, and it works on mac (and linux and windows).

Comments

[iglvzx]

I believe Chrome stores its history in an SQLite3 database. You could look for tools which can view such a file.

[kenorb]

Possible duplicate of Can Chrome browser history be exported to an HTML file?

[Doug Harris]

Or copy the History db file to elsewhere in the filesystem and do the sqlite analysis w/o having to quit Chrome.

[Sibe Jan]

interesting, but when downloading the history, i'll get an alphabetical list of sites... or is something likte this "U1483029737222.5261" a time-stamp?

[Sibe Jan]

deleting the forward slash after 'Application' in the code provided at least a working filepath in the finder, i guess the / is a typo?

[randy]

Yes, that is a timestamp (the numbers after the "U" are milliseconds since the Unix epoch). At the bottom of the Trends page is an "Export Raw Data" button; that will generate a file with a human-readable timestamp.

[Sibe Jan]

Great, @randy! You fixed my problem. Thanks!

[xypha]

please improve your answer by including the information in the comments.

[dengApro]

Awesome, Any Github Url?

[cgenco]

Yup! github.com/christiangenco/chrome-export-history

[tog22]

@SibeJan, nope, in Terminal you have to put \s before space in filenames :)