[h2]匯出 Google 瀏覽器歷史紀錄與下載清單[/h2]
[h2]Export Google Chrome Visit History URLs and Download History[/h2]
[h1]Step 0: Google Chrome Use SQLite 3 DB as History and Index[/h1]
找出 history 檔案，此檔案格式為 sqlite 3 沒有附檔名
Find Out History Location
e.g. In Windows XP
C:\Documents and Settings\Administrator\Local Settings\Application Data\Google\Chrome\User Data\Default\History
[h1]Step #1: Install SQLite Database Tools[/h1]
建議使用 "Firefox Add-On SQLite Manager"
==>
http://addons.mozilla.org/zh-TW/firefox/addon/5817
[h1]Step #2: Stop Chrome and Connect to History Database [/h1]
Firefox Menu --> 工具 Tool(T) --> SQLite Manager(Q) --> Database(D)
-> Connect Database(O) to the file you found in Step #0
Dowload History ==> Table "downloads"
Visit URL History ==> Table "urls"
選擇你想要 table 和 rows 然後按右鍵 copy row
Select Rows by Mouse and Right Click to Select "
Copy Row(s) as CSV"
[h1]Step #3: (Ctrl+V)Paste it into Excel[/h1]
貼到 Excel 然後做資料(D) -> 資料剖析 (E)
Paste them into Excel and do Data analyze by token "
,"
[hr]
注意：
如果害怕出錯，一定要先
BACKUP Chrome 的 Database [center][/center]
(2009-12-22 12:48)