The format is fairly simple:
The first line must contain your Nostomania username (in column A, if you're using a spreadsheet.)
The second line contains two fields. The first field (in spreadsheet column A) is the collectible category for this data, either coins, comics, or magazines. The second field is the destination list, which is either collection, salelist, or wantlist (in spreadsheet column B.)
The format of the remaining lines depends on what you specified on the second line, since each category/list combination has a slightly different format. All fields need to be listed in the CVS file, but not all fields need to have data in them. The fields that must have data in them are marked with REQ, while fields that can be empty are marked with OPT. Each field should go in a separate column if you're using a spreadsheet. The format for magazines examples is the same as comics.
- coin collection
- series (REQ), issue (REQ), grade (REQ), quantity (OPT, defaults to 1), certification (OPT, defaults to None), price paid (OPT), date acquired (OPT), location (OPT), notes (OPT) Go to example
- coin salelist
- series (REQ), issue (REQ), grade (REQ), quantity (OPT, defaults to 1), certification (OPT, defaults to None), sale price (OPT), sale percent (OPT, defaults to MyAccount default), price paid (OPT), URL (OPT), description (OPT) Go to example
- coin wantlist
- series (REQ), issue (REQ), quantity (OPT, defaults to 1), certified coins only (OPT, defaults to False), offer price (OPT), perfect proof (PF70) offer percent (OPT, defaults to MyAccount), proof (PF60) offer percent (OPT, defaults to MyAccount), perfect uncirculated (MS70) offer percent (OPT, defaults to MyAccount), uncirculated (MS60) offer percent (OPT, defaults to MyAccount), choice about uncirculated (AU55) offer percent (OPT, defaults to MyAccount), about uncirculated (AU50) offer percent (OPT, defaults to MyAccount), choice extremely fine (EF45) offer percent (OPT, defaults to MyAccount), choice very fine (VF30) offer percent (OPT, defaults to MyAccount), fine (F12) offer percent (OPT, defaults to MyAccount), very good (VG8) offer percent (OPT, defaults to MyAccount), good (G4) offer percent (OPT, defaults to MyAccount), about good (AG3) offer percent (OPT, defaults to MyAccount) Go to example
- comic collection
- title (REQ), year title started publication (REQ if there is more than one title with this name, OPT otherwise), issue (REQ), grade (REQ), quantity (OPT, defaults to 1), certification (OPT, defaults to None), restoration (OPT, defaults to None), price paid (OPT), date acquired (OPT), location (OPT), notes (OPT), page_quality (OPT, defaults to Unspecified), Go to example
- comic salelist
- title (REQ), year title started publication (REQ if there is more than one title with this name, OPT otherwise), issue (REQ), grade (REQ), quantity (OPT, defaults to 1), certification (OPT, defaults to None), restoration (OPT, defaults to None), sale price (OPT), sale percent (OPT, defaults to MyAccount default), price paid (OPT), URL (OPT), description (OPT) Go to example
- comic wantlist
- title (REQ), year title started publication (REQ if there is more than one title with this name, OPT otherwise), issue (REQ), quantity (OPT, defaults to 1), certification only (OPT, defaults to False), restoration allowed (OPT, defaults to None), offer price (OPT), mint (MT) offer percent (OPT, defaults to MyAccount default), near mint (NM) offer percent (OPT, defaults to MyAccount default), very fine (VF) offer percent (OPT, defaults to MyAccount default), fine (FN) offer percent (OPT, defaults to MyAccount default), very good (VG) offer percent (OPT, defaults to MyAccount default), good (GD) offer percent (OPT, defaults to MyAccount default), fair (FR) offer percent (OPT, defaults to MyAccount default), poor (PR) offer percent (OPT, defaults to MyAccount default) Go to example
The following are example CVS files for each of the category/list combinations:
- coin collection example
-
username coins,collection "small one-cent pieces, flying eagle",1857,VG-8,2,,$10,"Jan 3, 2001",, "Small One-Cent Pieces, Flying Eagle",1858 Large Letters,MS-63,,ANACS,$250.00,1/3/2001,box 7,bought from Tim Sacagawea Dollars,2000S Proof,PF-68,1,PCGS,$10,,, Sacagawea Dollars,2003P,AU-55,,,,,, - coin salelist example
-
username coins,salelist "small one-cent pieces, flying eagle",1857,VG-8,2,,$10,,$5,http://www.anysite.com/my.jpg,low grade but nice "Small One-Cent Pieces, Flying Eagle",1858 Large Letters,MS-63,,ANACS,,90,$250,,beautiful item Sacagawea Dollars,2000S Proof,PF-68,1,PCGS,$10,,,, Sacagawea Dollars,2003P,AU-55,,,,,,, - coin wantlist example
-
username coins,wantlist "small one-cent pieces, flying eagle",1857,2,True,$100,,,90,90,85,85,75,75,0,0,0,0 "Small One-Cent Pieces, Flying Eagle",1858 Large Letters,,,,,,100,100,100,100,100,100,100,100,100,100 Sacagawea Dollars,2000S Proof,1,True,$10,70,70,,,,,,,,,, Sacagawea Dollars,2003P,,,,,,,,,,,,,,, - comic collection example
-
username comics,collection strange worlds,1950,1,VG/FN,,None,None,180.35,2/3/2002,long box 7,great cover,White Strange Worlds,1958,1,VF-,1,CGC,Slight,100,"Feb 3, 2002",long box 7,small color touch, Zap Comix,,1 2nd printing,VG,,,,$150,,,bought from Mark,Cream Zap Comix,,8,VF+,,,,,,,, - comic salelist example
-
username comics,salelist strange worlds,1950,1,VG/FN,2,None,None,$200,,$180,http://www.anysite.com/my.jpg,low grade but nice Strange Worlds,1958,1,VF-,1,CGC,Slight,,20,$100,,small color touch Zap Comix,,1 2nd printing,VG,,,,$150,,$150,, Zap Comix,,8,VF+,,,,,,,, - comic wantlist example
-
username comics,wantlist strange worlds,1950,1,2,False,None,$200,90,90,80,0,50,50,0,0 Strange Worlds,1958,1,1,True,Slight,,100,100,100,100,100,100,100,100 Zap Comics,,1 2nd printing,,,,$150,,,,,,,, Zap Comics,,8,,,,,,,,,,,, - magazine collection example
-
username magazines,collection Famous Monsters of Filmland,1958,1,FN,,None,None,150.00,2/3/2002,Short Box 1,bought from Chris Playboy,1953,V2 #9,NM+,1,CGC,None,100,"Feb 3, 2002",long box 7,great cover - magazine salelist example
-
username magazines,salelist Satan,1957,2,GD,1,None,None,$200,,$180,http://www.anysite.com/my.jpg,low grade but nice Spacemen,1961,1,VF-,1,CGC,Slight,,20,$100,,small color touch - magazine wantlist example
-
username magazines,wantlist Barbarella,1968,1,2,False,None,$200,90,90,80,0,50,50,0,0 Barbarella 1 2nd printing,1968,1,1,True,Slight,,100,100,100,100,100,100,100,100