Is it possible to export your Netflix queue?
Hire the world's top talent on demand or became one of them at Toptal: https://topt.al/25cXVn
and get $2,000 discount on your first invoice
--------------------------------------------------
Music by Eric Matyas
https://www.soundimage.org
Track title: Puzzle Game 2
--
Chapters
00:00 Is It Possible To Export Your Netflix Queue?
00:18 Answer 1 Score 20
02:38 Accepted Answer Score 3
03:16 Answer 3 Score 1
03:44 Answer 4 Score 1
04:17 Thank you
--
Full question
https://superuser.com/questions/18037/is...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#rss #netflix
#avk47
ANSWER 1
Score 20
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
- 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.
ACCEPTED ANSWER
Score 3
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.
ANSWER 3
Score 1
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.
ANSWER 4
Score 1
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.