Card data from popular card games is easy to get if you know how.
Some sites like YGOProDeck, a Yu-Gi-Oh! card database, let you access their database if you know how to build HTML requests or a little programming. So I looked up their documentation and got coding.
In my use case, I was using Excel to build a Cube (a list of powerful cards). I had linked the card names to the card images but needed their stats and abilities to do some excel magic and analyze my distribution of card types. I also didn’t want to have to copy it myself, one at a time, so I decided to use YGOProDeck’s database.
As not to bore you with details, I’ve added images.
This is an excerpt from that Cube list.
And these were the columns I needed.
So I copied the cards’ names I needed into an empty file.
Did some coding (GitHub link below if you are curious)
Made a list of the columns I wanted (they had a different name at YGOProDeck)
Executed my code and got a CSV.
Imported the CSV into my spreadsheet.
Applied some formatting… and voila!
Of course, I had to tweak some functionality, especially for special characters like the ones in “Al-Lumi’raj”. But with some testing, I got it quite right.
If you want to give it a go or check out the code, here is the GitHub Link.