How can I pull ratings data from IMDB and place in my excel spreadsheet please?

%3CLINGO-SUB%20id%3D%22lingo-sub-1612418%22%20slang%3D%22en-US%22%3EHow%20can%20I%20pull%20ratings%20data%20from%20IMDB%20and%20place%20in%20my%20excel%20spreadsheet%20please%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612418%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20Excel%20spreadsheet%20of%20all%20my%20films%20I%20own%20and%20I%20wanted%20to%20create%20extra%20columns%20for%20year%20and%20IMDB%20rating.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20quick%20(and%20easy)%20way%20of%20scraping%20the%20year%20and%20rating%20from%20IMDB%20and%20placing%20it%20in%20my%20spreadsheet%20without%20the%20need%20to%20visit%20each%20film%20and%20manually%20type%20it%20in.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20rating%20is%20the%20main%20goal%20here%2C%20but%20having%20the%20year%20also%20would%20be%20a%20bonus.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20am%20not%20that%20knowledgeable%20about%20Xcel.%20I%20know%20the%20basics%20well%20but%20am%20not%20too%20advanced%20so%20it%20would%20need%20to%20be%20relatively%20easy%20to%20do.%20i.e.%20through%20the%20excel%20menus.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612458%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20pull%20ratings%20data%20from%20IMDB%20and%20place%20in%20my%20excel%20spreadsheet%20please%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612458%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F771226%22%20target%3D%22_blank%22%3E%40JANNER66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20some%20different%20approaches%20you%20can%20try.%3C%2FP%3E%3COL%3E%3CLI%3EWeb%20Scraping%20(Not%20Recommended)%3C%2FLI%3E%3CLI%3EAPI%20(Probably%20there%20is%20some%20free%20API%20available)%3C%2FLI%3E%3CLI%3EDownload%20the%20database%20straight%20from%20the%20IMDB%20website.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EFor%20the%20last%20option%2C%20that%20I%20recommend%20you%20just%20need%20to%20import%20it%20to%20your%20excel%20file.%3C%2FP%3E%3CP%3EInformation%20about%20the%20data%20format%20and%20types%20(%3CA%20href%3D%22https%3A%2F%2Fdatasets.imdbws.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdatasets.imdbws.com%2F%3C%2FA%3E)%3C%2FP%3E%3CP%3EDatasets%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdatasets.imdbws.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdatasets.imdbws.com%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612632%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20pull%20ratings%20data%20from%20IMDB%20and%20place%20in%20my%20excel%20spreadsheet%20please%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612632%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Luthius%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40luthius%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20actually%20found%20the%20databases%20and%20I%20downloaded%20the%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdatasets.imdbws.com%2Fname.basics.tsv.gz%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ename.basics.tsv.gz%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdatasets.imdbws.com%2Ftitle.basics.tsv.gz%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Etitle.basics.tsv.gz%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdatasets.imdbws.com%2Ftitle.ratings.tsv.gz%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Etitle.ratings.tsv.gz%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20really%20sure%20how%20to%20import%20these%20files%20into%20the%20spreadsheet%20in%20a%20meaningful%20way.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20went%20to%20DATA%20-%20FROM%20WEB%20and%20then%20located%20these%20files.%20It%20just%20populated%20some%20random%20words%20here%20and%20there%20though.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20see%20how%20else%20you%20would%20import%20these%20files.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1613009%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20pull%20ratings%20data%20from%20IMDB%20and%20place%20in%20my%20excel%20spreadsheet%20please%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613009%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F771226%22%20target%3D%22_blank%22%3E%40JANNER66%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E.gz%20files%20are%20UNIX%20archives%2C%20first%20you%20shall%20extract%20files%20from%20such%20archives%2C%20on%20Windows%20using%207zip%20or%20like%20utility.%3C%2FP%3E%0A%3CP%3EWithin%20it%20will%20be%20.tsv%20files%20(tab%20separated%20values)%20which%20you%20could%20import%20into%20Excel%20with%20Power%20Query%20or%20by%20legacy%20From%20text%20utility%20using%20tab%20as%20separator%20(in%20general%20it%20shall%20be%20recognized%20automatically).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone,

 

I have an Excel spreadsheet of all my films I own and I wanted to create extra columns for year and IMDB rating. 

 

Is there a quick (and easy) way of scraping the year and rating from IMDB and placing it in my spreadsheet without the need to visit each film and manually type it in. 

 

The rating is the main goal here, but having the year also would be a bonus. 


I am not that knowledgeable about Xcel. I know the basics well but am not too advanced so it would need to be relatively easy to do. i.e. through the excel menus. 

 

Thanks very much.

3 Replies
Highlighted

@JANNER66 

There are some different approaches you can try.

  1. Web Scraping (Not Recommended)
  2. API (Probably there is some free API available)
  3. Download the database straight from the IMDB website.

For the last option, that I recommend you just need to import it to your excel file.

Information about the data format and types (https://datasets.imdbws.com/)

Datasets https://datasets.imdbws.com/

 

 

 

Highlighted

Thanks Luthius@Juliano-Petrukio 

 

I had actually found the databases and I downloaded the 

name.basics.tsv.gz

title.basics.tsv.gz

title.ratings.tsv.gz

 

I'm not really sure how to import these files into the spreadsheet in a meaningful way. 

 

I went to DATA - FROM WEB and then located these files. It just populated some random words here and there though. 

I can't see how else you would import these files. 

Highlighted

@JANNER66 

.gz files are UNIX archives, first you shall extract files from such archives, on Windows using 7zip or like utility.

Within it will be .tsv files (tab separated values) which you could import into Excel with Power Query or by legacy From text utility using tab as separator (in general it shall be recognized automatically).