CSV Import Field Formatting Guide

📋 Quick Start: Download the CSV template from the import dialog first - it shows the exact formats you need to use!

🎯 Critical Field Formats

These fields have specific formatting requirements that must be followed exactly:

Card Condition

Use lowercase with hyphens:

✅ CORRECT:
near-mint very-good excellent mint good fair poor
❌ INCORRECT:
Near Mint Very Good Near-Mint MINT
Use This FormatDisplays As
near-mintNear Mint
very-goodVery Good
excellentExcellent
mintMint
goodGood
fairFair
poorPoor

💰 Currency Fields

currentValue & purchasePrice

Use numbers without dollar signs or commas:

✅ CORRECT:
1500.00 25.99 100 0
❌ INCORRECT:
$1,500.00 $25.99 1,500 N/A

✅ Boolean Fields (True/False)

isRookieCard, hasAutograph, hasJersey, isGraded, favorite

Use lowercase true/false:

✅ CORRECT:
true false
❌ INCORRECT:
True FALSE yes no 1 0

📊 Number Fields

serialNumber, productionRun

Use plain numbers (no commas, letters, or symbols):

✅ CORRECT:
123 999 1
❌ INCORRECT:
#123 1,000 123/999 N/A

Note: Leave blank if the card is not numbered.

📝 Text Fields

firstName, lastName, manufacturer, set, team, etc.

Use normal capitalization - the system will format it properly:

✅ GOOD:
Michael Jordan Topps Chicago Bulls 1996-97 Topps Chrome
✅ ALSO GOOD:
michael jordan TOPPS chicago bulls
❌ AVOID:
(leaving completely blank for required fields)

🏷️ Array Fields (Lists)

variations, tags

Separate multiple items with commas:

✅ CORRECT:
Refractor,Prizm,Short Print HOF,Bulls,Legend,Rookie
❌ INCORRECT:
Refractor; Prizm; Short Print HOF | Bulls | Legend

📅 Year Field

yearString

Support various year formats:

✅ ALL CORRECT:
1996-97 1996-1997 2023 2023-24

🔄 For Sale Status

forSaleStatus

Use exact capitalization:

✅ CORRECT:
Not For Sale For Sale For Trade Considering Incoming Sold

🏆 Grading Company

gradingCompany

Use standard abbreviations:

✅ CORRECT:
PSA BGS SGC CGC Other
⚠️ Important:
💡 Pro Tips: