Stampin’ Up Inventory Spreadsheet: What to Track

How-to basics · Updated November 21, 2026

A Stampin’ Up! inventory spreadsheet is a practical way to track the paper, stamps, ink, tools, and other supplies you own, where they are, and what needs replenishing. There is no single layout that suits every crafter: in Excel for Microsoft 365, start with one row per product and columns for its name, category, quantity, reorder point, cost, and storage location.

What a Stampin’ Up! inventory spreadsheet is for

Stampin’ Up! sells a broad mix of papercrafting products, including stamps, ink, cardstock, dies, embellishments, adhesives, and tools. A personal inventory sheet is different from a retailer’s stock system: its job is to help you find and manage supplies you already have. It can prevent buying a second pack of a color you own, help you check whether you have enough materials for a project, and make it easier to notice when frequently used basics are running low.

There is not one universal spreadsheet that every customer must use. If you are looking specifically for an official downloadable file, check the current Stampin’ Up! website or the account resources available to you; what the company provides can change. A spreadsheet you create yourself can be tailored to your collection, and it need not reproduce product catalog data. Use product names and identifiers from your packaging, receipts, or current product information so your records match what you actually own.

This is also not the same as an official live catalog or ordering system. A personal file may become out of date when products are renamed, retired, or replaced. Treat it as your own record, not as confirmation that an item is currently available to order.

Choose fields that match your collection

Keep the first version small enough to maintain. A useful starting point is one row per distinct product and these fields:

  • Item ID or product code: Record the code shown on packaging or your purchase record when available. It helps distinguish products with similar names.
  • Product name: Use a clear name, such as a stamp set or cardstock color, rather than a broad label like “paper.”
  • Category: Examples include stamps, ink, cardstock, dies, tools, adhesives, and embellishments.
  • Color, size, or type: Add the detail that makes the item identifiable, such as a color name or pack size.
  • Quantity on hand: Choose a consistent unit. For example, count ink pads as units and cardstock as packs or individual sheets, but do not mix units in the same field without noting them.
  • Reorder point: The quantity at which you want to consider buying more. This is your own preference, not a recommendation from Stampin’ Up!.
  • Unit cost and purchase date: Optional fields for personal budgeting and purchase history. Decide whether a “unit” means one pad, one pack, or another consistent measure.
  • Storage location and notes: Record a shelf, drawer, or labeled container, plus useful details such as an open pack or a project reservation.

For a smaller collection, a product name, category, quantity, and location may be enough. Add more detail only when it answers a question you actually have. For instance, separating cardstock by color is useful if you often plan projects by color; tracking every loose scrap individually is likely to create more work than value.

Set up the sheet in Excel

In Excel for Microsoft 365 on Windows, put your field names in row 1, with one product per row beneath them. Avoid blank rows inside the list, merged cells, and multiple products entered in one cell. Select the range and choose Home > Format as Table, then confirm that the table has headers. A table makes it easier to sort and filter by category, color, or location, and it typically extends formatting and formulas as you add rows.

Use consistent categories and spelling. If you enter “Ink,” “ink,” and “Ink pads” for the same kind of item, a category filter may split them into separate groups. You can reduce variation by making a short category list and using Data Validation: select the category cells, choose Data > Data Validation, set Allow to List, and provide your approved entries. Menu labels can vary slightly by Excel build. Excel for Mac also supports tables and data validation, though the ribbon layout may differ.

Keep the workbook in a place you can access and back up, such as a folder included in your normal backup routine. If you store it in OneDrive, Excel can support access across devices, but the file still needs accurate updates from you. A spreadsheet does not automatically know when you use a sheet of cardstock or move a stamp set to another drawer.

Add simple quantity and value formulas

Formulas can flag low stock and calculate an estimated value, but they are only as reliable as the quantities and costs entered. For a basic layout, assume columns A–J are Item ID, Product, Category, Color or Type, Quantity on Hand, Reorder At, Unit Cost, Stock Value, Location, and Status. Enter numbers—not text—in the quantity, threshold, and cost columns. Put the first product in row 2.

With quantity on hand in E2 and unit cost in G2, enter this in H2 to calculate the recorded value of that row:

=E2*G2

If row 2 has 4 units at a recorded unit cost of $7.50, the result is $30.00. This is simply quantity multiplied by unit cost; it is not a current selling price, an appraisal, or tax guidance. Copy the formula down the column, or enter it in a table column so Excel can fill the formula for other rows.

With quantity on hand in E2 and your chosen reorder threshold in F2, enter this in J2 to display a basic status:

=IF(E2<=F2,"Reorder","OK")

If you have 1 unit and set the threshold to 2, the result is “Reorder.” If you have 4 and the threshold is 2, the result is “OK.” The threshold is a reminder, not an automatic purchase instruction: you may want to use up a product, wait for a project, or stop buying it. To see duplicate item IDs, with IDs in A2:A500 and the current row’s ID in A2, use this in a separate check column:

=COUNTIF($A$2:$A$500,A2)

A result greater than 1 means the ID appears more than once in that range. That can identify an accidental duplicate row, but it can also be intentional if you choose to record separate batches or storage locations. Decide how you want to represent those cases before treating every repeated ID as an error.

