LEGO Part-Out Spreadsheet: A Faster Way to Track It

What Is LEGO Part-Out Tracking, Exactly?

LEGO part-out tracking means logging what you paid for a bulk lot, breaking it into sellable pieces such as minifigures, rare parts, and complete sub-builds, and recording what each piece actually sold for. It's the record-keeping layer that tells you whether buying and breaking down that bin of loose LEGO actually made you money.

Most resellers start tracking mentally, then move to a notebook, then to a spreadsheet once the notebook gets messy. That's a normal progression. The problem shows up when the number of lots grows faster than your patience for data entry. In my experience, that tipping point is somewhere around eight to ten active part-outs at once, when you can no longer remember which minifigure came from which bin.

Why Do LEGO Part-Out Spreadsheets Break Down?

Spreadsheets break down because pricing and identification are manual, and both scale badly. A single part-out lot can contain 20 to 100 minifigures plus hundreds of loose parts, and typing each one into a cell, then looking up its value on BrickLink one at a time, turns a ten-minute lot into a two-hour task.

I noticed this myself around my third month of buying bulk lots off Facebook Marketplace. I had a color-coded sheet with formulas for profit margin, and it was already out of date because I hadn't had time to enter the last four lots. A spreadsheet only works if you actually update it, and most sellers stop updating it exactly when volume picks up, which is the worst possible time to lose visibility.

What Fields Should Every Part-Out Row Actually Include?

At minimum, track the lot source, total cost, date acquired, minifigure count, notable part count, and running sale total. Anything beyond that is nice to have but not essential for knowing whether a lot was worth buying in the first place.

Field	Why It Matters	Example
Source	Tells you which sourcing channel is actually profitable	Facebook Marketplace, estate sale
Total cost	Base number for every profit calculation	$45
Date acquired	Flags lots that are sitting too long unsold	2026-03-12
Minifigure count	Minifigures usually drive most of a lot's value	34 figures
Notable parts	Rare or discontinued pieces worth pulling separately	3 rare printed tiles
Running sale total	The only number that tells you if you actually profited	$210 so far

Keep it simple. I recommend against tracking every single part individually unless you're specifically part-selling bricks on BrickLink, because the time cost of logging a ten-cent part rarely pays for itself.

How Do You Track Minifigures Separately From Bulk Parts?

Minifigures deserve their own tracking lane because they usually make up most of a lot's total value despite being a small fraction of the piece count. Treating them the same as loose parts in one giant spreadsheet buries your most valuable inventory in noise.

When I sort a new lot, minifigures come out first and get identified and priced before anything else touches a spreadsheet. A tool like brick'em's LEGO minifigure database speeds this up because you can look up a figure by name or scan it instead of guessing at a part number from memory. Once figures are identified, the parts and sub-builds are what's left, and those get batched and priced separately, often for BrickLink buyers.

How Do You Know If a Part-Out Lot Was Actually Profitable?

A lot is profitable once your total sales from it exceed the purchase cost plus fees, shipping, and the time you spent sorting and listing it. Most sellers only count the purchase price, which overstates profit and makes bad lots look fine on paper.

From what I've seen, fees are the part people forget. eBay promoted listings can push your total take rate close to 25% of a sale once you add standard fees on top, which changes the math on a lot that only looked profitable at the sticker price. Before I buy a lot now, I run a rough estimate with brick'em's haul calculator so I have a ballpark before I hand over cash, not after.

Where Should You Sell What You Pull Out of a Lot?

Where you sell depends on what you pulled: minifigures and character-driven pieces tend to do best on Whatnot and eBay, individual parts and cheaper items move well on BrickLink, and full mixed lots you don't want to break down further can go back out on Facebook Marketplace or Mercari.

I've sold over $100,000 worth of LEGO on eBay over the years, and it's still the platform I trust for broad demand, even though promoted listings eat into margin. Whatnot has been different for me personally. My first show had maybe 10 people watching and did a little over $500 in sales, and within about five months I'd crossed 3,000 followers and $30,000 in total sales without ever showing my face on camera. BrickLink, meanwhile, is where I send the loose parts and cheaper minifigures nobody wants to bid on live, because its fee structure makes small sales worth listing in the first place.

What Can Replace a Spreadsheet for Part-Out Tracking?

A spreadsheet gets replaced by anything that removes the manual identification and pricing step, since that's the part that actually breaks down at volume. Scanning a tray of minifigures with your phone and getting names and current pricing back in seconds does the job a spreadsheet was always trying to do, just faster and with fewer typos.

I started using brick'em for this specifically because I was tired of tabbing between BrickLink listings and my own sheet to double-check a price. You can sign up for brick'em free and scan a bulk lot of figures in one photo instead of entering them one at a time. It doesn't replace the judgment part of the business, deciding what to keep, what to part out, and what to hold, but it removes almost all the data entry that made spreadsheets miserable in the first place.

A Field-Mapping Checklist for Migrating Off Your Spreadsheet

Migrating away from a spreadsheet is mostly about deciding what data you actually need going forward and letting go of the columns you built once and never looked at again. Here's the checklist I'd use if I were starting over today.

• Export your existing spreadsheet as a CSV so you have a backup before changing anything.
• Decide which columns you actually check weekly, like source, cost, and sale total, versus which ones you never revisit.
• Move minifigure identification and pricing into a scanning tool instead of manual lookup.
• Keep a single running number for total invested versus total recovered, updated per lot, not per item.
• Check your full collection's estimated value periodically with brick'em's collection value calculator instead of hand-totaling a sheet.
• Revisit your process every few months. What worked at 5 lots a month usually needs to change by lot 50.

None of this has to happen all at once. I moved one piece at a time, starting with minifigure pricing since that was eating the most hours, and only fully retired my spreadsheet about two months later. If you want more sourcing and pricing breakdowns like this one, brick'em's blog has more of them.

Frequently Asked Questions

Is a spreadsheet good enough for occasional LEGO part-outs?

Yes, if you're only doing a handful of lots a month, a simple spreadsheet with cost, source, and sale total is usually enough. The breakdown happens with volume, not with the format itself, so there's no need to overhaul your system before it's actually causing problems.

What should I track first if I'm just starting to part out LEGO?

Start with total cost, source, and running sale total. Those three numbers tell you if a lot was profitable. Everything else, like part counts or individual pricing notes, is useful later but isn't worth the time investment until you're doing this regularly.

How much of a part-out lot's value usually comes from minifigures?

In my experience, minifigures often make up the majority of a lot's resale value even though they're a small fraction of total pieces. That's why I always sort and price figures first, before touching the loose parts or sub-builds in the rest of the lot.

Do I need to track every single part I pull from a lot?

No. I recommend logging notable or rare parts individually and grouping the rest into a bulk lot entry. Tracking every ten-cent piece rarely pays for the time it takes, unless you're specifically running a parts-focused BrickLink store.

What's the fastest way to price minifigures from a part-out?

Scanning them with a pricing tool instead of looking each one up manually is the fastest method I've found. It cuts what used to take an hour of BrickLink searches down to a few minutes for an entire lot of figures.