Clothing Inventory Spreadsheet: Build and Use One

How-to basics · Updated November 21, 2026

A clothing inventory spreadsheet is a worksheet for recording each sellable garment variant, its quantity, location, and other details; in Excel for Microsoft 365 on Windows, you can set one up with a row per size-and-color combination, then use formulas to calculate stock value and flag items to reorder. The key is to give each variant its own SKU or other unique identifier, rather than treating every size and color of a style as one stock count.

What a clothing inventory spreadsheet tracks

Clothing stock is more specific than a count of styles. If a T-shirt comes in three colors and five sizes, those combinations may have different quantities and may sell at different rates. A useful inventory record distinguishes each combination, so a count of “T-shirt, blue” does not accidentally include both small and large sizes.

A spreadsheet can support a small shop, a market stall, a costume collection, or personal wardrobe tracking. The appropriate detail depends on the task. A retailer may need purchase costs and reorder points; someone cataloging household clothing may care more about item description, storage location, and condition. In either case, the sheet is only as dependable as its identifiers and updates.

Decide how to identify each item

Use one row for each distinct stock-keeping unit (SKU): a style in a particular size and color. For example, “Linen shirt / medium / natural” and “Linen shirt / large / natural” should be separate rows if quantities are managed separately. If a supplier already assigns reliable SKUs, use those. Otherwise, create a consistent code, such as LIN-SH-NAT-M, and check that you do not assign it to a different variant later.

Do not rely on the item name alone as a unique identifier. Names can be shortened, renamed, or spelled differently, and two products can have similar descriptions. A separate SKU makes it easier to count, search, reconcile orders, and identify which size is low. For one-off vintage pieces, a unique item ID can serve the same purpose.

Before entering data, decide what counts as one unit. For packaged items, clarify whether a quantity means individual garments or packs. Also decide how to handle damaged, reserved, returned, or in-transit stock. Those categories should not be silently mixed into the number available for sale.

Choose useful spreadsheet columns

Start with the fields that answer practical questions: what is the item, which variant is it, how many are on hand, and where can someone find it? A useful starter layout is:

  • SKU: The unique identifier for the size-and-color variant.
  • Item and category: A readable product name and a group such as shirts, trousers, or accessories.
  • Size and color: Record them consistently; avoid mixing labels such as “M” and “Medium” without a reason.
  • Location: A shelf, rack, bin, stockroom, or other place where the item is stored.
  • Qty on hand: The counted physical quantity, using whole numbers for individual garments.
  • Reorder point: The level at which you want to review replenishment, if reordering applies.
  • Unit cost and stock value: Include these only if you need a cost-based inventory estimate, and define what the cost represents.
  • Last counted and notes: A date and brief context, such as “two damaged” or “supplier delivery pending.”

Keep one fact in each column. For example, store size in a Size column instead of embedding it in some item names but not others. That makes filtering and sorting more dependable. Use a clear date format and a consistent currency format where relevant.

Build the sheet in Excel

In a blank workbook, type the column headings across the first row and enter one variant per row beneath them. Check the headers for duplicates and keep them short but meaningful. Select the range, including the headers, and choose Insert > Table, or use Ctrl+T on Windows. In the Create Table dialog, confirm that “My table has headers” is selected. On Excel for Mac, Command+T is the usual table shortcut; menu wording and shortcuts can differ by version.

An Excel Table is useful because its filters are built into the header row, and it can extend formatting and calculated-column formulas as you add rows. Give it a descriptive name from the Table Design tab, such as ClothingStock. That name is for workbook clarity; it does not change the product SKUs.

For categories, sizes, colors, and locations, use consistent labels. You can create a drop-down list with Data > Data Validation and choose List. Keep the permitted values on the same worksheet, or use a named range if the source list is on another sheet. Drop-downs reduce variations such as “Navy,” “navy,” and “Dark blue” being entered for the same category, but they do not replace checking the data.

Calculate stock value and reorder flags

Suppose the worksheet uses columns G for Qty on hand, H for Reorder point, I for Unit cost, J for Stock value, and L for Status, with the first inventory record on row 2. In J2, the following formula multiplies the counted quantity by the unit cost:

With quantity in G2 and unit cost in I2, enter =G2*I2 in J2. If the row has 6 units at $12.50 each, the result is $75.00. Format the cell as currency if that matches the meaning of the cost.

To flag a row when its quantity has reached or fallen below its reorder point, enter this in L2:

With quantity in G2 and reorder point in H2, enter =IF(G2<=H2,"Reorder","OK") in L2. If G2 contains 4 and H2 contains 5, the result is Reorder; if G2 contains 8 and H2 contains 5, it is OK. The comparison is a prompt to review stock, not an automatic purchase decision.

In an Excel Table, formulas entered in a calculated column generally fill down to the other table rows and continue for new rows. If you are using an ordinary range, copy the formulas down as far as the data extends. To calculate the value of all listed stock, put this in a summary cell outside the table:

With stock values in J2:J101, enter =SUM(J2:J101). If those cells contain $75, $40, and $0 with the rest blank, the result is $115. The total describes only the rows in that range; expand the range if the inventory grows beyond row 101.

