Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

Avatar for Username

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

This thread was archived. Please ask a new question if you need help.

Bookmarks - How to extract them from places.sqlite, and save as a .CSV

sludge7051-x
sludge7051-x
more options

I had to update this (below), since this is so great, and no longer works with FF 57.

Previous way (for reference) . . . Bookmarks - Convert from places.sqlite to .xlsx (Excel) - How? | Firefox Support Forum . . . https://support.mozilla.org/en-US/questions/996638

New way:

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

DB Browser for SQLite . . . I got the "PortableApp" version . . . http://sqlitebrowser.org/

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

View / Preferences / General / Default location - "Remember last location" / Ok

File / Open / C: \ Users\ USER-NAME \ AppData \ Roaming \ Mozilla \ Firefox \ Profiles \ u70715dh.default \ places.sqlite

Later . . . Ctrl+1 . . . or . . . File - and it's at the bottom . . . "Views" / right-click on "output"

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

Execute SQL tab / put in the code:

SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,"unixepoch","localtime") AS Date FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id

. . . and "Execute SQL" - click the "Play" button

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

Bottom right square / Save as view "output" / Ok

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

Database Structure tab / See "Views" below . . . right-click on "output" / Export as CSV file

[un-check] "Column names in first line," otherwise, you get the SYLK error / Ok

Save "output.csv" to Desktop / Save / Ok . . . then run the Excel Macro on it

Later . . . run this Script from "Views" in the future, also

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

File / Exit / "Do you want to save changes made to the database file?" - Yes

. . . I guess it Saves my Script in Firefox's "places.sqlite"

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

I had to update this (below), since this is so great, and no longer works with FF 57. Previous way (for reference) . . . Bookmarks - Convert from places.sqlite to .xlsx (Excel) - How? | Firefox Support Forum . . . https://support.mozilla.org/en-US/questions/996638 New way: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - DB Browser for SQLite . . . I got the "PortableApp" version . . . http://sqlitebrowser.org/ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - View / Preferences / General / Default location - "Remember last location" / Ok File / Open / C: \ Users\ USER-NAME \ AppData \ Roaming \ Mozilla \ Firefox \ Profiles \ u70715dh.default \ places.sqlite Later . . . Ctrl+1 . . . or . . . File - and it's at the bottom . . . "Views" / right-click on "output" - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Execute SQL tab / put in the code: SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,"unixepoch","localtime") AS Date FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id . . . and "Execute SQL" - click the "Play" button - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Bottom right square / Save as view "output" / Ok - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Database Structure tab / See "Views" below . . . right-click on "output" / Export as CSV file [un-check] "Column names in first line," otherwise, you get the SYLK error / Ok Save "output.csv" to Desktop / Save / Ok . . . then run the Excel Macro on it Later . . . run this Script from "Views" in the future, also - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - File / Exit / "Do you want to save changes made to the database file?" - Yes . . . I guess it Saves my Script in Firefox's "places.sqlite" - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

All Replies (6)

sludge7051-x
sludge7051-x Question owner
more options

It ran this together.

The code is supposed to be two rows, with no row in between:

SELECT a.id AS ID, a.title AS Title, b.url AS URL, datetime(a.dateAdded/1000000,"unixepoch","localtime") AS Date

FROM moz_bookmarks AS a JOIN moz_places AS b ON a.fk = b.id

sludge7051-x
sludge7051-x Question owner
more options

I figured out how to do this using SQLite3 and a .BAT file . . . No database viewer is necessary!

I've summarized what to do in a PDF . . . uploaded to my Google Docs . . . Here's the link:

bookmarks-to-CSV.pdf . . . https://drive.google.com/open?id=1xYWPQtijqCzk-1nzTsTb0ZUVKYJNFokR

"Page 1" provides _all_ you need to know, to get your Bookmarks into a .CSV file (When you run the .BAT file, it 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.

Credit for this SQL query goes to cor-el (please see page 4) . . . thank you!

I have an Excel macro that edits and appends them to another worksheet. Let me get a link to that . . . hang on . . .

Shadow110
Shadow110
more options

So why are you asking this again when you have answers in : https://support.mozilla.org/en-US/questions/1190466

Never make 2 questions , this is the same question, Change/Alter the title of your question to fit.

Shadow110
Shadow110
more options

Easy, get, Avast and it will delete and convert them with out even asking.

sludge7051-x
sludge7051-x Question owner
more options

I think that other link was preliminary to what I've figured out. I probably should have posted the above there . . . I have since improved on it, and want to share. I have something else to add tomorow or Friday.

Avast does it? How? Do you have a link?

sludge7051-x
sludge7051-x Question owner
more options

I had to figure out how to do a Custom Ribbon in Excel, which will stay with the worksheet, and make it easy to run the macros.

Instructions for that, along with code for the .BAT files, are in a second pdf - the link is on this page:

Firefox Bookmarks to .xlsm [SOLVED] . . . https://www.mrexcel.com/forum/excel-questions/1040778-firefox-bookmarks-xlsm-solved.html

I put a link to a copy of the xlsm, there, also. Remarks in the VBA explain more of what the macros do.

Since VBA does most of it, I posted it there, in case someone wants to make comments, or has Excel questions.

I always wondered what a good application for Excel macros would be, and found it, working with the Bookmarks.