Chrome history export for analytics

chrome-history-exporter.py

import sqlite3
import pandas as pd

USERNAME = "your_username"



# Path to the Chrome history file
history_db = fr"C:\Users\{USERNAME}\AppData\Local\Google\Chrome\User Data\Default\History"

# Connect to SQLite database
conn = sqlite3.connect(history_db)

# Query the URLs table
query = "SELECT url, title, visit_count, last_visit_time FROM urls"

df = pd.read_sql_query(query, conn)
# Save to CSV
df.to_csv("chrome_history.csv", index=False)
conn.close()

print("Chrome history exported to 'chrome_history.csv'.")