if I wanted to create an excel spreadsheet for all artworks of one specific illustrator, say, Aya Kusube, using Bulbapedia’s Kusube page as source. How would I go about doing this in the least time consuming, most efficient way?
Is there some pro gamer move that lets me extract the names directly from the page into an excel sheet? An added (huge) bonus would be if I could directly order them by release date.
If there isn’t any way besides straight up typing it into a sheet myself, then so be it. Just wanted to ask here before I spend many hours on possibly unnecessary work.
I have no idea about programming whatsoever, so any and all help would be highly appreciated!
When I made my Mizue spreadsheet I did it all manually so that I could sort it however I wanted without having to redo it, so I can’t help with your main question
but I did want to mention that the Bulbapedia page was missing a couple illustrations and can also trip you up if you’re not careful. For example, her sheet shows 1 Dragonair illustration, but if you go to the page then you see that there’s actually 2 by her under the same card page.
I also came across a couple of cards that has multiple entries under the same page with multiple different artists where the main card featured at the top of the page was not the one I was looking for.
I got a complete list by looking at a combination of both the bulbapedia page and the serebii page (yea it turns out that serebii has illustrator info too) www.serebii.net/card/dex/artist/mizue.shtml
@nish, thanks a lot for that info! Sadly, that makes the project even more complicated and more unlikely that there is an easy way around doing it manually. Oh, well.
I did all of mine manually, using pkmncards as a quick setup for a release order list of the base prints for every English release. Then I went to Bulbapedia to find any cards that didn’t get an English release and to scour the individual card pages of every card to look for any non-standard variant prints.
It can be very time-consuming, and even using this method I’ve stumbled onto yet more variant prints that I had somehow missed or were not listed on the individual Bulbapedia card pages (WCD prints and Battle Academy prints, for example).
It’s a lot of work, but creating and maintaining a good spreadsheet is rewarding in its own way.
Thanks man, I know and love that site for its convenience, but sadly they completely lack all Japanese exclusive artworks
Also, thank you @llyrwenne! I think I’ll just have to bite the bullet and do it myself. Thanks for sharing your method, that sounds pretty good and even somewhat fun (at least not terrible )
I was about to suggest Serebii as well. I believe that you can find cards on Serebii either by the set or by a specific Pokemon. I am not sure if Serebii has a list of all of the card by a specific artists, though I could be wrong.
)