DMC Floss Inventory Spreadsheet: A Practical Guide

How-to basics · Updated November 21, 2026

A DMC floss inventory spreadsheet is a list of the thread colors you own, how much of each you have, and where it is stored. You can build one in Microsoft Excel with a row per color, then use filters and simple formulas to spot low or missing stock; a color chart identifies DMC shades, but it is not a record of your personal supplies.

What a DMC floss inventory spreadsheet does

DMC floss is commonly identified by a color number, which makes the number a useful key for an inventory. A color name can help you recognize a shade, but numbers are less ambiguous when you sort, search, or compare a project list with your stash. For example, DMC 310 is Black. Check a current DMC color reference for names and swatches when entering or confirming colors; screen colors and printed charts are not perfectly reliable representations of thread.

An inventory answers practical questions: Do you already have the color a pattern calls for? Is there enough for the project? Is a skein in a drawer, project box, or travel kit? It can also show which colors are running low. It does not need to be complicated: a well-maintained list of color number, quantity, and location is more useful than a large workbook full of fields you never update.

There is no single personal inventory that can be supplied as a complete record of what every stitcher owns. A downloadable color list or chart, where available from a retailer or DMC, is a reference to color identifiers, not proof that you own those colors or have a particular quantity. Treat any template as a starting point and verify its color data against a current reference.

Choose a layout that matches your stash

For a small collection, use one row per DMC color and record the total number of skeins. This keeps the list compact and makes it easy to see whether a color is on hand. If you have duplicates in different locations, or want to track partial skeins, use one row per physical skein or storage lot instead. The right layout depends on whether you need a quick shopping check or detailed location and project tracking.

A practical basic table could use these columns:

  • DMC number: The numeric color identifier. Keep it as a number unless a reference you use requires a special format; do not add leading zeroes without checking that the reference actually uses them.
  • Color name: A readable label checked against a current DMC reference. This is helpful but should not replace the number.
  • Quantity: The number of full skeins you have. Decide whether this means full skeins only or full-skein equivalents, and use that definition consistently.
  • Partial amount: Optional. Record a practical estimate, such as half a skein, if partial thread matters to your project planning.
  • Location: A box, drawer, binder page, or project bag. Use consistent names so you can filter the list reliably.
  • Reserved or project: Optional. Note thread already set aside for a named project so it is not mistaken for available stock.
  • Reorder level and notes: Optional fields for a minimum quantity and details such as a dye-lot note or a need to compare a shade in person.

If you choose a row per color, enter a color only once and update its quantity when you acquire or use skeins. If you choose a row per skein, repeated DMC numbers are expected; each row can identify a separate location, partial skein, or lot. Do not mix these two approaches casually, because a formula or count that assumes one row per color will give confusing results if duplicates represent individual skeins.

Set up the workbook in Excel

In Excel for Microsoft 365 on Windows, enter the column headings in row 1, select the range, and choose Insert > Table. Confirm that the table has headers. Tables make it easier to filter by color, location, or stock status, and they normally extend when you add rows. Give the table a clear name from Table Design, such as FlossInventory, if you want to refer to it in later formulas. The same basic table and formula features are available in current Excel for Mac and Excel for the web, although ribbon placement can differ slightly.

Enter one item per row and keep the information in each column consistent. For instance, use “Project box A” each time rather than alternating among “box A,” “A,” and “project A.” Turn on filters through the table header arrows, then sort the DMC number from smallest to largest or filter a location to see what is stored there. To freeze the headings while scrolling, use View > Freeze Panes > Freeze Top Row.

For a basic color-per-row design, assume DMC numbers are in A, color names in B, quantities in C, and reorder levels in D, beginning on row 2. Put a low-stock indicator in E2 with this formula: =IF(C2<=D2,"Buy",""). If the quantity is 1 and the reorder level is 1, the result is “Buy”; if the quantity is 2 and the reorder level is 1, the result is blank. Copy the formula down the table. Set a reorder level that suits your own habits rather than treating any particular number as a universal recommendation.

For a quick count of colors with no full skeins, assume quantities are in C2:C500, with zero entered for colors you track but do not currently own. Use =COUNTIF(C2:C500,0). If three cells in that range contain zero, the result is 3. This counts rows, not distinct colors, so it is most useful when each color has exactly one row. Blank cells are not the same as a recorded zero; enter zero when you want the spreadsheet to identify a known out-of-stock color.

Record quantities in a way you can maintain

Thread stock is not always a neat count of unopened skeins. A skein may be partly used, split among projects, or stored in more than one place. Pick a level of precision that helps your decisions. If you only need to know whether to buy more, tracking full skeins and marking a partial skein in notes may be enough. If you often plan large projects, a separate partial-amount field can make estimates more useful.

For example, suppose you own two full skeins of a color and one partial skein that you estimate as about half of a full skein. You could record “2” in full skeins and “about 0.5 skein” in a notes or partial field. Do not quietly enter 2.5 in a quantity column if you intend that column to mean whole skeins; another person, or you months later, may read it as two and a half unopened skeins. The key is to label estimates and keep units clear.

