5

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...

7

Close Chrome, then from 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 copy the History db file to elsewhere in the filesystem and do the sqlite analysis w/o having to quit Chrome. – Doug Harris Jun 29 '12 at 13:44
  • deleting the forward slash after 'Application' in the code provided at least a working filepath in the finder, i guess the / is a typo? – Sibe Jan Mar 8 '17 at 20:06
1

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).

1

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.

  • 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 Mar 8 '17 at 15:54
  • 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. – randy Mar 9 '17 at 16:55
  • Great, @randy! You fixed my problem. Thanks! – Sibe Jan Mar 12 '17 at 19:57
0

I have the same question, and came half-way: in the Finder, type shift-command-g (go to folder...) and fill in ~/Library/Application Support/Google/Chrome/Default/History. Now you've found the history sglite. Copy this file elsewhere or quit Chrome and open this file in e.g. DB Browser for SQLite But how to interpret the data, and find/make a simple list of URL's + timestamps... no idea!

update: found it. see comments above.

  • please improve your answer by including the information in the comments. – xypha Mar 22 '17 at 7:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.