Firefox Bookmarks to .xlsm [SOLVED]

slack7639

Board Regular
Joined
Apr 19, 2016
Messages
65
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
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Firefox & Excel
a less formatted way is to get Google to export them as html, then import that into excel
 
Upvote 0
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.
 
Upvote 0
. . . but it looks like FavoritesView v1.32 doesn't give you the "folders" your bookmarks are in, either
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,178
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top