Most LEGO resellers start with a basic spreadsheet to track their minifigure collections. You punch in set numbers, piece counts, and maybe some rough values from BrickLink. But after your first few bulk purchases, that simple sheet becomes a nightmare. Manually entering hundreds of figures takes hours, values go stale, and you lose track of what's actually profitable. Smart resellers build collection trackers that scale with their business, not against it.
Essential columns for your LEGO collection tracker
Your spreadsheet needs these core columns to track resale value effectively. Start with Set Number, Figure Name, Condition (New/Used/Missing Parts), Current BrickLink Average, Your Cost, Quantity On Hand, and Total Value. Add a Profit Margin column that calculates automatically. Include a Location field so you can actually find your inventory when orders come in.
Setting up automated value updates
Manual price updates kill productivity. Link your key figures to BrickLink's API or use IMPORTXML functions in Google Sheets to pull current market prices. Set this to refresh daily for your high-volume pieces. For bulk resellers moving 100+ figures monthly, stale pricing data costs real money. Your tracker should work for you, not trap you in endless data entry.
Tracking condition and completeness
Condition drives value more than any other factor in LEGO reselling. Create dropdown menus for standard conditions rather than typing freeform notes. Track missing accessories, damaged parts, and rare variants separately. This detail pays off when you're pricing lots or answering buyer questions. Sloppy condition tracking leads to returns and negative feedback.
Building profit analysis into your tracker
Add tabs for monthly sales summaries, best-performing sets, and inventory turnover rates. Calculate your average hold time for different figure types. Track which sources give you the best margins. This analysis turns your collection tracker from a simple inventory list into a business intelligence tool that guides your buying decisions.
When spreadsheets hit their limits
Spreadsheets work great until they don't. Once you're scanning dozens of figures per session, manual entry becomes a bottleneck. Your tracker needs bulk scanning capabilities, automated valuations, and real-time market data. Most serious resellers outgrow basic spreadsheets within their first year.
Related reading
- Lego inventory spreadsheet template
- LEGO inventory tracker app
- Track LEGO Collection Value Over Time
FAQ
What's the best spreadsheet app for tracking LEGO collections?
Google Sheets works best for most resellers because it supports API calls for price updates and allows real-time collaboration. Excel works if you're staying offline, but you'll lose automated pricing features.
How often should I update prices in my collection tracker?
Update your top 20% of figures daily, especially rare or volatile pieces. Update the rest weekly. Set up automatic price pulls where possible to avoid manual updates eating into your time.
Should I track individual pieces or complete figures only?
Track complete figures for efficiency, but note missing pieces in a separate column. Individual piece tracking works for high-value items but becomes overwhelming for bulk inventory.
How do I handle figures that appear in multiple sets?
Create separate rows for each set appearance if values differ significantly. For identical figures across sets, use one row and note all relevant set numbers in a dedicated column.
Ready to move beyond manual spreadsheets? Brickem.io scans your entire collection in minutes, not hours, with automatic valuations and real-time market data. Start scanning free with no credit card required.
