Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

i want to save the autocomplete history of websites visited

  • 4 replies
  • 2 have this problem
  • 96 views
  • Last reply by cor-el

more options

It seems that Firefox has stored some of the websites I've visited according to the spelling of each website. I would like to know if it's possible to save the collection of websites that comprise this "autocomplete function."

All Replies (4)

more options

Open history in the sidebar by hitting CTRL+H, then right click the bookmark and choose "Bookmark this page".

more options

Does pressing Ctrl+H and right clicking the bookmark save all of the "autocomplete function" of all the collections of all the websites and their URLs, I presume, that have been amassed ( without personal deletion by the user, of course)?

In my version of Firefox (3.6.17), right clicking a bookmark and selecting "Bookmark This Page," brings up the New Bookmark window, which I believe is only for one web page.

more options

When I mention "autocomplete function," I'm referring to the websites that appear in a drop-down box when one starts to type in the name of a webpage (e.g., delta.com) in the box just under the Menu Bar in Firefox 3.6.17.

more options

You can use the SQLite Manager extension to create a list of the history and export that list as a CSV file.

See:


  1. Open Profile Directory -> places.sqlite -> Go
  2. Hit the Execute SQL tab
  3. Use a Select like this:
SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch'), moz_places.url, moz_places.title
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id

If you only want to see typed entries then use this instead:

WHERE moz_places.id = moz_historyvisits.place_id AND typed LIKE '1'
  • Click the Action button to Save the results to a CSV file

You can also select some records and use the right-click context menu to copy the selected records as CSV to the clipboard.

You can also create a Temporary view:

  1. View > Create View : [X ]Temporary Name: Enter a Name for the view
  2. Use the same Select as above
  3. View > Export View : Database > Temp

Modified by cor-el