Last Updated or created 2022-07-21

We love movies, and watch anything.

I’ve posted about genres:
https://www.henriaanstoot.nl/2021/03/23/movie-genres/

And we are watching the whole top 250 of imdb.

Now i wanted to have a list of movies by Actor or Director.
So i could see if there are more movies i have to watch
So today i started to figure out how.

So i made a Google Sheet and scraped websites with the needed information.

• Create a new sheet
• Make a tab for top-dutch, actor or director
• Do a search of things you want to display
• A search of actor and filmography will probably work (imdb of wikipedia)
• copy the url and make a note of which table it is, first second or more.
• Paste in the sheet the following at A1

=IMPORTHTML("https://en.wikipedia.org/wiki/Rutger_Hauer_filmography","table",1)

Where the last number (this case 1) is the number of table in the page.

Now you can color code those entries.