Windows 10 reached EOS (end of support) on October 14, 2025. If you are on Windows 10, see this article.

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

How can I organize History?

  • 3 replies
  • 16 have this problem
  • 54 views
  • Last reply by cor-el
  • Solved

It seems like I asked this question before, but I can't find it, so forgive me if this is a repeat.

A few weeks ago, I remember visiting a website, but I can't remember it's name, and I did not bookmark it.

Since I do save my History, isn't there some way I can export it, and then delete all the junk third-party ad sites, and consolidate them all by website, so instead of 15,000 entries, I have a few hundred?

Also, is there a way to find out the last time I visited the site?

Is there a way to export history into a structured file?

I tried to do a copy and paste, and every export option seemed to have a problem. When I pasted it into Notepad, only the URL showed up, but not the name of the page, which I need.

When I pasted it into Excel, it was all one cell, with no End-of-Line markers.

When I pasted it into Word, it was all hyperlink text, showing only the name of the website, but not the URL.

I need both, and preferably the last time it was accessed. Is such a thing available?

Thanks in advance.

It seems like I asked this question before, but I can't find it, so forgive me if this is a repeat. A few weeks ago, I remember visiting a website, but I can't remember it's name, and I did not bookmark it. Since I do save my History, isn't there some way I can export it, and then delete all the junk third-party ad sites, and consolidate them all by website, so instead of 15,000 entries, I have a few hundred? Also, is there a way to find out the last time I visited the site? Is there a way to export history into a structured file? I tried to do a copy and paste, and every export option seemed to have a problem. When I pasted it into Notepad, only the URL showed up, but not the name of the page, which I need. When I pasted it into Excel, it was all one cell, with no End-of-Line markers. When I pasted it into Word, it was all hyperlink text, showing only the name of the website, but not the URL. I need both, and preferably the last time it was accessed. Is such a thing available? Thanks in advance.

Modified by MargaretBartley

Chosen solution

See:

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 
Read this answer in context 👍 3

All Replies (3)

Chosen Solution

See:

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 

Thank you. I had a rough start, because I didn't realize I needed to download SQLLite first, but eventually I got it working. Plus, I found out about SQLLite!

Thanks.