Which, by the way, is how you auto populate the data. I also made sure the movie titles are column A so vlookup works. After I took out those entries and converted it to an. I removed things like shorts, TV episodes (there also TV Shows, episodes is literally each individual episode from every show), video games, et cetera. Here's the link for where you can download the datasets from IMDb.īe warned though, they're huge! The basics one is 129 MB zipped, and 621 MB uncompressed. That could be cool, but I usually don't care what ratings a movie gets. IMDb has other datasets, like if you wanted to include ratings. You can use the same formula to search IMDb simply by changing the first part of the URL, like this.Ĭode: Select all =HYPERLINK(""&A2&"&exact=true","IMDb")Įdit: I found it better to add "exact=true" to the IMDb search URL. You can even omit that last part of the formula and the hyperlink will just be the URL.Ĭode: Select all =HYPERLINK("" &A2 &" (film)", "Search Wikipedia") You can make "Search Wikipedia" say whatever you want, that's just what will display in the cell. Just replace "A2" with whatever column your movie title is in, if it isn't A. Anyway, it's real easy, you just modify the search URL. You could easily do the same thing for a search with IMDb instead, but I don't know how to make IMDb jump straight to the correct result, just return the standard search query. I've tested a couple dozen so far and some of them do not go straight to the correct page, but instead it'll go to the search results page and the correct article is always the first or second link. Basically, if you add "(film)" to the end of the movie title and search that on Wikipedia, it almost always lands right on the correct article. I'm going to have a Wikipedia link for every entry, and these will also auto populate simply by entering the movie title. If I don't include directors and actors, it wont matter much. Like, "I feel like watching something with Tom Hanks in it." Or, "I feel like watching a John Hughes movie." I'm not sure yet if I want to include this or not, sometimes having too much data makes it hard to look at. It might be neat to sort by director or actor. There's more than enough horizontal space to fit other columns, so I'm thinking about doing columns for director and top billed actors. Like, "I'm in the mood for a comedy, let me see what I have." As for genres, I really want them included so I can sort by genre to help find something to watch. I'm always curious to know the release year and runtime (and I hate when it's impossible to find on the back cover). While not as bad as my Backloggery, I still own plenty of movies that I've never seen.Īs for the fields that'll auto populate, I'm going to have release year, runtime and genre(s). I might also make a column to note if I've ever seen the movie or not. And I think I'll also have a comments field that I can note things in, like "part of box set" or something. I'll still have to manual input which format it is, but big deal. Basically, I'm going to make a table where I input the movie title and it'll auto populate all the fields for me. tsv format! If you know Excel, then you'll know this means setting things up will be mostly trivial. IMDb has datasets that you can download in. But I just found out about something awesome, and I can easily make a spreadsheet that'll auto populate most of the data for me! However, I'm certainly not about to manually get all that data for my entire collection. I could just do movie title and format (VHS, DVD, BD) to get a simple list going, but I wouldn't mind having more than that. I've toyed with the idea of just making a simple spreadsheet for a while, but I really don't want to manually input all the data. Discogs was easy for me to set up because I was able to scan the barcodes to enter almost everything, and the site is popular enough that I'm not too concerned with it disappearing any time soon. Or it might not be supported in the future and I might have to abandon it. An app might be good now, but an update might cripple it. The initial setup will take a huge investment in time, and I'm just not willing to do that if I'm not absolutely sure of it. I know there's a bunch of apps available, free and paid for, but I'm hesitant to use one. Discogs actually had a few sister sites for a while, one of them being filmogs, but they seem to have disappeared. I've been thinking about doing some sort of catalog system for a while now. As with anything, the more you have of something the harder it is to keep track of or organize it all. Maybe not so large in comparison to some people, but definitely large compared to the average person. I have a somewhat large movie collection. We seem to have quite a few people on this forum that enjoy movies, so I thought I'd share this.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |