RKG Logo 434-970-1010

I’m a big fan of Google Reader. I like to use the gold star to flag interesting posts. I wanted to export a list of these interesting posts, but couldn’t find any info online on how to do this. Here’s my approach. It is much simpler to do than to explain.

star1,png

1. Inside Google Reader, go to “Settings” on top right, then go to “Folders and Tags”. Click the box next to “Your starred items”, then use the “change sharing” pulldown to set your starred items to “Public.” If you are worried about privacy, you can make your starred list private again afterwards.

star2

2. Click “View Public Page” on the “Your Starred Items” page.

star3

3. Copy the URL of this page and paste it in a text editor or Notepad. It should have a long number it, 20 or so digits. That number represents your Google Reader account.

4. Paste this url into your text editor (this is all one line)

http://www.google.com/reader/public/atom/user/99999/state/com.google/starred?n=100

and replace the string of 9s with your long 20 digit number.

Make sure when you paste in the number that the URL still has a slash before and after the number. (Note on Nial Kennedy’s excellent Google API page there’s a typo where he omitted the initial slash on the starred item url.)

5. Voilà — that URL is an Atom feed for your starred items.

The n=100 parameter indicates how many items you want. You can adjust it appropriately.

6. Similarly, you can get Atom feeds for your Google Reader tags, your Google Reader read items, etc. Nial has the details.

7. Digression: at this point, if you wanted, you could run your Atom feed through Yahoo Pipes to derive a new feed, dropping rows or merging in additional information.

star4

8. Now, how to go from Atom to HTML? If you knew enough XSLT, you could use a simple transformation. I tried to cook up some XSLT so folks could use an online tool like xslt.sitesfree.com. No luck; couldn’t figure it out. Any XSLT gurus reading this? Advice?

9. Striking out with XSLT, I opted to use a script. I went with Ruby. Perl or Python would also work. Here’s the 8 line Ruby program:

require "rubygems"
require "open-uri"
require "simple-rss"
feed = "http://www.google.com/reader/public/atom/user/99999/state/com.google/starred?n=100"
rss = SimpleRSS.parse open(feed)
rss.entries.each do |item|
puts "<li><a href='#{item.link}'>#{item.title}</a></li>\n"
end

Again, replace those 9s with your 20 digit Google Reader id.

Ruby is installed by default on ‘nix and Mac; there’s a Win95 version here. gem install simple-rss gets you the RSS-parsing gem if you need it.

10. Now you can undo Step #1 to reset your starred feed to private if you want.

11. Here’s sample output from the script:

Technorati Tags: ,

If you like this post, consider subscribing to our RSS feed. You can also have new posts sent to you via email.


Related Posts

    No related posts.

Comments

  1. Namu, October 8, 2008:

    Thank you for the great tip. Now I can read my starred items on my iPod touch offline!

  2. Bashwork, November 5, 2008:

    Here is an XSLT stylesheet I put together that one can modify to include/exclude/layout the data they want. Depending how crazy you want to go with it, there are also style-sheet and javascript components that can be modified.

    xslt http://pastebin.com/f412de634
    css http://pastebin.com/f35966c20
    js http://pastebin.com/f3e390475

  3. Roman, November 7, 2008:

    I’ve done it with feedburner

  4. David Lano, December 14, 2008:

    Wow, this is exactly what I was looking for! Thank you so much. :)

  5. Pieter, July 26, 2009:

    It works well. What I would like to know is how can I spider the resultant HTML links and get all the url of the links on the webpages referred to by the initial list of links. I have looked at anemone, but cannot see how I can get it to use the output of this as an input?

  6. Moritz, September 5, 2009:

    Hi, this is exactly what i am looking for. But unfortunately it doesn’t work for me. I did everything as described above. I’ve created a rb-file with the code provided by you (but my Google reader ID), but i can not open this file. Could you please describe what i have to do after creating the ruby script? Do i have to open this file in Terminal (i am using a MAC), do i have to install any other program befor or something completely differen?

    Apologies for my questions, i really would like to have this work for me :-)

    All the best from Germany.

  7. hector, October 7, 2009:

    Thanks! This is especially useful when switching trough accounts.

  8. Rachel, October 13, 2009:

    This worked great. Thanks!

  9. Mohammed Iqbal, December 2, 2009:

    Thanks for this post.

    But my requirement is a little tricky. I want to move all my starred items from one gmail to another gmail ID. Because I want to keep all my RSS Feeds (and starred items) of science journals seperate from RSS feeds of general interest.

    Any help will be much appreciated!

    Thanks so much
    Cheers!

Your Comment

Tags

RKG Tags: ,

Technorati Tags: ,

Trackback

http://www.rimmkaufman.com/rkgblog/2008/09/19/google-reader-export-starred-posts/trackback/

Blogs Citing This Post

  1. Pingback: Exporting Google Reader’s Stars | Tom Altman's Conversation on October 31, 2008
  2. Pingback: RSS Week #72: letture per il weekend - Matteo Moro on November 7, 2009

Email Updates

Categories

Recent Comments

  • George Michie: Art, your observations about negatives are very interesting. Hopeful the selection bias will get people to read before they click,...
  • George Michie: John E., thanks for stopping by! You make an excellent point over as SEL, but I think what will happen is a positive selection bias....
  • John: I too am concerned about the long tail effect. Users are going to have to “wade” through competing websites to find anything...
  • John Ellis: As a paid search marketer, I am little concerned about the long-tail effect. Hopefully, I am wrong. FYI – See my thoughts here:...
  • Jc: Yeah when you’re talking about Google, they already have a large set of randomly sampled statistics on user behavior from their tests...
  • Art: Here are some observations I have so far. 1. Example: In my daycare campaign I have “jobs” as a negative phrase match keyword. When I do a...
  • George Michie: Dale, it will be fascinating to see how this plays out. I have to believe that it won’t result in a greater propensity for...
  • George Michie: Another interesting possibility: If users no longer scroll, but “just keep typing” does that mean that the click volume...
  • Dale Stokdyk: For me, it’s hard to believe the 3 second rule is enough — in my gut, I suspect impressions will increase. Also, I...
  • George Michie: Great point, JC, They made the comment during the press conference that they think* users will conduct more searches around the...
  • Jc: I think it will be very interesting what will happen to impressions and CTR. Based on the assumption that whatever Google does increases their...
  • George Michie: Dale it’s a great question. I wonder what fraction of searches actually happen from Google.com vs toolbars vs an iGoogle...
  • Dale Stokdyk: George, I use the Google Search Bar 99% of the time — I wonder about others? Was fascinating to watch the search results change...
  • George Michie: :-) Somewhat less so…Yahoo?…don̵ 7;t get me started :-)
  • Jc: Now my question is, do you share the same level of faith about Bing? Haha.

Blog Stats

  • Posts: 993
  • Words: 481,930
  • Comments: 3,390

Administration