Firefox Bookmarks to .xlsm [SOLVED]

slack7639

Board Regular
Joined
Apr 19, 2016
Messages
57
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 fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
Firefox & Excel
a less formatted way is to get Google to export them as html, then import that into excel
 

slack7639

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

Board Regular
Joined
Apr 19, 2016
Messages
57

ADVERTISEMENT

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

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
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

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

Watch MrExcel Video

Forum statistics

Threads
1,129,577
Messages
5,637,193
Members
416,960
Latest member
Carbon1198

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
Top