See step 9 for a tip on quickly filling an entire column. If you don't do this, Deckbox will display them without a condition or language, rather than applying your defaults. TIP: You most likely will also want to insert 2 more columns, named "Condition" and "Language", and fill the entire Condition column with "Near Mint" or "Good (Lightly Played)", and the Language column with "English". Important: Insert a new column (I usually prefer it after the "Name" column, but it actually doesn't matter), and type "Foil" as the header. (Yes, both columns A and B should be named Count. Important: Change the column headers as follows: Reg Qty & Foil Qty > Count, Card > Name, Set > Edition. It won't hurt the import into Deckbox, and you can then more easily re-add the notes to Deckbox by filtering this column and going through the cards. TIP: If you have any notes saved, keep the "Notes" column. TIP: To fully delete, highlight the columns, right click, and choose Delete. Major time saver! After running the macro, pick back up at Step 12.ĭelete column A ("Total Qty"), then delete the new columns E - M ("Mana Cost" - "Price Source"). NOTE: Stop here and use the macro listed below in bburrows reply. Save your file and click "Yes" at the warning. Open in Excel (I'm using 2010, so some instructions may differ). csv (either directly by manually typing it in from your file browser, or by opening the. Many people may not need every step detailed like this, but for those that do, they'll appreciate not having to ask!Ĭhange the file extension to. I apologize for the verbosity of these instructions. I've attached your converted inventory, so that you don't have to actually go through the work, unless you want to try it yourself. I just went through the following steps, and successfully imported your inventory into Deckbox.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |