Export history from chome browser

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.