Is it possible to export your Netflix queue? [closed]
I'm about to cancel my Netflix account and I'd like to be able to keep the list of movies in my queue. Is there an easy way to export the list in plain text so I don't have to resort to printing it out?
Using Google Docs + Netflix RSS to pull up to 250 items in your queue (or other things!)
- Login to Netflix
- Click RSS at the bottom of the page (hint, its nessled between some other junk):
Jobs Media Center Netflix Prize RSS App Gallery Facebook Connect Tell a Friend
- Get the RSS feed for your queue:
Personalized Feeds
Queue: http://rss.netflix.com/QueueRSS?id=P191900XXXXX892`
- Load up Google Docs, open a new spreadsheet, goto A1 and enter:
=importfeed("URLFROMABOVE",,true,250)
Note the double quotes around the URL. The true pulls in column headers and the max queue entries supported by Google is 250.
You should now have a Google docs spreadsheet with your queue in it with TITLE, URL, and DESCRIPTION headers. Use it as you will.
- If you don't want the 001- part.. create a new cell with this formula (in Google docs):
=right(A2,len(A2)-5)
Which will cut off the 001- part (if 001- is in A2). Just copy the formula down to get the rest of the title's sans the ID.
Link to my Example
Link to my girlfriends (don't tell her im sharing!): http://spreadsheets.google.com/ccc?key=0Al6h7KQIZVQFdEI2aXJfeGhZSWNhdjczY1pQV2JOSHc&hl=en
Image of result
(attempt #2) Less Elegant, but returns entire QUEUE:
- Grab your RSS URL (see above).
- Goto
http://pipes.yahoo.com/earth2marsh/feed2csv - Enter your RSS url from above into the
URLbox and clickRun Pipe. - Right click 'get as RSS' and copy the URL.
- Load Google docs, open a new file, and enter:
= importdata("
url copied above")
- Before you click OK, find the part in the url that says
render=rss
.......pipe.run?_id=49c30ca389410df9ef49b008e0d65203&_render=rss&feedURL=http%3A%2F%2Fwww.go...........
and change it to render=csv
- See the examlpe Google document below, check the second tab at the bottom labeled
IMPORTDATA
or .. just copy the URL, change to render=csv, and save the sucker and open locally in Excel. Poo on Google for ruining my pretty answer.
CSV FILE of my girlfriends netflix.
I got something very basic working by:
- Saving the source of my queue page
-
Putting a link to Google-hosted jQuery in the
<head>of the document and removing some of the existing JS. Like so:<script src="http://www.google.com/jsapi" type="text/javascript"></script><script type="text/javascript">google.load("jquery", "1.3.2");</script> Loading the local page in Firefox
-
Running this code in the Firebug console:
$('span.title a').each(function(index) {console.log($(this).html());});
That just spit out the titles of everything in my queue.