Skip Navigation

Spreadsheet

Set Collection & Build Tracker for LEGO® Sets — Excel & Google Sheets

A LEGO set collection tracker for Excel & Google Sheets — catalog every set, compute cost per piece and gain/loss, and count what's still sealed.

Click to enlarge the image / Click × or press ESC to close

What you'll love

  • Catalog every set you own — number, theme, pieces, minifigures, build status, box & instructions, and where it lives
  • Cost per piece & gain/loss calculate on every row, so a $50 botanical set and a $270 castle finally compare
  • A live dashboard: sets owned, pieces on the shelf, and what's still sealed — plus what that unbuilt pile cost you
  • A missing-parts log that rolls back onto the set and flags it until you fix it
  • A wishlist Retirement Watch that applies your own rule of thumb to every set you're hunting
  • One owned file — Excel, Google Sheets & LibreOffice, no account and no monthly rent

A shelf out-runs your memory

You bought it on release day, certain you’d build it that weekend. Two years later it’s still shrink-wrapped behind three others. You stand in a store genuinely unsure whether you already own the small one. And the set you kept meaning to buy is gone from the shelves and twice the price secondhand.

This is a workbook for that. Every set you own in one place — number, name, theme, year, piece count, minifigures, build status, condition, whether you kept the box and the instructions, where it actually lives, what you paid, and what you reckon it’s worth now.

Cost per piece, on every set

A price tag tells you what a set cost. Cost per piece tells you whether it was any good — and it’s the one comparison that works across a $50 botanical set and a $270 castle. Type what you paid and the workbook divides by the piece count on every row, then ranks your whole shelf by it on the dashboard.

It’s how you notice that the impulse buy you felt slightly silly about was better value than the flagship you agonized over, and how you know whether a wishlist price is a genuine deal or just a smaller number.

What’s still sealed — and what that pile cost

Every collector has the stack of boxes bought and never opened. The dashboard counts them, works out what share of your collection is still in the box, and tells you what that unbuilt pile cost you. Not to shame you — to get one of them onto the table this weekend.

The pieces that walked off

Log a missing piece on the Missing Parts tab — which set, what it is, the color, how many, where you’ll source it — and the outstanding count rolls straight back onto that set, flipping its Complete? flag until you’ve closed it out. The dashboard keeps a fix list.

A retirement read on every wishlist set

Record a wishlist set’s release year and its availability, and the Retirement Watch column gives you a verdict. Anything still available gets measured against a number you set on the dashboard: how long you reckon a set typically stays on shelves. Change the number and every verdict recalculates.

Be clear about what that is: it’s your own judgment applied consistently to your whole list, so the set you’ve been putting off for three years stops hiding among the ones you added last week. It is not a forecast, and the workbook has no idea what any manufacturer plans.

Honest about “value”

The workbook does arithmetic on numbers you give it. It does not look up, fetch, or estimate what anything is worth — you type in what you paid and what you believe a set is worth today, and it computes cost per piece, gain and loss, and the collection totals from those.

So it is not an appraisal, a price guide, or investment advice. Paper value isn’t real until someone pays it, minus fees and shipping and the afternoon you spend packing it. Track it because it’s genuinely interesting and because insurance asks — not because a column told you to buy.

One practical note: because the file pairs what you own with where in your home it lives, treat it like any other record of valuables. Keep it somewhere private, and if you send it to an insurer, send it to them directly rather than posting it anywhere public.

Own it, don’t rent it

A blank spreadsheet is free, and a weekend of building columns that still don’t compute cost per piece. A collector app means an account, someone else’s server, and someone else’s roadmap — and the good free ones tend to start charging once you want more than a list.

This is one file you own. No account, no subscription, no internet needed. It opens in Excel, Google Sheets, and LibreOffice Calc — and the Google Sheets version is a ready-made native copy, not an import you have to fix; it lands in your own Drive, private to you. It will still open in ten years.

Try it first

Want to see how it feels before you buy? The free set-shelf starter is a one-tab taste of the full workbook — log a set per row and see what’s still sealed. And if you collect more than bricks, the rest of the Trackers line catalogs the other things you love the same way.

Not affiliated with the LEGO Group

LEGO® is a trademark of the LEGO Group, which does not sponsor, authorize, or endorse this product. This is an independent tracking template made for people who collect the bricks. The example collection built into the workbook is fictional — every set name, number, and price is invented to show the math working, and the set numbers use an EX-nn format so they can’t be mistaken for real catalog numbers.

See it in action

Play

Built to last

  • Intuitive and straightforward design
  • Employs software best practices
  • Delivered as one spreadsheet that works in Microsoft Excel, Google Sheets, and LibreOffice Calc
  • Free updates — send us a message to be notified of updates when they are available
  • Completely customizable — add rows and columns, rename headings, and adjust formulas

In the download

This digital product is delivered as a zip file containing the following items:

  • 7-tab workbook (.xlsx): Read Me, Dashboard, Sets, Build Log, Wishlist, Missing Parts, Minifigures
  • One-click Google Sheets copy — a ready-made native version, no import needed
  • Start Here guide (PDF)
  • Collector's Playbook (PDF)
  • Printable Set Inventory (PDF)
  • Pre-loaded worked example you overwrite with your own collection

Compatibility & terms

Unless otherwise specified, this digital product is delivered as a spreadsheet (an .xlsx file) designed to work in Microsoft Excel, Google Sheets, and LibreOffice Calc . It is not guaranteed to work in any other application.

This digital product is copyrighted. It is intended for personal use only. It is strictly prohibited to reproduce, resell or share this product, in part or in full, with or without modifications. No refunds, exchanges, or cancellations. Given this is a digital product, no physical product will be delivered.

Why a workbook

Most tools force a choice between a blank spreadsheet you build from scratch and a monthly app that's overkill. Ardent Workshop is the rung in between — structure you own.

  1. Blank spreadsheet

    Free, but you build and maintain every formula, tab and layout yourself.

    • Free
    • Infinite setup
    • No structure
  2. You are here

    Ardent Workshop

    Owned, structured, connected workbooks — a one-time price, yours to keep.

    • One-time price
    • Structured & connected
    • Yours to own
  3. Generic SaaS app

    Powerful, but overkill, rented and locked-in — built for someone bigger than you.

    • Monthly rent
    • Overkill
    • Lock-in

Ready to start

Instant download · Free lifetime updates · Personal use license

$6.95 USD
Buy now

Pairs well with

From the Guides

Hand-picked reading on how to actually use a tool like this.