Den här webbplatsen har begränsad funktionalitet medan vi utför underhåll för att förbättra din upplevelse. Om en artikel inte löser ditt problem och du vill ställa en fråga har vi vår gemenskap som väntar på att hjälpa dig på @FirefoxSupport på Twitter, /r/firefox på Reddit.

Avatar for Username

Sök i support

Akta dig för supportbedrägerier: Vi kommer aldrig att be dig att ringa eller skicka ett sms till ett telefonnummer eller dela personlig information. Rapportera misstänkt aktivitet med alternativet "Rapportera missbruk".

Läs mer

Denna tråd har arkiverats. Ställ en ny fråga om du behöver hjälp.

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" - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Alla svar (6)

sludge7051-x
sludge7051-x Frågans ägare
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 Frågans ägare
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 Frågans ägare
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 Frågans ägare
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.