Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I lost a load of open tabs in Firefox that I want to recover. The details are in the browsing history but it is not the most friendly area of Firefox to wade through. The Export option there actually exports bookmarks. I want to export my browsing history as a text file so I can search, dedup, etc in a text editor. I can not work out a way of exporting the browsing history so any suggestions much appreciated.

Firefox 3.5.5 Windows XP Pro

share|improve this question
As for me, this addon addons.mozilla.org/ru/firefox/addon/sqlite-manager works. But this SQLite Browser, recommended by John T was unable to open my 20 Mb file –  Anton Kovalenko May 13 '11 at 9:02

4 Answers 4

up vote 7 down vote accepted

Browsing history is stored in a file called places.sqlite in your profile folder. On Windows XP it is located under:

C:\Documents and Settings\USER\Application Data\Mozilla\Firefox\Profiles\##.default

replace USER with your Windows XP user name and ### is a set of random characters (you will see it in explorer if you navigate there). This file format is not easily edited in a text file, but you can use SQLite Database Browser (free and open source) to view the file.

share|improve this answer
That's a start at least (an impressive one, at that.) I had to play around to see for myself. It looks like select * from moz_places order by id desc; would give you an in-app list of your recorded browsing history sorted from newest to oldest. But, if you want to extract the data for manipulation you'll have to do File | Export | Table as CSV File and then open it in OpenOffice Calc or Excel and twiddle from there. –  JMD Dec 11 '09 at 16:34
+1 JMD and thanks for extra help. I was not 100% sure on what do do with the DB!! –  ianfuture Jan 7 '10 at 11:34

For modern era (it's March 2014 as I write this) Firefox users on Windows machines, you can give Nirsoft's Firefox History Viewer a try: http://www.nirsoft.net/utils/mozilla_history_view.html

Not sure if it can read the (very old and outdated) history.dat format, but it can filter, slice, dice, chop, puree, scramble, and otherwise do all kinds of fancy things (but it cannot make your coffee and serve it to you, sorry!) with the history data in the "places.sqlite" format, and then export it to several common formats ranging from text to html to csv to xml to whatever.

share|improve this answer

Use the History Export add-on which can export to .html, .txt and .json (this also work on Mac OS X, though doesn't appear to support formats besides .txt)

share|improve this answer
"History Export" addon is no longer available. –  netjeff Oct 10 '14 at 15:47

An alternative to what's listed here is the add-on "Enhanced History Manager", which essentially allows you to do what you're talking about.

share|improve this answer
Mind adding a link to the extension you mention? –  slhck Jun 6 '11 at 20:10
You won't find this via a Firefox add-on search for its name –  tog22 Jun 29 '12 at 11:21
My concern is this software is massively out of date (2005). –  wonea Nov 20 '12 at 9:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.