Keep counts accurate as stock changes

A spreadsheet does not know that a sale, return, transfer, or delivery happened unless someone records it or updates the count. Choose a routine that fits how stock moves. A small collection might be recounted and updated periodically. A shop with frequent transactions may need to record each receipt and sale, then reconcile the calculated balance with a physical count.

For a basic sheet, update Qty on hand after a transaction and record the date counted. For better traceability, keep a separate transaction log with a date, SKU, movement type, quantity, and reference such as an order number. Receipts increase stock; sales and write-offs reduce it. A log helps explain why a number changed, but it requires consistent entry and a clear rule for returns, transfers, and reservations.

Do not overwrite a quantity with an expected delivery. Store incoming stock separately, or record it as a receipt only when it physically arrives, according to the method you choose. Otherwise the sheet can show stock as available when it is still in transit. Similarly, decide whether “on hand” includes items reserved for customers; if it does, do not interpret it as immediately available.

Use filters, formatting, and stocktakes

Table filters make it possible to view one size, color, category, or storage location without making separate sheets for each. Sorting by SKU can help with a count, while filtering Status to Reorder can produce a review list. Avoid sorting a single column by itself: select within the Table and use its sort controls so the other fields stay attached to their records.

Conditional formatting can make low quantities easier to spot. Select the quantity cells, then use Home > Conditional Formatting to apply a suitable rule. Choose colors that remain readable and do not make color the only signal; a text status such as Reorder is more accessible and survives printing in black and white.

During a physical stocktake, count the actual garments by SKU and compare the result with the recorded quantity. Investigate differences before changing the number: a product may be in another location, listed under a duplicate SKU, damaged, or recorded in the wrong size. Save a dated copy or maintain a count log when you need an audit trail. A spreadsheet can organize the count, but it cannot verify that the physical count was performed correctly.

Common errors and practical safeguards

  • Combining variants: A single row for a style with a total quantity hides which sizes and colors are available. Split separately managed variants into distinct rows.
  • Duplicate identifiers: Two rows with the same SKU can make counts and reorder reviews unreliable. Check IDs when adding products.
  • Inconsistent labels: Different spellings create fragmented filter results. Use fixed labels or validation lists for repeated fields.
  • Confusing cost with price: Retail price and acquisition cost answer different questions. Label each field clearly and do not present a cost-based total as expected sales revenue.
  • Unclear units: A quantity of 12 might mean garments, bundles, or cases. State the unit and apply it consistently.
  • Unprotected formulas: A user can accidentally type over a calculated cell. Keep formulas in clearly labeled columns and consider protecting those cells if several people edit the workbook.

Save the workbook in a location that is backed up and limit access if it contains commercially sensitive cost or supplier information. If several people edit it, agree on who may change product codes and formula columns. Shared editing can help, but conflicting edits and inconsistent procedures can still produce incorrect records.

When a spreadsheet is enough—and when it is not

A spreadsheet is a reasonable starting point when the assortment is manageable, updates are controlled, and the team can reconcile records with physical stock. It is inexpensive to begin with, easy to adapt, and useful for sorting and simple calculations. Excel itself does not charge a separate fee for a particular inventory template, but access to Excel may depend on a Microsoft 365 subscription, license, or organization-provided account.

As transaction volume, locations, or user count grows, an inventory or point-of-sale system may be more suitable. Dedicated tools can connect sales and receipts to stock levels and may support barcode workflows, permissions, and audit histories. Those capabilities depend on the product and plan, so compare the actual features and costs rather than assuming every system includes them.

A spreadsheet is not automatically synchronized with a store, online marketplace, or accounting system. Without an integration or deliberate import process, updating one record does not update the others. The practical test is whether people can keep the sheet current and whether errors can be found quickly. If not, a system with transaction controls may be worth evaluating.

Frequently Asked Questions

How do I make a clothing inventory spreadsheet?
Set up columns for a unique SKU, item, size, color, location, quantity, and any needed cost or reorder fields. Use one row per separately counted variant, convert the range to an Excel Table, and test formulas on a few sample rows before entering the full inventory.

Should each size and color have its own row?
Yes, when those variants have separate quantities or need separate reordering. For example, a medium black hoodie and a large black hoodie should be separate records if their stock counts differ. A combined row is only appropriate when the variants are not tracked separately.

Can Excel automatically update clothing stock after a sale?
Not from a basic inventory table alone. Someone must enter the sale, use a transaction log, or connect Excel to a system that supplies the transaction data. A formula can calculate a balance from recorded movements, but it cannot detect an unrecorded sale.

What is the difference between stock value and retail value?
Stock value usually refers to a quantity multiplied by a defined unit cost, while retail value uses the selling price. They are different measures. State which one a total represents, and check the costing method and source figures before relying on it for business reporting.

How often should clothing inventory be counted?
There is no single interval suitable for every collection. Count often enough to catch errors before they affect sales or replenishment, and consider more frequent checks for high-turnover or high-value items. A periodic full count can be supplemented with targeted checks, provided the schedule and method are consistent.

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.