Wednesday, April 20, 2016

How to get history from Google Chrome browser?

One day, I want to know myself behavior on use pc’s browser. But Google Chrome browser can be only watching that displayed history summary. So best result is text based historical summary (CSV format). How to get historical summary from Google Chrome browser?

Research Result:
  Historical recorded file
    \Users\<USER>\AppData\Local\Google\Chrome\User Data\Default\History
  File format
    SQLite
 Windows Version
    7 64bit, 8 64bit, 10 64bit


I found browser’s historical file and file format. To watch historical file can use SQLite browser then file format is SQLite. DB Browser for SQLite can open the historical DB.

DB structure:
Historical DB has nine tables.
  1) downloads
    Your downloaded files history on your PC.
  2) downloads_url_chains
    Downloading url history.
  3) keyword_search_terms
    Your search history keywords.
  4) meta
    Meta data is browser self?
  5) segment_usage
    ?
  6) segments
    ?
  7) urls
    Your access url history. Including page title, count and time.
  8) visit_source
    Visiting relation?
  9) visits
    Visiting history?

Browsing history convert to a text file the purpose of this. “urls”(7) table display by DB browser for SQLite then all record select and copy/paste to your favorite text editor or Excel …

No comments:

Post a Comment