The Movie Database Support
Support → General
Export movie data to .csv
posted by PatuleiaSTAFFMOD on March 22, 2015 at 8:27 PM
Hi, I'd like to know if there is any app or website that allows me to get the full details of all movies from a list created by me.
I recently found a website (mooviestats.com) that does more or less what I want, but the displayed fields are few and not allow me to export the data to a .csv file.
The idea is to compile the data from all the movies I see in a certain period of time and then process the data in my own way. Examples: Director X: 5 movies; Average runtime: 96 minutes; Director of Photography Y: 3 movies.
Reply by Devin Bayer
on May 17, 2015 at 4:36 AM
An export feature for themoviedb would make me much more comfortable using it.
Reply by nefycee
on January 8, 2016 at 7:24 AM
+1
Reply by Travis Bell
on January 8, 2016 at 11:12 AM
My plan is to get to this sometime this year. I have a lot of things on my plate currently ;)
Reply by harlanchen
on July 13, 2016 at 7:08 AM
+1
Reply by blizeH
on February 8, 2018 at 9:59 AM
Hi, is there any update on this please? :) I've just imported my information from IMDB and love the site, but I'm also a little worried that if I start adding more things to my watchlist/rated etc I won't be able to move them again if I have to :(
Reply by pwhinson
on May 21, 2018 at 2:41 PM
Ditto to blizeH
Reply by gilllance
on January 12, 2019 at 5:07 PM
I'm actually interested in this as well.
Reply by Travis Bell
on January 12, 2019 at 5:20 PM
Being able to export your watchlist, rated and favourite lists was added back at the end of August. Just click the options link on any of your lists. Example here.
Reply by gilllance
on January 12, 2019 at 5:39 PM
Thank you for the quick response Travis. Maybe I'm overlooking an aspect, or perhaps I'm just confused how APIs work. I tried the way you suggested, but am not getting the level of data I'm hoping for. The first comment on tfhis thread asked, "The idea is to compile the data from all the movies I see in a certain period of time and then process the data in my own way. Examples: Director X: 5 movies; Average runtime: 96 minutes; Director of Photography Y: 3 movies." Is this available to do with a list I've created? Would be great if it saved the Trailer and poster links as well.
Reply by Travis Bell
on January 12, 2019 at 5:53 PM
I don’t have any current plans to offer an export with that kind of information. That’s more of a personal data aggregation feature than it is a list export.
As it stands right now the only thing you can export is your 3 accounts lists.
Having said all that, someone could certainly build this personal aggregation with the list of items found in the export. So you’re kind of half way there.
Reply by PT 100
on January 12, 2019 at 8:41 PM
There are many software solutions that will aggregate data exported from TMDb. Some are expensive and intended to manage very large data sets (such as the package I own). But there are free, open-source tools that will aggregate exported data as well. And Microsoft Excel has a built-in aggregate function. If you have access to Excel, you can import a .csv file and aggregate whatever fields you wish.
Reply by gilllance
on January 12, 2019 at 11:11 PM
That’s extremely helpful. Thank you. I actually have a large set of movies. Mind me asking what program you use?
Reply by PT 100
on January 12, 2019 at 11:25 PM
Among other things, I'm a professional data-mining consultant, so I usually use a statistical software package called SPSS (now owned by IBM) for data preparation/aggregation and advanced multivariate statistical modeling/analysis on very large "big data" databases (thousands or millions of cases). I tend to use Excel not for data aggregation but for operations research analyses, such as linear programming/process optimization, etc.
SQL, a database management language (e.g., Oracle, MySQL, PostgreSQL, etc.), can also be used to aggregate data from databases. Usually it is used on relational databases, not "flat files" (simple two-dimensional databases or single data tables such as .csv files).