匯出 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
#history

#google by Type
#瀏覽器 by Type
#chrome by Type
#history by Type

(28,377 views)

[更多討論] Google 討論區

"匯出 Google 瀏覽器瀏覽紀錄與下載清單歷史" 傳統頁面(電腦版)

首頁繪圖設計工作閒聊比賽活動美術討論標籤圖片

傳統桌面版 [ 登入/註冊 ]