• Search

Export Google Chrome Bookmarks

Post TYPELiFE · 09.13.2008 9:31 pm

[Note: Updated to reflext upcoming changes in Google Chrome's build. thx screasey.]

Hey, hopefully this update will help you all out. I stayed up all night making a nice little web tool you can just upload your Bookmarks file to, and it will spit out a .html file you can save!

Web Exporter: http://tools.googlechromeboard.com/expo ... kmarks.php

--- OR, USE MARKCLOUDEN'S UTILITY ---

MarkClouden's Google Chrome Bookmark Exporter

--- OR, YOU CAN STILL DO IT THE MANUAL WAY --- (OUTDATED?)

You're actually going to need Mozilla Firefox for this one, because there is no third party utility developed specifically for exporting Google Chrome bookmarks, and nothing built into Google Chrome to do so.

If you're like me, you probably had to reinstall Firefox, ahh ... memories.

  • Download SQLite Manager Mozilla Firefox Plugin
  • Run SQLite Manager from within Firefox (Tools > SQLite Manager)
  • Click on Database, and then Connect Database
  • Windows XP: C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\Google\Chrome\User Data\Default\History
  • Windows Vista: C:\Users\<USERNAME>\AppData\Local\Google\Chrome\User Data\Default\History
  • Click View > Create View, name it bookmarks and enter SELECT * FROM urls WHERE starred_id >= 1 then click OK.
  • If you're running on the new Chromium build (or future builds of Google Chrome) use this query instead: SELECT * FROM starred
  • Click View > Export View and click OK, use the next dialog to save the file to wherever you would like.

By default, SQLite Manager will spit out a comma separated values database of your bookmarks.
GOOGLECHROMEBOARD.COM [ADMINISTRATOR]
You Find Me @ Digg, Pownce, Twitter, Wakoopa
Windows XP Tweaks, Freeware Utilities, Linux Help
User avatar
TYPELiFE
Site Admin
 
Posts: 179
Joined: 09.03.2008 6:51 am

Re: Export Google Chrome Bookmarks

Post MarkClouden · 09.18.2008 6:25 pm

The steps listed would have just been far too simple to follow (had I read them last week).

Without them at hand, I wrote a quick utility app to do this and many many more things (OK, exactly one other thing). It is described and includes a download link at http://blog.reloadedsoftware.com.

The app creates the formal bookmark.htm file for easy import in to any other browser.
MarkClouden
 
Posts: 3
Joined: 09.18.2008 6:20 pm

Re: Export Google Chrome Bookmarks

Post TYPELiFE · 09.19.2008 3:14 am

Hey MarkClouden, thanks for posting your application! Sadly, it errors out for me ... I shot you an e-mail with the error log the crash generated.
GOOGLECHROMEBOARD.COM [ADMINISTRATOR]
You Find Me @ Digg, Pownce, Twitter, Wakoopa
Windows XP Tweaks, Freeware Utilities, Linux Help
User avatar
TYPELiFE
Site Admin
 
Posts: 179
Joined: 09.03.2008 6:51 am

Re: Export Google Chrome Bookmarks

Post MarkClouden · 09.19.2008 4:16 am

In case you didnt see, the error has been fixed. Thanks again.
MarkClouden
 
Posts: 3
Joined: 09.18.2008 6:20 pm

Re: Export Google Chrome Bookmarks

Post BooJeanIsIt · 09.27.2008 2:54 am

Thank you so much!!!!!!
BooJeanIsIt
 
Posts: 1
Joined: 09.27.2008 2:53 am

Re: Export Google Chrome Bookmarks

Post screasey · 10.06.2008 7:54 pm

Looks like this is now broken. The 'starred_id' has been removed:

http://src.chromium.org/viewvc/chrome/trunk/src/chrome/browser/history/url_database.h?r1=1153&r2=1152&pathrev=1153

But the 'Bookmarks' file (...\Local Settings\Application Data\Google\Chrome\User Data\Default) looks like it's just an instainated javascript array.

--
Spencer

salud (below) wrote:What do you mean by "instainated" ... I've never heard that word before?

My bad (sp). I meant "instantiated". But it is a js array, or rather an object = hashed js array (Mozilla calls them Initializers/Literals).
Last edited by screasey on 12.11.2008 5:50 pm, edited 1 time in total.
screasey
 
Posts: 2
Joined: 10.06.2008 7:42 pm

Re: Export Google Chrome Bookmarks

Post TYPELiFE · 10.07.2008 4:11 am

screasey wrote:Looks like this is now broken. The 'starred_id' has been removed:

http://src.chromium.org/viewvc/chrome/trunk/src/chrome/browser/history/url_database.h?r1=1153&r2=1152&pathrev=1153

But the 'Bookmarks' file (...\Local Settings\Application Data\Google\Chrome\User Data\Default) looks like it's just an instainated javascript array.

--
Spencer


thanks for pointing that out Spencer, I updated the original post to reflect how to export bookmarks in the new Chromium builds or future versions of Google Chrome.
GOOGLECHROMEBOARD.COM [ADMINISTRATOR]
You Find Me @ Digg, Pownce, Twitter, Wakoopa
Windows XP Tweaks, Freeware Utilities, Linux Help
User avatar
TYPELiFE
Site Admin
 
Posts: 179
Joined: 09.03.2008 6:51 am

Re: Export Google Chrome Bookmarks

Post masReich · 10.07.2008 6:33 am

TYPELiFE wrote:
screasey wrote:Looks like this is now broken. The 'starred_id' has been removed:

http://src.chromium.org/viewvc/chrome/trunk/src/chrome/browser/history/url_database.h?r1=1153&r2=1152&pathrev=1153

But the 'Bookmarks' file (...\Local Settings\Application Data\Google\Chrome\User Data\Default) looks like it's just an instainated javascript array.

--
Spencer


thanks for pointing that out Spencer, I updated the original post to reflect how to export bookmarks in the new Chromium builds or future versions of Google Chrome.


Thanks for the fix, I'm using Chromium to test out GChrome until I like it to actually install the stable, hehe.
Never be afraid to question the general opinion.
User avatar
masReich
 
Posts: 5
Joined: 10.07.2008 6:31 am

Re: Export Google Chrome Bookmarks

Post zeem · 10.09.2008 11:49 pm

I have the lastest chromium build. SQLite gave me this message after trying this query: SELECT * FROM starred. I targeted C:\Documents and Settings\Administrator\Local Settings\Application Data\Chromium\User Data\Default\History

Likely SQL syntax error: CREATE VIEW "main"."bookmarks" AS SELECT * FROM starred [ no such table: main.starred ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

Is there anything more required in the query? Seems like it is missing something, or did I target the wrong file?

thanks,
zeem
zeem
 
Posts: 1
Joined: 10.09.2008 11:46 pm

Re: Export Google Chrome Bookmarks

Post salud · 10.11.2008 6:30 pm

screasey wrote:Looks like this is now broken. The 'starred_id' has been removed:

http://src.chromium.org/viewvc/chrome/trunk/src/chrome/browser/history/url_database.h?r1=1153&r2=1152&pathrev=1153

But the 'Bookmarks' file (...\Local Settings\Application Data\Google\Chrome\User Data\Default) looks like it's just an instainated javascript array.

--
Spencer


What do you mean by "instainated" ... I've never heard that word before?

This is what a javascript array looks like: http://www.tizag.com/javascriptT/javascriptarray.php

The "fix" for Chromium didn't work for me. I think you're using an older build of Chromium that still has the "starred" table, the newer ones do not.

Like screasey said, there is a file with what seems to be oddly formed XML (not javascript, or XML for that matter) with your bookmarks in it.
salud
 
Posts: 4
Joined: 10.11.2008 6:01 pm

Next

Return to Google Chrome Tips & Tricks

Who is online

Users browsing this forum: No registered users and 0 guests