Google-chrome – Is is any way to read all history from Google chrome history and save it in an excel sheet


I search for a way that allow me read all history data from Google Chrome history and save it in any format for example excel sheet .. but i want a way in which i make it by copy data from page and paste in a sheet and formating it .. i search for automatic way or a tool ?

Best Answer

Google saves the history in an sqlite3 database located in C:\Users\\AppData\Local\Google\Chrome\User Data\Default (on Windows 7).

Try installing an ODBC driver for sqlite3, you will then be able to use Data->From Other sources (in Get External Data) -> From Microsoft Query to get hold of the file and the data it contains. (I haven't actually done this, I just opened the file in the sqlite manager addin in Firefox to have a quick peek.)