Regional Pokedex Comparison

This is just for convenience in the future, because most dex comparisons I've found are just general numbers, but I want to know about specific pokemon and where they are found. Let's see if I can teach myself enough about spreadsheets to make it work.

Red/Blue Gold/Silver Ruby/Sapphire Diamond/Pearl Black/White X/Y Sun/Moon Sword/Shield Scarlet/Violet
#0001 Bulbasaur
#0002 Ivysaur
#0003 Venusaur
#0004 Charmander
#0005 Charmeleon
#0006 Charizard
#0007 Squirtle
#0008 Wartortle
#0009 Blastoise
#0010 Caterpie
#0011 Metapod
#0012 Butterfree
#0013 Weedle
#0014 Kakuna
#0015 Beedrill
-