Forum Discussion
How can I pull ratings data from IMDB and place in my excel spreadsheet please?
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).