Track different kinds of supplies sensibly

Not every craft supply is best counted in the same way. Sealed packs, tools, and stamp sets are straightforward to count as units. Consumables such as adhesive, ribbon, or specialty paper may be partly used, so a whole-number count can overstate what remains. You can record an estimate such as “about half” in a notes field, or define a consistent measure such as unopened packs plus individual sheets. The method matters less than applying it consistently.

For paper, decide whether you need to track full packs, loose sheets, or both. If a project needs 12 sheets of a color, knowing that you have one unopened pack may be adequate; if you frequently use single sheets, a sheet count is more useful. For stamps or dies, quantity alone may not answer the question “Can I use this for the project?” Add a short note for a feature that matters, but avoid copying long catalog descriptions into your own workbook unless you have a clear reason.

If you sort by color, use the same color name consistently and keep it in a separate field from the product name. That makes it possible to filter all items of a color, even when they belong to different categories. A location field can also make a large collection more practical: “office” may be too broad, while “blue cabinet, drawer 2” is specific enough to find an item.

Keep the inventory accurate over time

The most useful inventory is one you update as part of ordinary crafting and shopping. A simple routine is more dependable than a complicated workbook that is only checked once a year:

  1. Record purchases: Add the item, quantity, and any details you want to retain when supplies arrive.
  2. Update use: Reduce the quantity when you finish or open a counted unit. For partly used materials, revise the estimate or note instead of pretending the remainder is a full unit.
  3. Review low-stock flags: Filter the Status column for “Reorder,” then decide which items you genuinely want to replace.
  4. Check a physical area: Compare the sheet with one drawer or shelf at a time. Correct missing, moved, or duplicated records as you go.
  5. Archive thoughtfully: Mark an item as used up, given away, or no longer kept rather than deleting purchase history you may want later.

For a large collection, you can do a quick update after a crafting session and a more thorough count periodically. If your records are approximate, say so in a notes field; false precision is less helpful than an honest estimate. When an item is retired or no longer listed, you can keep it in your personal inventory if you still own it. Availability in a catalog and ownership in your craft room are separate facts.

Spreadsheet, app, or paper list?

Excel is a good fit if you want sortable records, formulas, and control over the fields. It can be used offline, and a basic inventory does not require macros or specialized software. Its main drawback is manual upkeep: it will not automatically subtract supplies when you craft, and a workbook can become confusing if several people edit different copies.

A paper list or labeled storage system can be faster for a small stash and does not depend on a device. The trade-off is that searching, sorting, and totaling are harder. A general inventory or craft app may offer phone-friendly entry, photos, or barcode features, but confirm that it supports the product details and units you need before moving your records. Do not assume that a third-party tool is affiliated with Stampin’ Up! just because it includes the brand name or product references.

You can also combine approaches: use a spreadsheet as the master list and add labels to storage boxes that match its location field. That way, the sheet answers “where is it?” while the physical label helps you get to the right container. Keep one authoritative copy so that a handwritten note or an old exported file does not become a competing inventory.

Common problems to avoid

  • Combining unlike items: A row called “cardstock” with a quantity of 20 cannot tell you which colors or sizes are available. Split it into identifiable products if those differences affect your decisions.
  • Counting with mixed units: “3” could mean three packs or three sheets. Put the unit in a dedicated field or include it clearly in the item description.
  • Using names alone: Similar product names can be easy to confuse. Add a product code when you have one, and use color or type fields to distinguish variants.
  • Overbuilding the workbook: Too many columns and elaborate status rules can make updates tedious. Start with essentials and add a field only when it solves a recurring problem.
  • Treating estimated value as authoritative: A total based on purchase cost is a personal record, not necessarily the current price or resale value. Keep financial or tax records separately when required and consult an appropriate professional for those matters.

Frequently Asked Questions

Does Stampin’ Up! provide an official inventory spreadsheet?
Do not assume there is a universal customer inventory workbook. Check the current Stampin’ Up! website or the resources in your account for any official files available to you. A personal Excel sheet is a separate record and may be easier to tailor to your storage and tracking habits.

What should I put in a Stampin’ Up! inventory spreadsheet?
Start with product name or ID, category, color or type, quantity, and location. Add a reorder threshold, cost, purchase date, or notes if those details help you plan purchases or find supplies. Keep units consistent so quantities can be understood later.

Can Excel tell me when to reorder supplies?
Yes. A formula can compare the quantity you recorded with a threshold you set and label the row “Reorder” when the quantity is at or below that threshold. It cannot know your project plans or current product availability, so use the flag as a prompt to review, not as an automatic order.

Should retired products stay on my spreadsheet?
If you still own them, yes, if the purpose of the sheet is to track what is in your craft room. You can add a note that the item is retired or no longer available, but availability information should be checked against current official sources rather than inferred from an old inventory entry.

How often should I update the spreadsheet?
Update it when purchases arrive and when you use a counted item or move it to another location. If you track approximate quantities for consumables, a periodic shelf-by-shelf review can correct estimates. Choose a cadence you can maintain; a simple, current list is usually more useful than a highly detailed but neglected one.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.