Forum Discussion
How can I pull ratings data from IMDB and place in my excel spreadsheet please?
There are some different approaches you can try.
- Web Scraping (Not Recommended)
- API (Probably there is some free API available)
- 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/
Thanks LuthiusJuliano-Petrukio
I had actually found the databases and I downloaded the
https://datasets.imdbws.com/name.basics.tsv.gz
https://datasets.imdbws.com/title.basics.tsv.gz
https://datasets.imdbws.com/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.
.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).
