How to read the Google Chrome browsing history file

Obtain a copy of the History file. It is located in 

C:\Users\<username>\AppData\Local\Google\Chrome\User Data\Default (Windows)

/Users/<username>/Library/Application Support/Google/Chrome/Default (Mac)


Download the sqlite3 from https://www.sqlite.org/index.html

Copy the sqlite3 app into the same folder as the History file

Open a command prompt or terminal window

Change directory to the folder containing the History file and sqlite3

Run sqlite3 

At the sqlite> prompt, type 

.open history

.output history.txt

  SELECT last_visit_time, datetime(last_visit_time / 1000000 – 11644473600, ‘unixepoch’, ‘localtime’),url,title FROM urls ORDER BY last_visit_time DESC;

.output

.exit

Open the history.txt file using Excel or text editor


2 thoughts on “How to read the Google Chrome browsing history file

Leave a Reply

Your email address will not be published. Required fields are marked *