Chrome stores history as an SQLITE3 database.
First, find it.
Open up the terminal, and navigate to the directory that contains the History file.
cd ~/Library/Application\ Support/Google/Chrome/Default/
Open the database with SQLITE3:
Enable Sqlite3 output mode as CSV by typing into sqlite shell:
sqlite> .headers on sqlite> .mode csv sqlite> .output my-chrome-output.csv
Now, execute the SQL statement (copy and paste). Note that by default, the time stamp is not “human readable” so we’ll insert some logic to convert times into our local time zone / months, years, and that good stuff.
SELECT datetime(last_visit_time/1000000-11644473600,'unixepoch','localtime'), url FROM urls ORDER BY last_visit_time DESC
Done! Check your directory for my-chrome-output.csv.
Why this isn’t documented anywhere except in small pieces? Don’t know.