Diabolic Tutor (Tenth Edition) x4 Quagmire Druid x 3Example 2 (Deck Classic, Count first):
4 x Diabolic Tutor 3 x Quagmire Druid
ID,NAME,COST,TYPE,POWER,TOUGHNESS,ORACLE,SET,RARITY,DBPRICE,LANG,COUNT,PRICE,COMMENT,LOCATION,CUSTOM,OWNERSHIPThis is actually Magic Assistant CSV export format. The only columns which are used are NAME, SET and user data such as COUNT, PRICE and COMMENT. All columns except NAME does not have to be present. Export data from excel into .csv file with "," or "|" separator and import it into Magic Assistant. When importing select "CSV" format (or Table Piped for "|"). Check "Data has a header row" checkbox. Without header row columns has to be exact in the order as above. Preview would show if format is matching. There is way to edit some import problems right in the import wizard. Example 3 (CSV format, no header row):
,Diabolic Tutor,,,,,,Tenth Edition,,,,4,1.99,Signed by Artist, ,Quagmire Druid,,,,,,Apocalypse,,,,2,0.15,, ,Swamp,,,,,,Tenth Edition,,,,16,0.15,,Example 4 (CSV format, header row):
ID,NAME,COST,TYPE,POWER,TOUGHNESS,ORACLE,SET,RARITY,DBPRICE,LANG,COUNT,PRICE,COMMENT,LOCATION,CUSTOM,OWNERSHIP
129525,Diabolic Tutor,{2}{B}{B},Sorcery,,,Search your library for a card and put that card into your hand. Then shuffle your library.,Tenth Edition,Uncommon,1.99,,4,0.0,,,,false
27188,Quagmire Druid,{2}{B},Creature - Zombie Druid,2,2,"{G}, {T}, Sacrifice a creature: Destroy target enchantment.",Apocalypse,Common,0.15,,2,0.0,,,,false
129757,Swamp,,Basic Land - Swamp,,,[B],Tenth Edition,BasicLand,0.15,,16,0.0,,Decks/Thrull Breader & Demon.xml,,false
Note that for CSV format if field has "," it is it has to be in quotes.
Piped Table format is the same as CSV but using | as separator and ignoring the quotes.
Example 5 (Table Piped format, no header row):
|Diabolic Tutor||||||Tenth Edition||||4 |Quagmire Druid||||||Apocalypse||||2Example 6 (Table Piped format, header row):
NAME|SET|COUNT Diabolic Tutor|Tenth Edition|4 Quagmire Druid|Apocalypse|2