Google Chrome Board
February 11, 2012, 09:26:53 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Been meaning to throw some schnazz on the forum for some time, and well, it's here!
 
   Home   Help Search Login Register  
Pages: [1] 2 3
  Print  
Author Topic: Export Google Chrome Bookmarks (Outdated/Manual)  (Read 16166 times)
TYPELiFE
Administrator
Newbie
*****
Posts: 247




View Profile WWW Email
« on: September 13, 2008, 03:31:02 PM »

[Note #1: Updated to reflext upcoming changes in Google Chrome's build. thx screasey.]
[Note #2: You can now import/export bookmarks through the bookmark manager. If you can't open Chrome, try this.


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.

Note: These instructions represent browsing through your history, if you would like to view your bookmarks, you can open the 'Bookmarks' file in the folder described below to see them.

  • 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 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.
« Last Edit: November 30, 2010, 09:34:29 PM by TYPELiFE » Logged

MarkClouden
Newbie
*
Posts: 3


View Profile Email
« Reply #1 on: September 18, 2008, 12:25:11 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.
Logged
TYPELiFE
Administrator
Newbie
*****
Posts: 247




View Profile WWW Email
« Reply #2 on: September 18, 2008, 09:14:35 PM »

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.
Logged

MarkClouden
Newbie
*
Posts: 3


View Profile Email
« Reply #3 on: September 18, 2008, 10:16:36 PM »

In case you didnt see, the error has been fixed. Thanks again.
Logged
BooJeanIsIt
Guest
« Reply #4 on: September 26, 2008, 08:54:10 PM »

Thank you so much!!!!!!
Logged
screasey
Newbie
*
Posts: 2


View Profile Email
« Reply #5 on: October 06, 2008, 01:54:22 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

Quote from: "salud (below)"
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 Edit: December 11, 2008, 11:50:29 AM by screasey » Logged
TYPELiFE
Administrator
Newbie
*****
Posts: 247




View Profile WWW Email
« Reply #6 on: October 06, 2008, 10:11:14 PM »

Quote from: "screasey"
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.
Logged

masReich
Newbie
*
Posts: 5




View Profile Email
« Reply #7 on: October 07, 2008, 12:33:47 AM »

Quote from: "TYPELiFE"
Quote from: "screasey"
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.
Logged

Never be afraid to question the general opinion.
zeem
Newbie
*
Posts: 1


View Profile Email
« Reply #8 on: October 09, 2008, 05:49:23 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
Logged
salud
Newbie
*
Posts: 4


View Profile Email
« Reply #9 on: October 11, 2008, 12:30:30 PM »

Quote from: "screasey"
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.
Logged
Skettalee
Newbie
*
Posts: 4


View Profile Email
« Reply #10 on: October 20, 2008, 11:23:05 AM »

First I tried the SQLLite thing and I noticed that there is no History folder inside of
C:\Users\Damien Lee\AppData\Local\Google\Chrome\User Data\Default

And thats the user I am using... I tried all other users which is Default and Local and Public and there isn't anything there either...

Plus I tried the little program that the person made and that didn't work either. I really need to get all my bookmarks cause I need to reformat my computer and thats the only way i can save my bookmarks before I reformat. Can someone help?
Logged
enery
Newbie
*
Posts: 1


View Profile Email
« Reply #11 on: October 20, 2008, 11:58:30 AM »

Had the same problem, wanted to take my bookmarks with me when I traveled, finaly did it the long way.

Open firefox (or Internet explorer), select organise bookmarks.
Now Open Chrome (so its open at the same time).
You can now drag and drop individual bookmarks from Chrome to firefox (or IE) like you would in word.
You still have to creat folders in firefox and IE as chrome doesn't allow you to drag and drop them, just the bookmarks.

Takes time but you can now use firefox or IE to back them up in the usal way.
Logged
Skettalee
Newbie
*
Posts: 4


View Profile Email
« Reply #12 on: October 20, 2008, 12:25:12 PM »

OMG. That is just sick and terrible. Why would Google release their browser to the public before they have ability to export bookmarks and more..... having notifications for gmail... Why cant google have a gmail notification system in the browser... sometimes people just really dont think!
Logged
markils
Newbie
*
Posts: 1


View Profile Email
« Reply #13 on: October 21, 2008, 08:58:24 AM »

What if there is no : Windows XP: C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\Google\Chrome\User Data\Default\History
Path on my PC
I did search and there is no files with extension *.sqlite on my computer at all?!
Logged
Skettalee
Newbie
*
Posts: 4


View Profile Email
« Reply #14 on: October 22, 2008, 12:43:04 AM »

Well then if you cant find it then you are screwed just like the rest of us. Maybe google is just slipping up because I cant find it either using Vista. I did a search and its nowhere. I guess we will all have to give up on life.

Here take this pill with me!
Logged
Pages: [1] 2 3
  Print  
 
Jump to:  

Powered by SMF 1.1.10 | SMF © 2006-2009, Simple Machines LLC