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


Browsing history is stored in a file called places.sqlite in your profile folder. On Windows it is located in the randomly named .default folder found in this directory:


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.

  • 2
    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
  • if you want the corresponding icons, they're now in favicons.sqlite. this is how I got the corresponding icons of places.sqlite>moz_places>url : look at this line github.com/FuPeiJiang/firefoxSqliteHistoryToHTML/blob/… – Mr. Doge Jun 24 at 14:42

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.

  • 1
    It's Jan 2018, almost 4 years later, and this software still works correctly even on the latest Firefox Quantum. I was able to successfully export my browser history of nearly 1300 items into .txt and .csv format. Good day! :D – Gaurang Tandon Jan 16 '18 at 8:55

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)

  • 5
    "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.

  • 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

You can try using FEBE addon, which provides backups of many itens, including the history as JSON file.

FEBE (Firefox Environment Backup Extension) allows you to quickly and easily backup your Firefox extensions. In fact, it goes beyond just backing up -- It will actually rebuild your extensions individually into installable .xpi files.

  • Thanks for the info. JakeGould improved your answer while I was commenting. Just FYI, the site's standards have changed a bit since this question was posted. The guidelines for software recommendations are described here. Nobody's going to hold you to a higher standard than other answers on this old question. But on a question without pre-existing "low quality" (by current standards) answers, posting barely more than a link is likely to attract downvotes. – fixer1234 Sep 5 '15 at 18:12
  • Thanks for the complementation, i did not have time to read the (meta) subforums. But the other answers do not satisfy this question today, since they have unavaliables addons and other programs that require more work for a trivial thing. – charles Sep 11 '15 at 0:42
  1. Sort history using view->By Site, or view->By Date, or view->By Site and Date
  2. right click on any site or date
  3. click copy
  4. To get just the URLs, paste in a text editor
  5. To get hyperlinks, paste into something that supports hyperlinks (for e.g.) word.

No add-on required.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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