Tracking a Pile of Shame: Build a Miniature Collection Spreadsheet From Shelf Photos

Define What Counts as Part of the Collection

A pile of shame is rarely a simple stack of unopened boxes. It may include loose sprues, assembled but unpainted miniatures, partly completed units, damaged models awaiting repair, and finished pieces that have not yet been assigned to an army. A useful miniature collection tracker needs to account for these different states without reducing everything to a single completed or unfinished label.

Start by defining the scope. Decide whether the catalog will include only miniatures or also terrain, paints, hobby tools, books, and game accessories. For a first spreadsheet, keeping the scope to models and model kits makes the information easier to maintain. Record individual miniatures separately when they belong to different projects, but use a quantity field for identical boxed items that are still together.

• Unopened kits and boxed sets.
• Opened kits with unassembled parts.
• Assembled and unprimed miniatures.
• Primed or partly painted models.
• Finished models awaiting basing or final details.
• Completed and ready-to-use miniatures.

Photograph Shelves in Manageable Groups

Before creating spreadsheet rows, make a visual record of the collection. Photograph one shelf, storage drawer, or project area at a time. Keep boxes facing forward where possible, and move overlapping items so that labels and distinctive packaging can be seen. A single photograph of an entire hobby room may look comprehensive but can make individual products too small to identify.

Use additional close-up photographs for crowded areas. A shelf with twelve boxes can be split into two photographs of six boxes each. Include a simple location label in the image filename, such as shelf_A_top or storage_drawer_02. This makes it easier to return to an item when an identification question arises.

If the collection includes loose miniatures, photograph them in groups that share a recognizable project or faction. Separate assembled models from unopened kits when possible. The aim is to create a manageable set of visual references rather than one enormous image that requires extensive interpretation.

Use AI to Extract Possible Inventory Entries

An image-capable AI tool can help describe visible boxes, identify likely miniature categories, and organize observations into a structured list. This is especially useful when packaging includes readable product names or when models have distinctive shapes. Give the tool a clear instruction to describe only what is visible and to mark uncertain identifications instead of filling gaps with guesses.

For example, a prompt might read: "Create an inventory from this shelf photograph. List each visible miniature box as a separate possible entry. Extract readable product names, estimate quantities only when clearly shown, and mark unclear details as unknown. Return columns for item description, likely category, visible quantity, and identification confidence."

The resulting list is a draft, not a finished catalog. Similar packaging can represent different products, and a box may contain several units or an entire army. Check the printed title and contents before treating the entry as accurate. If the tool cannot read a label, retain a neutral description such as unidentified infantry box until the item can be inspected.

Build Spreadsheet Columns That Support Real Decisions

A spreadsheet becomes useful when its columns answer practical questions. A basic miniature collection tracker should identify the item, record its quantity, indicate its current condition, and show where it is stored. Add a project or faction field so that models can be grouped by army or campaign. Include a notes field for missing parts, conversion plans, or special painting requirements.

A practical starting structure uses these columns: item name, category, faction or project, quantity, assembly status, paint status, basing status, storage location, and notes. Give each status its own column. A miniature can be assembled but unpainted, or fully painted but awaiting basing. One general progress label cannot communicate these differences clearly.

For example, an entry for a box of ten infantry models might record quantity 10, assembly status unopened, paint status not started, basing status not started, and storage location shelf A. Once five models are assembled, update the quantity or create separate rows for the assembled group and remaining boxed models. The spreadsheet should describe the physical collection accurately.

• Item name: the identifiable kit or model.
• Category: infantry, vehicle, character, terrain, or other.
• Project: army, faction, or campaign assignment.
• Quantity: the number of physical models or kits.
• Assembly status: unopened, partial, assembled, or converted.
• Paint status: unprimed, primed, in progress, or painted.
• Storage location: shelf, drawer, case, or project box.

Separate Inventory Accuracy From Painting Progress

A collection spreadsheet serves two related purposes: it records what exists and helps decide what to work on. Keep these functions separate. Inventory fields should remain factual, while planning fields can express intentions. A model marked as painted should already be painted. A model marked as a priority can be next in line even if it is still in its original packaging.

Add optional fields for project priority, estimated painting effort, and intended completion group. Use simple values such as high, medium, and low for priority. If painting effort is estimated in hours, label the number as an estimate. Do not confuse an expected workload with recorded time spent.

This separation makes the tracker useful when deciding between starting a new unit and finishing an existing one. A filter for assembled but unpainted models can reveal work that is already physically prepared. A filter for incomplete kits can identify which projects need parts or assembly time.

Check Duplicates and Keep the Catalog Maintainable

Shelf photographs can contain duplicate boxes, partially obscured products, and items that appear in more than one image. Use a unique inventory ID for each spreadsheet row. When two photographs show the same box, compare the location and surrounding objects before adding another entry. Record the physical quantity once, even if the item appears in several reference photographs.

Keep uncertain entries visibly separate from confirmed descriptions. A simple identification status field can use confirmed, needs identification, and possible duplicate. This prevents a plausible AI description from becoming a permanent catalog fact without inspection. When packaging is unreadable, a temporary descriptive label is better than an invented product name.

Avoid building an elaborate database before the basic list is complete. A spreadsheet with ten useful columns is more likely to remain current than one with thirty fields that require constant maintenance. Update it when models change state, move storage location, or leave the collection. A brief update after each completed painting session can keep the record accurate.

Turn the Tracker Into a Practical Painting Queue

Once the collection is cataloged, use spreadsheet filters to find manageable projects. Sort by faction to complete an existing army, by assembly status to prepare future painting work, or by storage location when looking for a specific kit. A count of painted and unpainted models can also provide a clearer picture of collection progress than the number of unopened boxes alone.

For a simple first planning exercise, filter for assembled models with paint status set to not started. Choose a group of five to ten models that shares a color scheme and can be completed with the paints already available. Add a target project name and update the statuses as work progresses.

Save the original shelf photographs in a folder that matches the spreadsheet's location labels. When an entry is unclear, the photograph provides context. Begin with one shelf, create its inventory rows, and correct the uncertain entries before moving on to the next storage area.

Questions readers ask