Firefox Bookmarks to .xlsm [SOLVED]

[slack7639]

I figured out how to get my bookmarks out of Firefox and into Excel. A macro processes them, and other macros get you around the Worksheet.

It uses: 1.) Firefox, 2.) SQLite3, 3.) DOS, 4.) Excel VBA, 5.) NirCmd (optional)

All you have to do is to categorize your bookmarks, and then click the sort button.

These two PDFs provide code for the BAT files, and explain how to set up the paths for the macros. More instructions are in the VBA of the xlsm. These three files are on my Google Docs.

I thought I'd share this, because it's cool, might be useful to others . . . and maybe someone can improve on what I have, or give me some more ideas . . . maybe this post can be left open.

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

bookmarks-to-CSV.pdf . . . This first page provides all you need to know, to get your Bookmarks into a .CSV file (This won't do anything to your actual Bookmarks, it just extracts a copy of them.) . . . Then, the next few pages provide the details of what's going on . . . https://drive.google.com/open?id=1xYWPQtijqCzk-1nzTsTb0ZUVKYJNFokR

Custom UI Editor.pdf . . . Supporting info, and BAT file code to be set up . . . https://drive.google.com/open?id=1G2AWBamOrbAo2ZNDtUyYdzegjKzz34DA

bookmarks-p.xlsm . . . The Preview on Google Docs isn't that great. Some supporting info is in the first four Worksheets. Bookmarks are in the fifth Worksheet (see tabs across the bottom) . . . https://drive.google.com/open?id=1ZOuOBkdJjMx1T4xMUNG7sf6MDWurUqqy

 

[mole999]

Firefox & Excel
a less formatted way is to get Google to export them as html, then import that into excel

 

[slack7639]

That's probably the way to go initially, if you have a lot of bookmarks, and want to get the folders, so you don't have to spend as much time putting them back into Categories.

The Firefox database is in SQLite3. What would be the query to get the folders every time? I think you use:

. . . recurse sub folders. That would require WITH RECURSIVE . . . https://support.mozilla.org/en-US/questions/1199029

WITH clause . . . http://www.sqlite.org/lang_with.html

I don't know how to do it, though.

 

[slack7639]

This might work:

Can I export my bookmarks into a text file in order to ensure I never lose them? . . . https://support.mozilla.org/en-US/questions/850424

FavoritesView v1.32 . . . http://www.nirsoft.net/utils/faview.html

 

[slack7639]

. . . but it looks like FavoritesView v1.32 doesn't give you the "folders" your bookmarks are in, either

 

[mole999]

you can let mozilla synch your favorites, so they will always be available, or back up the two files from your profile which are encrypted, and keep copies

 

[slack7639]

I like to get them out of FF, and into Excel, so I can add notes, and order them . . . Excel makes them easier to work with.

Also, the browser is supposed to work faster, if you don't have thousands of bookmarks. Maybe that's outdated information by now.