Counting how many webpages were loaded in 1 day - Google Chrome

Question

How can I, in Google Chrome, count how many webpages were loaded that day? I know it's saved because it lists all of them in history, but it'd take forever to count by hand!

Answer 1

This answer is probably overkill but you did say you were curious.

Chrome running in Windows 7 stores its history in an SQLite database file:

C:\Users\[username]\AppData\Local\Google\Chrome\User Data\Default\History

which you can open with an SQLite manager such as SQLite Expert or SQLiteStudio. Make sure Chrome is closed first.

You can query the database as follows:

select
  date(visit_time/1000000-11644473600, 'unixepoch', 'localtime') as [Date],
  count(url) as [Pages]
from visits
group by [Date]
order by [Date] desc;

and get results such as:

Date         Pages
-----------  ----------
2011-11-15   23
2011-11-14   17
2011-11-13   46
2011-11-12   54
2011-11-11   29
...

Note: Date arithmetic calculations taken from this answer on Stack Overflow.

Answer 2

Super easy method: I guess you could copy and paste your history into a word document, and look at what line your cursor is on.

---

1337 method:

• Install the History 2 extension.

• Copy the data into your favourite "programmer's" editor. (Notepad++, for me.)

• Use the following regexes:

  [^\s]*\s\[
  \]
  

  Replace all matches with absolutely nothing.

• Copy the data into a spreadsheet program (Microsoft Excel). Sum the data.