2.1.2.1 Import from tables .csv, .xlsx

Suppose you have your collection (or maybe a deck) in a file of some tabular format like e.g. .csv, .xlsx, .odt.

The simplest and the most robust way to make Mtgdb.Gui use it is by using Clipboard Copy & Paste operations.

Steps to import

1. Open your file in some table editor:

   • Microsoft Excel
   • Libre Office Calc
   • Google Docs Spreadsheet
   • csv-viewer-editor webapp

2. Select 2 columns: one with card names, another with quantities, copy selection to clipboard by Ctrl + C

3. In Mtgdb.Gui use Paste menu -> Create collection from clipboard

   

Done, your collection should be loaded into Mtgdb.Gui by now.

Inspect imported cards in Mtgdb.Gui

Enable filter by collection by using Filter manager. You may also want to clear all other filters that may be hiding your cards by unchecking all filter manager buttons except the filter by collection, like in screenshot below.

How to copy & paste from Libre Office Calc

Ctrl + C works with a huge delay in Calc, so the clibpoard won't change some 5-10 seconds after you hit Ctrl + C. After that you will be able to succesfully paste into Mtgdb.Gui.

How to import csv to Google Docs Spreadsheet

Create new Spreadsheet, then from menu: File -> Import -> Upload tab -> Select your csv file.

How to preserve set code and card number

Suppose you track your collection so carefully that you have specified set code and / or card number for some of your cards. In order to keep this information in Mtgdb.Gui, convert your data to a .txt file in MTG Arena format. See details.