Importing a csv from MTGO
Posted: 07 Jan 2012, 10:25
Could someone post the quickest and easiest way to import a csv from MTGO into MA?
Edit: Found it out finaly
1. Don't open a file in Excel but make a new file.
2. Import the csv file and choose "," as seperater instead of "tab".
3. Rearange the columns as folows: Set, Card Name, Empty [MTGO soesnt export the version number of a card], Online, Empty [if you don't have foils] then add 0 value for foils.
OR
Set, Card Name, Empty [MTGO doesn't export the version number of a card], Empty, Online [for foiled cards] then add 0 value for nonfoils.
4. For cards with multiple versions (exp. Basic Lands) add the value for Version. Exp. first Swamp add 1, second add 2 etc.
5. Delete the rest columns.
6. Replace the Set names - from ISD to Innistrad for example.
7. Delete the first row - Set, Card name etc.
8. Paste your data into the Import Example.csv in the Magic Album/Help folder.
9. Go to MA and import the Import Example.csv file.
10. That's it!
Flip cards will not be added. You have to add them manualy.
Edit: Found it out finaly
1. Don't open a file in Excel but make a new file.
2. Import the csv file and choose "," as seperater instead of "tab".
3. Rearange the columns as folows: Set, Card Name, Empty [MTGO soesnt export the version number of a card], Online, Empty [if you don't have foils] then add 0 value for foils.
OR
Set, Card Name, Empty [MTGO doesn't export the version number of a card], Empty, Online [for foiled cards] then add 0 value for nonfoils.
4. For cards with multiple versions (exp. Basic Lands) add the value for Version. Exp. first Swamp add 1, second add 2 etc.
5. Delete the rest columns.
6. Replace the Set names - from ISD to Innistrad for example.
7. Delete the first row - Set, Card name etc.
8. Paste your data into the Import Example.csv in the Magic Album/Help folder.
9. Go to MA and import the Import Example.csv file.
10. That's it!
Flip cards will not be added. You have to add them manualy.