Export Chrome history to a spreadsheet

The History page in Chrome has no export option. The history itself is a SQLite database in your profile folder, so you can query it directly, download the synced copy from Google Takeout, or use an extension that reads it through Chrome's history API.

Whichever way you choose, Chrome only keeps about 90 days of history on your computer, so an export is also the only way to hold on to anything older.

Query the History database

The file is called History and sits in the profile folder shown as Profile Path on chrome://version. Chrome locks it while it runs, so close Chrome first or copy the file somewhere else and work on the copy. Then, in the folder that holds the copy, with the sqlite3 command-line tool:

sqlite3 History
.headers on
.mode csv
.output history.csv
SELECT url, title, visit_count, typed_count,
  datetime(last_visit_time / 1000000 - 11644473600, 'unixepoch', 'localtime') AS last_visit
  FROM urls ORDER BY last_visit_time DESC;
.quit

Chrome stores times as microseconds since 1601, which is what the arithmetic in that query undoes. If you prefer a window to a command line, DB Browser for SQLite opens the same file, runs the same query and saves the result as CSV.

Google Takeout

If Chrome sync includes your history, Google Takeout's Chrome section can export it. It arrives as a JSON file rather than a spreadsheet, with times in microseconds, so it still needs converting before Excel or Sheets can use it.

With Export Bookmarks and History (Pro)

History export is a Pro feature of my bookmarks extension. It reads history through Chrome's own API, so nothing needs to be closed or copied.

1. Click the extension's icon and open the History tab. For a big history, the open-in-tab button gives you a full page that stays open when you click elsewhere.
2. Set the dates, and a text or domain filter if you want one. Max pages set to 0 loads everything in the range.
3. Click Load matching history. The count shows how many pages matched, and Show preview lists the first 50.
4. Click CSV, Excel or JSON. The file lands in Downloads as history-2026-10-14_2301.csv or similar.

Ticking One row per visit gives a row for every visit instead of every page, with the visit time and how you got there (a link, a typed address, a reload and so on). XLSX workbooks get a Top domains sheet as well.

Updated 14 October 2026.