I've been working on a pretty fun little Google spreadsheet. What it allows you to do is simply paste in the IMDb link to a movie (for Avatar it would be this: http://www.imdb.com/title/tt0499549/) and the sheet will then pull information about the director(s), writer(s), lead actor(s), year of release, IMDb rating, top 250 or bottom 100 ranking, and I'm currently working on grabbing the "genres" too.
It's pretty interesting, I've been doing it because I want to start cataloging all of the movies that I've seen and rate them myself while also comparing my ratings to the IMDb ones. I also have visions of eventually making it so that by simply typing in the name of an actor, director, etc. I can see all of the movies that I've seen that that person is involved with and by how much my rankings differ compared to IMDb's.
You can see what I've done so far here
But, I didn't realize that Google restricts people to only 50 "import" functions. Since each row in the sheet uses multiple "import" functions, I would reach my limit of 50 far before I'd reach the end of all the movies that I've seen. Thus, I'm turning to the internet for help. I've looked on Google and posted on forums with no success, so now I must turn to MGoBlog. I know that there are CEs that frequent this board, so I would especially appreciate your help. I'm trying to remake my spreadsheet in Excel, but I've found that the only way to make external connections to specific URLs seems to involve far too much work on my part- I have to specify what tables to import and then grab the appropriate data. Worse, there's no function that you type in to import a table, it has to be done through a wizard which means that I have to import every table individually AND keep it in the Excel file forever.
So, does anyone know of some way around this? I'm essentially looking for an Excel version of Google spreadsheet's ImportHTML/ImportXML/ImportData. All of my research seems to indicate that there's no identical function in Excel and I haven't found any workarounds will be acceptable for what I'm doing.
Any help would be appreciated. Thanks.
Note 1: I apologize for posting something OT, normally I try to avoid that but I'm just out of ideas at this point.
Note 2: If you open the Google spreadsheet link that I posted, you might see some random stuff after the first 2 lines, that's just me experimenting with whatever isn't working at the moment- currently that's either getting genres to work or finding a way to grab the whole release date and not just the year.