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
  • 5 views
  • Last reply by cor-el

more options

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)

more options

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 
more options

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.

more options

You're welcome.