Export Firefox Mobile Bookmarks & Import to Kiwi #Android

bookmarks.sql

/* bookmarks are stored in "/data/data/org.mozilla.firefox/files/mozilla/…….default/browser.db" */
SELECT url, title, created
FROM bookmarks
WHERE COALESCE(url, '') <> ''
ORDER BY created ASC

• Open browser.db in DB Browser for SQLite
• Execute the above SQL and save the results view as CSV, default options
• Open saved CSV file in this page: skip first row ticked, select the correct columns
• Convert and save HTML file (transfer to phone)
• Open Kiwi bookmarks menu and import bookmarks from HTML file (folders will have to be set up again - bookmarks are imported to a 'Bookmarks bar' folder so they will need to be moved out of there)

I found it much easier to manage my bookmarks in a desktop browser and then sync them to Kiwi using floccus, as moving them out of the 'Bookmarks bar' folder directly messes up the order which I really hate. I have noted what I actually did at the bottom, but I have since used floccus more and refined the method:

• Log in on a computer using a throwaway/portable browser or profile with the floccus extension installed (I used Edge)
• Import favourites from HTML file into computer browser: in Edge they will be imported into 'Other favourites'. From here they can be dragged into a subfolder for neatness (I made a new one called Kiwi)
• Set up floccus to sync (auto-sync not required) to Google Drive. It is important to set the local folder in floccus' options to the subfolder the imported bookmarks are currently in (in my case, /Other favourites/Kiwi/). I already use floccus with this Google account for another set of bookmarks but it is easy to specify a new .xbel file to sync to.
• Push sync once in Edge and export floccus settings.
• Install floccus in Kiwi and import the settings JSON. Change the local folder to /Mobile bookmarks/ - this is crucial!
• Pull sync once in Kiwi

What I actually did

• Log in on a computer using a throwaway/portable browser or profile with the floccus extension installed (I used Edge)
• Export floccus settings after setting up sync to Google Drive, import to Kiwi (tip from here)
• Push sync once in Kiwi, pull sync once in Edge
• Leave bookmarks in Bookmarks/Favourites bar folder but edit & add subfolders as desired in Edge
• Push sync once in Edge, pull sync once in Kiwi
• Bookmarks can be moved out into 'Mobile bookmarks' folder in Kiwi by choosing this folder in floccus' Folder mapping options (it was bugging me having everything left in the wrong folder)