3

Is there a way to obtain a detailed list from WotC’s The Gatherer of magic cards? What I am looking for is a way to enter a list of magic cards and to get a print off of the card details in a nice rowed format, something that I can cut and copy directly into Sheets or MS Excel.

Name  – Cost – Type     -  Text       -  P/T

Name1 – 1W   – Creature – Flying      – 1/1
Name2 –  U   – Instant  – Draw a Card – “”
...

I see one of the Gatherer’s default displays is Text only, but the layout it uses is very scattered and not copy-paste friendly. Any work-arounds for that are also acceptable answers.

  • Personally I download the list in a txt format after inputting it in deckstats.net, but this does not seem to justify making a full answer, so I'm putting it here – CollinB Nov 22 '19 at 15:38
  • Possible duplicate of boardgames.stackexchange.com/q/31870/10354 – JonTheMon Nov 22 '19 at 15:43
  • 1
    @JonTheMon Nasher's question is practically the exact opposite of this. He was looking for just a list of cards with Name-Only, specifically calling out that he did not want to see Mana Costs or Text. This question is definitely looking to include those. Looking through the answers he received might show what I am looking for thou, so I'll review those. – L.P. Nov 22 '19 at 15:49
  • 1
    @L.P. if you are fine getting them from Scryfall then the second answer explains how to get a csv which is easy to import into Sheets or Excel. On import you can eliminate the columns you don't want. – CALEB F Nov 22 '19 at 16:17
  • 1
    The CSV format allows for commas in values. – murgatroid99 Nov 22 '19 at 21:11
3

The most complete collection of card data I'm aware of is mtgjson, which offers a variety of data structuring to choose from, and has everything you asked for. It is used by a number of MtG-themed web pages, and due to its structure is well-suited for both applications, and purposes such as yours.

However, to get it into a layout of your choice, you'd have to parse the data and write a script to output it, which might not be feasible for everyone.


Another option would be Gatherer Extractor, a tool to extract pictures and text data from Gatherer (WotC's official card database) and according to that thread export as CSV or XML.

Unfortunately, the thread I could find and download are dubious at best, and the Github page is quite dated, making it difficult at best to decide on the trustworthyness on either.

  • 1
    A quick google search for "excel import json" turns up this support page, so using the JSON from mtgjson may not be all that hard. – Miles Budnek Nov 23 '19 at 15:59
  • 1
    Got the json file, and just used an online converter to change it from Json to CSV. There's lots of extra junk in the data, but it's easily cleaned up using Excel. – L.P. Nov 25 '19 at 16:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.