If you want to list every physical skein or partial, a one-row-per-item ledger is more flexible. Add columns for DMC number, quantity or estimated fraction, location, and status such as available, reserved, or used. A summary by color can then be calculated, but only if the entries are consistent. For a straightforward spreadsheet, it may be simpler to update a single total per color than to maintain a detailed movement log.

Compare a pattern list with what you own

A pattern’s floss key and an inventory serve different purposes. The pattern lists colors required for that design; the inventory lists supplies you own. Before shopping, compare the two lists by DMC number and check that the quantity you have is available rather than reserved for another project. A match on color alone does not guarantee you have enough thread, especially when a pattern calls for multiple skeins or you use a different stitching method.

For a small project, a manual check with Excel’s filter or Find command may be perfectly adequate. Filter the inventory for each requested DMC number, or sort both lists by number and compare them side by side. If you paste a project list into the workbook, keep it on a separate worksheet so you do not accidentally overwrite your main inventory. Record the pattern’s requested quantity in its own column, rather than changing your inventory quantity to match the project requirement.

When the same color appears in more than one inventory row, totals need to account for all of those rows. With DMC numbers in A2:A500 and quantities in C2:C500, and the color to total in E2, use =SUMIF(A2:A500,E2,C2:C500). If E2 contains 310 and two matching inventory rows have quantities 1 and 2, the result is 3. This is useful for a row-per-skein or row-per-location setup; it is unnecessary when the inventory already has one consolidated row per color.

Keep the data accurate and easy to use

Most inventory errors come from inconsistent entry rather than complicated spreadsheet problems. A misspelled location, a quantity that was not updated after a project, or a color number typed into the name column can make a correct-looking list misleading. Use a brief update routine whenever you buy thread, start a project, or return unused supplies to storage.

  • Check the number on the label when adding a color instead of relying on memory or a screen swatch.
  • Update the quantity when a skein is used, moved, or reserved. If you prefer not to track use immediately, mark the row for review.
  • Use one spelling for each storage location and one clear rule for partial skeins.
  • Keep a backup of the workbook, especially before bulk edits, imports, or reorganizing columns.
  • Review unusual entries such as blank numbers, negative quantities, and duplicate rows that may be accidental.

Color appearance is a common source of confusion. A display may show a shade differently because of screen settings, and printed charts can vary with paper and printing. Use the DMC number as the stable identifier in your workbook, and consult an actual skein or reliable physical reference when a close visual match matters. Also distinguish color identification from dye-lot tracking: if matching a particular purchase matters to you, record lot information from the skein or packaging when available, rather than assuming the color number alone captures it.

Spreadsheet, app, or paper checklist?

Excel is a good fit if you want to sort, filter, customize columns, or keep a project list beside your stock. It works offline in the desktop application, and a workbook stored in OneDrive can be accessed from supported devices. However, it depends on you maintaining the entries. A spreadsheet cannot know that a skein has been used unless you update it.

A dedicated craft-inventory app may offer barcode scanning, phone-first entry, or project planning, depending on the app. Check what it actually supports before importing your data, and consider whether it can export your records if you later change tools. A paper checklist is simple and independent of devices, but searching and calculating totals becomes harder as the stash grows. You can also use both: keep Excel as the searchable master list and print a short list for a project bag.

Be cautious with templates that promise a complete color catalog. They may have an outdated color list, incomplete names, or quantities that are only sample data. Delete placeholder stock counts, verify reference information, and save a clean copy before making major changes. The spreadsheet is your record; a template does not establish what is currently manufactured or stocked by a retailer.

Frequently Asked Questions

Is there an official DMC floss inventory spreadsheet?
A color chart or color reference is not the same as an inventory of your personal stash. Check DMC’s current site for its available color-reference resources, and use a separate workbook or app to record quantities and locations. Verify any third-party spreadsheet before relying on its color data.

What should I put in a DMC floss inventory?
At minimum, record the DMC number and the quantity you own. A color name and storage location make the list easier to use. Add partial amount, reserved project, reorder level, or notes only if you will keep those fields current.

Should each skein have its own row?
Not necessarily. One row per color is easiest for a simple stock count. Use one row per skein or storage lot when location, partial amounts, or separate records matter; then total matching color numbers when you need a combined quantity.

How do I find out which colors I need to buy?
Compare a project’s DMC numbers and required quantities with the amount you have available, excluding thread reserved for other work. A “Buy” indicator based on a reorder level can flag low stock, but it cannot determine project requirements unless those requirements are entered separately.

Can I use the same spreadsheet in Excel for Mac or the web?
Yes. Tables, filters, and the formulas shown here are available in current Excel for Mac and Excel for the web. Ribbon positions and some keyboard shortcuts differ by platform, but the workbook data and formulas can generally be used across them.

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.