If anybody is interested in figuring out how to import from a spreadsheet and not deal with the hassle of figuring out how the website will take it, here it is:
Id,CardName,NumberOwned,Expansion,Pack,Rarity
A1-1,Bulbasaur,8,A1,mewtwo,♢
A1-2,Ivysaur,4,A1,mewtwo,♢♢
A1-3,Venusaur,3,A1,mewtwo,♢♢♢
A1-4,Venusaur ex,0,A1,mewtwo,♢♢♢♢
A1-5,Caterpie,6,A1,pikachu,♢
A1-6,Metapod,4,A1,pikachu,♢
A1-7,Butterfree,2,A1,pikachu,♢♢♢
A1-8,Weedle,5,A1,mewtwo,♢
A1-9,Kakuna,5,A1,mewtwo,♢
A1-10,Beedrill,1,A1,mewtwo,♢♢♢
A1-11,Oddish,8,A1,charizard,♢
A1-12,Gloom,3,A1,charizard,♢♢
A1-13,Vileplume,3,A1,charizard,♢♢♢
A1-14,Paras,2,A1,pikachu,♢
A1-15,Parasect,5,A1,pikachu,♢♢
A1-16,Venonat,4,A1,mewtwo,♢
A1-17,Venomoth,3,A1,mewtwo,♢♢
A1-18,Bellsprout,5,A1,charizard,♢
A1-19,Weepinbell,5,A1,charizard,♢♢
A1-20,Victreebel,1,A1,charizard,♢♢♢
A1-21,Exeggcute,8,A1,charizard,♢
A1-22,Exeggutor,1,A1,charizard,♢♢♢
A1-23,Exeggutor ex,1,A1,charizard,♢♢♢♢
A1-24,Tangela,3,A1,charizard,♢
A1-25,Scyther,6,A1,mewtwo,♢
A1-26,Pinsir,9,A1,all,♢♢
A1-27,Cottonee,10,A1,all,♢
A1-28,Whimsicott,10,A1,all,♢♢
A1-29,Petilil,15,A1,all,♢
A1-30,Lilligant,7,A1,all,♢♢
A1-31,Skiddo,3,A1,charizard,♢
A1-32,Gogoat,4,A1,charizard,♢
A1-33,Charmander,4,A1,charizard,♢
A1-34,Charmeleon,5,A1,charizard,♢♢
etc…
THE HEADER IS VERY IMPORTANT! The website won’t take the .csv unless you have the header.
Make sure that for the packs that say ___ ex, you need to remove the ex.
I would also highly recommend using the sheets SPLIT() function, as that gets rid of the extra zeros after splitting and lets you add a dash between the id and the number.