How to View and Export Firefox Browsing History on Windows
Firefox stores a detailed record of every page you've visited — but its built-in history library doesn't show visit frequencies, has limited export options, and can be slow to search through large histories. Here's how to get full access to your Firefox history data.
This guide covers Firefox's own history tools and a dedicated free viewer that unlocks your complete database — including visit counts, full-date sorting, and export to CSV for use in Excel or other tools.
Quick Answer
Firefox's built-in Library (Ctrl+Shift+H): Quick lookups, limited export (bookmarks only), no visit counts.
For full history + CSV export: Download SterJo Firefox History (free) → Close Firefox → Run tool → Export to CSV, TXT, or HTML.
📖 In This Guide
Method 1: Firefox's Built-In History Library
Firefox includes a History Library that gives you access to your browsing history without any additional tools.
How to open it:
- Press Ctrl + Shift + H, or
- Click the menu (☰) → History → Manage History, or
- Press Ctrl + H for the sidebar view
What it shows:
- Visited pages grouped by day, week, or month
- Page title and URL per entry
- Date and time of each visit
- Search box to find entries by keyword
- Right-click to delete individual entries or time ranges
Limitations:
- No visit count column — Firefox shows individual visits but not how many times you visited a URL in total
- Export is limited to JSON backup (via Import and Backup) — no CSV or spreadsheet-friendly format
- Large histories can be slow to browse in the UI
- No column sorting by URL or other fields
Method 2: SterJo Firefox History — Complete Access and Export
SterJo Firefox History is a free Windows tool that reads Firefox's history database (places.sqlite) directly, giving you complete access to every record — with full sorting, searching, and export to multiple formats.
Step-by-Step:
- Download SterJo Firefox History (free, installer or portable)
- Close Firefox completely before running — Firefox locks its database while open
- Run the tool — it automatically locates and loads your
places.sqlitehistory database - Your complete history appears with URL, page title, visit count, and last visit timestamp
- Use the search bar to filter by URL, domain, or page title
- Click Export → choose CSV, TXT, or HTML
🦊 SterJo Firefox History v1.0
Free • Portable • Windows XP to 11 • Supports Firefox 32+
- Loads your complete Firefox history — no entry limit
- Shows URL, page title, visit count, and last visit timestamp
- Real-time search and filtering across all fields
- Export to TXT, HTML, or CSV
- Works with Firefox 32 and all newer versions
- Portable version — no installation needed
- Fully offline — no internet required
Where Firefox Stores Its History
Firefox stores browsing history in a SQLite database file called places.sqlite. On Windows, the default location is:
C:\Users\[YourName]\AppData\Roaming\Mozilla\Firefox\Profiles\[profile-id].default\places.sqlite
The AppData folder is hidden by default. SterJo Firefox History finds this file automatically — you don't need to navigate there. But knowing its location is useful if you want to make a manual backup of your history before a reinstall.
Manual Backup of Firefox History:
- Close Firefox
- Press Windows + R, type
%APPDATA%\Mozilla\Firefox\Profiles, press Enter - Open your profile folder (it ends in
.defaultor.default-release) - Copy
places.sqliteto a safe location
Firefox Built-In vs SterJo Firefox History
| Feature | Firefox History Library | SterJo Firefox History |
|---|---|---|
| Visit count per URL | ❌ No | ✅ Yes |
| Sort by column | ⚠️ Limited | ✅ Any column |
| Export to CSV | ❌ No (JSON only) | ✅ CSV, TXT, HTML |
| Search speed (large history) | ⚠️ Can be slow | ✅ Fast real-time filter |
| Complete all-time history | ✅ Yes | ✅ Yes |
| No download needed | ✅ Built-in | ❌ Free download required |
| Requires Firefox open | ✅ Yes | ❌ No (Firefox must be closed) |
🌐 Chrome user? See How to View and Export Chrome Browsing History for the Chrome equivalent of this guide.
Common Reasons to Export Firefox History
- Before reinstalling Windows — Keep a complete record even if Firefox Sync doesn't restore everything perfectly
- Find a site you visited months ago — The export lets you search through history in Excel with full filtering power
- Identify your most-visited sites — The visit count column shows which sites you access most frequently
- Migrating to a different browser — Keep a full record of your Firefox browsing history before switching
- Parental or employee monitoring (own devices) — Export and review history for oversight purposes on devices you own
Frequently Asked Questions
1. How long does Firefox keep browsing history?
By default, Firefox keeps browsing history "until Firefox is asked to clear it" — meaning indefinitely until you manually clear it or it exceeds storage limits. The actual retention depends on your disk space and whether you've ever cleared history. Large profiles can contain years of browsing records.
2. Why does the tool need Firefox to be closed?
Firefox locks its places.sqlite database file while it's running to prevent corruption. SterJo Firefox History needs to read this file directly. Close Firefox completely — including the background updater — before running the tool. You can re-open Firefox immediately after the history has loaded.
3. Does this work with Firefox ESR (Extended Support Release)?
Yes. SterJo Firefox History works with Firefox 32 and all newer versions, which includes all current Firefox ESR versions. The places.sqlite format has remained consistent across these versions.
4. Can I use the exported CSV in Excel?
Yes. The CSV export opens directly in Microsoft Excel. Each row contains one history entry with URL, page title, visit count, and last visit timestamp in separate columns — making it easy to sort, filter, and analyze in a spreadsheet.
5. Does using this tool modify or delete my Firefox history?
No. SterJo Firefox History is completely read-only. It reads your history database and displays the data — it never modifies, deletes, or alters your history in any way.
6. Where exactly is my Firefox profile on Windows?
Press Windows + R, type %APPDATA%\Mozilla\Firefox\Profiles and press Enter. You'll find one or more folders — each is a Firefox profile. The history file places.sqlite is inside your active profile folder.
📚 Related Guides
Backup Passwords Before Reinstalling Windows
Complete guide to saving all browser passwords before a reinstall.
Complete Password Recovery Guide
All methods for recovering saved passwords across every application.
✅ Access Your Complete Firefox History
SterJo Firefox History is free, portable, and shows your entire browsing database with visit counts and full export support. No account required.
📋 Browser History Guides
- FirefoxView & Export Firefox History
- ChromeView & Export Chrome History
- FirefoxFirefox Password Recovery
- ChromeRecover Chrome Passwords
- BackupBackup Passwords Before Reinstall
🔗 Related Tools
💡 Quick Tip
Before any Windows reinstall, copy your Firefox places.sqlite file to an external drive — it contains your complete history and bookmarks in one file.
📊 Did You Know?
Firefox's history file places.sqlite also stores your bookmarks — both are kept in the same database. Backing up this single file protects both your history and your bookmarks.