Step 0: Google Chrome Use SQLite 3 DB as History and Index

匯出 Google 瀏覽器歷史紀錄與下載清單

Export Google Chrome Visit History URLs and Download History

Step 0: Google Chrome Use SQLite 3 DB as History and Index

找出 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

Step #1: Install SQLite Database Tools

建議使用 "Firefox Add-On SQLite Manager"
==> http://addons.mozilla.org/zh-TW/firefox/addon/5817

Step #2: Stop Chrome and Connect to History Database

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"

Step #3: (Ctrl+V)Paste it into Excel

貼到 Excel 然後做資料(D) -> 資料剖析 (E)
Paste them into Excel and do Data analyze by token ","

注意：
如果害怕出錯，一定要先 BACKUP Chrome 的 Database

Google-Chrome-Database-SQLite3.jpg

Export-Chrome-SQLite3-History.jpg

Google-Chrome-History-To-Excel-XLS.jpg

________________

美術插畫設計案子報價系統 v0.1 Beta
爪哇禾雀

匯出 Google 瀏覽器瀏覽紀錄與下載清單歷史 (adsbygoogle = window.adsbygoogle || []).push({});

匯出 Google 瀏覽器歷史紀錄與下載清單

Export Google Chrome Visit History URLs and Download History

Step 0: Google Chrome Use SQLite 3 DB as History and Index

Step #1: Install SQLite Database Tools

Step #2: Stop Chrome and Connect to History Database

Step #3: (Ctrl+V)Paste it into Excel

匯出 Google 瀏覽器瀏覽紀錄與下載清單歷史