MTG Complete(?) Card list spreadsheet

12 posts / 0 new
Last post
Hi

I've created a spreadsheet containing 19,597 cards, listing their colour, rarity and set, which I compiled from the Gatherer section on the Wizards website.

There are columns for mana cost and the number owned.  Mana cost is only completed for around 300 cards.
Finally there is a key of the set symbols.

It's a little bit of a work in progress but if anyone would find this useful let me know and I can send you a copy.
Happy to take suggestions for improvements too.

Thanks

Tom


Why would this be more useful than Gatherer?
Embrace imagination. Lord of YMtC | Ten Rounds Contest Winner Solphos – A fan set with a 'combo matters' theme Fool's Gold – The second set of the Solphos block
More
Each of its nine tails is imbued with supernatural power, and it can live for a thousand years. My Standard deck: Setting Sun
108516289 wrote:
Think of how Neo couldn't beat the robots, but they kept him around anyways to defeat Agent Smith. Sure, the robots might not like having a Neo running rampant because instead of playing their favorite 4 drop fatty robot, they have to play a bunch of one mana Matrixs to contain him, but at least Neo keeps Agent Smith from reanimating an Iona on turn two.
139359831 wrote:
Are you saying I'm trying to blame my loss on something? I don't care that I lost, I care that he's a sore loser, and a cheater, and a liar.
144902215 wrote:
CKY, are you bad at anything?
144902215 wrote:
I really enjoy imagining this from Kevin's perspective. Because in Kevin's world, Rosewater actually reads everything he types. Mark is sitting there right now, reading this, and thinking "The greatest trick the devil ever pulled. . ." Or some such. He chuckles low, then clicks on "The Best Of KEVINSET" and says "Yes, this'll do just fine. A busty lady with banding who deals direct damage to Zones!? Why this will be the star of my next set, and no one will ever believe you Kevin." Then he closes his Macbook, so his servant may move it out of the way, while another servant puts a Fetal Richard Garfield Clone lathered in Steak Sauce in front of him. Then Mark Feasts. I mean, In KevinWorld, Mark is reading the very words I'm typing as well. Heck, in KevinWorld maybe I am Mark.
99964981 wrote:
I'm beginning to think CKY may be anime in real life...
57150868 wrote:
Don't go anywhere CKY, I need to crash dramatically through your window and propose marriage and I don't want you throwing off my paradrop.
63588923 wrote:
[In response to a thread about how hard grading is] Upon reading this, I've found myself completely unable to operate in the world. I tried to decide what to eat for breakfast, and pondered the vast consequences of my choice. How do I balance my dietary needs against my desire to eat good-tasting food? Should I factor in how long it takes to prepare? Cereal is ready in moments, but bacon takes longer to cook. Then there is the impact on other industries. Do people in the cereal industry deserve to be employed more than people in the bacon industry? Which industry should I support? I don't even have the data regarding HOW MUCH the cereal industry benefits from me eating a bowl of cereal, or how much the bacon industry benefits from me eating a side of bacon. How can I compare two qualities I can't even quantify? And let's not forget the milk on the cereal. In addition to determining whether or not milk is healthy for me, how much that benefits the milk industry, and how much the people in the milk industry deserve my support, we have to factor in the fact that cows are put under brutal conditions in order to collect thier milk. Of course, the same goes for the pigs, and then they get killed. Of course, I really like bacon. So I need to come up with a scale that compares the value of cow happiness to pig happiness to my happiness. What trade-offs am I willing to make here? Does the fact that the pig gets put out of its misery count as a plus or a minus? Isn't bacon bad for me anyway? Deciding what to eat for breakfast (or any meal) is impossible. Help me!
104339228 wrote:
I must admit chinkeeyong, you have the most interesting character ideas; and you play them well.
144902215 wrote:
Anyway, you'd be surprised about Time Stop. When I first saw that card as a relatively new player I didn't see its full potential until I read the reminder text. Is it that unintuitive, though? Mine I mean. What is possibility? Is it possible for me to type these words with my tusks? No, because I don't have tusks. Although I am now tempted to go buy some - obviously not from poachers or whatever - and use them as typing apparatus. I could be the best secretary ever. "What's your words per minute sir?" "Well, only six, but I use these tusks to type them." "You're hired!" That was the interview. And is anyone else disappointed that "apparati" is not the plural form of apparatus? I just could strangle a dictionary, because "apparatuses" is a real word. I guess it sounds pretty cool. I'll call them my Apparatusks.
Gatherer doesn't act as an inventory for your cards? You can note which cards you use in different decks and filter them.
I am in the beginning stages of making one of these myself. I would inturn upload it to the internet for anyone to use!

MagicRookie 
I'm finding mine useful already. I can filter it down to only show certain decks I have created. I can log any decks I try out and refine them easily!
I would find this extremely useful. Is the OP still working on it? If so, I'd like a copy.
Last post in this thread, besides you, was from a month ago. I'm positive they haven't been back to this forum since.
They posted two weeks ago.

please post cards in my threads they are special places to me

All restraints upon man's natural liberty, not necessary for the simple maintenance of justice, are of the nature of slavery, and differ from each other only in degree. -Lysander Spooner - "Trial by Jury" (19th century)

If you are unhappy with the recent update, especially if you are leaving or are thinking of leaving, please email me at gameostasis@gmail.com so we can talk about a solution. 

Please feel free to copy this message into your sig.

July 9th was two weeks ago? Huh, time paradox.
Well, if Octo comes back, I'd like to sign up for a copy.

IMAGE(http://i247.photobucket.com/albums/gg152/jdealer90/RandomAnimal.jpg)

please post cards in my threads they are special places to me

All restraints upon man's natural liberty, not necessary for the simple maintenance of justice, are of the nature of slavery, and differ from each other only in degree. -Lysander Spooner - "Trial by Jury" (19th century)

If you are unhappy with the recent update, especially if you are leaving or are thinking of leaving, please email me at gameostasis@gmail.com so we can talk about a solution. 

Please feel free to copy this message into your sig.



It's a little bit of a work in progress but if anyone would find this useful let me know and I can send you a copy.




Sorry to crush your hopes and dreams, and the possible threadjack, but I've got a complete version available for download.
Mine's in two pieces though: CardsByName and CardsBySet.  The first contains static info (name, mana cost, rules text) and the second contains info that varries by printing (artist, rarity) 

Check the link in my sig. (See Developer's Tools)


Feel free to download and repurpose it, that's why its there.  It should save you quite a bit of time. 

Casual Magic player since 2003 (Onslaught Block). 60% Johnny, 40% Timmy. Want a free, graphics-based, collection database to inventory your cards? I made one! Feedback welcome. Program runs offline, includes powerful search options, art, Oracle text, data import/export, and a rigorously updated list of every card ever printed. Version 5.13 (Theros) now available!

So. Green needs an iconic creature type, eh? How about wurms!

One Billion Words - 1001 Fantasy Landscapes: Share DnD-ish landscapes for use in homebrew campaigns!