up vote 11 down vote favorite
6
share [g+] share [fb]

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?

link|improve this question
75% accept rate
How many movies are in your queue? – Troggy♦ Aug 4 '09 at 14:39
320 movies. – Trey Piepmeier Aug 4 '09 at 14:44
Why not, just copy and paste the que or save the html file to your desktop? – xxl3ww Aug 4 '09 at 14:46
That's pretty much what I ended up doing. – Trey Piepmeier Aug 4 '09 at 15:21
feedback

6 Answers

up vote 14 down vote

Using Google Docs + Netflix RSS to pull 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)

Note the double quotes around the URL. The ,,true pulls in headers.

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

alt text

(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 URL box and click Run 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.

link|improve this answer
1  
+1 for using girlfriends movie list as example – jschoen Aug 4 '09 at 15:05
That's a beautiful solution, but it only returns the first 21 items. – Trey Piepmeier Aug 4 '09 at 15:07
Of course; the docs don't mention this limitation at all... docs.google.com/support/bin/answer.py?answer=75507 – SirStan Aug 4 '09 at 15:13
I just tried this in Excel 2010 and it works exactly the same. I just clicked "File / Open" and pasted the queue URL in, and answered a few simple xml questions and got my queue right in Excel. So +1 for using a spreadsheet + RSS to solve this problem. – Steve Midgley Jan 2 at 5:14
feedback
up vote 2 down vote accepted

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.

link|improve this answer
Nice use of JQuery -- the nice thing about my way is it works for any RSS feed -- and doesn't require Firebug, saving locally, or a working knowledge of JQuery. – SirStan Aug 4 '09 at 15:05
I agree, your solution is much nicer, but I can't get all 320 items. – Trey Piepmeier Aug 4 '09 at 15:11
feedback
up vote 1 down vote

After failing at the above suggestions several times, I just opened my Netflix RSS, went to File/Save As. it defaulted to .xml and saved it to the desktop. Then I opened it up in Excel. Got a lovely little spreadsheet that was ready to edit, sort, and delete unneeded columns. The entire 375 item queue was available in seconds.

link|improve this answer
feedback
up vote 1 down vote

None of the above seemed to work for me so I tried something else.

I opened Internet Explorer 9, logged into Netflix, went to my queue, and right clicked the page. There was an option to "Export to Microsoft Excel" which when clicked opens Excel. Copy the address of the Netflix queue you would like to save, paste in Excel "address" bar, and click "Go."Go ahead and click "Import" and wait for Excel to import the data. Once finished, click "OK" on the Import Data window to import into the existing sheet, then delete any unnecessary rows and columns.

link|improve this answer
Works in IE 8 as well. – Alger Sep 22 '11 at 13:15
feedback
up vote 1 down vote

http://ratings-exporter.heroku.com/

Uses the Netflix API. It can't export all of your ratings. Only those movies that you have in your rental history.

update: if you want access to the code, it's on github @ https://github.com/sorens/ratings-exporter

link|improve this answer
feedback
up vote 0 down vote

Without knowing your browser I can't give specifics but try saving the page to disk. If that doesn't work for you, right-click and pick "view source" and use that.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.