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

Bookmarks - A better Export / Show folder quantity in Status Bar

more options

I did this macro to get my Unsorted Bookmarks out of Firefox (the steps are listed, not the actual macro).

I keep my Bookmarks in a spreadsheet, where I currently have 12 levels of sorting capability.

  • * * * * * * * * * * * * * * * * * * * * * * *

As you can see in the Excel screenshot (the top half), sometimes the Titles end up in Column B, instead of Column E.

I think I've seen them in Column A and Column C before, but not recently. I'm watching for that.

In the other two sceenshots, I look at the details between two Bookmarks - one where the Title is in Column E, and the other where the Title is in Column B. They both have a "Description," so that doesn't seem to be what's causing the disparity.

Do you know if there's a way that they could always end up in Col E?

  • * * * * * * * * * * * * * * * * * * * * * * *

Other idea: Do you think it could say at the bottom in a Status bar, how many Bookmarks are in a folder (like File Explorer)? That would be useful for when I do a visual check to see that I've got the same number of Bookmarks in my Import, as compared to the Library.

I did this macro to get my Unsorted Bookmarks out of Firefox (the steps are listed, not the actual macro). I keep my Bookmarks in a spreadsheet, where I currently have 12 levels of sorting capability. * * * * * * * * * * * * * * * * * * * * * * * * As you can see in the Excel screenshot (the top half), sometimes the Titles end up in Column B, instead of Column E. I think I've seen them in Column A and Column C before, but not recently. I'm watching for that. In the other two sceenshots, I look at the details between two Bookmarks - one where the Title is in Column E, and the other where the Title is in Column B. They both have a "Description," so that doesn't seem to be what's causing the disparity. Do you know if there's a way that they could always end up in Col E? * * * * * * * * * * * * * * * * * * * * * * * * Other idea: Do you think it could say at the bottom in a Status bar, how many Bookmarks are in a folder (like File Explorer)? That would be useful for when I do a visual check to see that I've got the same number of Bookmarks in my Import, as compared to the Library.

Chosen solution

Sorry, I didn't zoom that first image and see that it was an bookmarks.html file mentioned in the lower section of that Excel window. A small 19" widescreen monitor and 64 yo eyes couldn't read that spreadsheet too well.

Read this answer in context 👍 0

All Replies (9)

more options

Wouldn't that be something to discuss in an Excel support forum?

Really doesn't directly involve Firefox support.

more options

I don't think so, because Excel is just opening, or importing, what Firefox has stored.

What would need to be looked at is how Firefox saves the Bookmark info, and if where it saves the web page Title could be standardized.

more options

The web page URLs are always in the same column. How does that take place?

more options

Have you used an SQLite Manager to view the places.sqlite file?
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

Viewing the "table" structure might be informative. Plus sqlite is a standardized format and has a lot of documentation available online.
https://sqlite.org/

Overall, Mozilla designs file systems to "work", not to be easy for users to tinker with or to extract data from. Quite honestly, you might be better off exporting your bookmarks in HTML format; it's a lot simpler with more uniformity, IMO. I haven't tinkered with sqlite files very much, but found that the bookmarks.html format is very understandable with a limited knowledge of working with HTML code.

more options

Hmm, I have installed the SQLite Manager . . . When I click on places.sqlite, nothing happens:

C: \ Users \ Username \ AppData \ Roaming \ Mozilla \ Firefox \ Profiles \ long string \ places.sqlite

. . . but, that's what I am already doing . . . exporting the bookmarks to html, and then Opening / Importing them to Excel

If I can do something with it as a database, though, yes, that might be more usable, thanks! I'll have to take a look a this.

Modified by sludge7051-x

more options

Chosen Solution

Sorry, I didn't zoom that first image and see that it was an bookmarks.html file mentioned in the lower section of that Excel window. A small 19" widescreen monitor and 64 yo eyes couldn't read that spreadsheet too well.

more options

LOL np

I installed the Add-on, clicked on a copy of places.sqlite, and it doesn't do anything.

I installed this program, did File / Open, and it doesn't do anything: http://sourceforge.net/projects/sqlitebrowser/

She doesn't want to give up her secrets

more options

Ok, I installed SQLite Manager

If you go to Firefox (top left menu) / Web Developer / SQLite Manager . . . Database / Connect Database / D:/temp/places.sqlite (work from a copy)

- - - - - - - - - - - - - - - - - - - -

Tables

moz_bookmarks / Browse & Search tab all the new bookmark Titles are in here at the bottom, but not the URLs

moz_places / Browse & Search tab all the new bookmark Titles and URLs are in here, but not identifiable as the new ones / Unsorted

I don't see how I can get the URLs field to moz_bookmarks, it's not like Access

Would be good if I could just export the whole table, but that doesn't include either the Titles or URLs