Yes. A DMC thread inventory spreadsheet can be a simple Excel workbook with one row per color and columns for the DMC number, color name, skeins on hand, storage location, and a reorder threshold. With your minimum quantity in C2 and the skeins you own in D2, enter =MAX(0,C2-D2) in E2 to calculate how many to buy; if C2 is 3 and D2 is 1, E2 returns 2.
What a DMC inventory spreadsheet is for
The spreadsheet is a searchable record of the thread you actually own, not just a printed color chart. It helps answer practical questions: Do you have the shade a pattern calls for? Is there enough for the project? Where did you store it? Which colors are running low? A clear inventory can also help avoid buying a duplicate skein simply because a color is tucked into a project bag or a different storage box.
DMC is a thread brand with numbered colors, and those numbers are the most useful identifiers in an inventory. A color name can help you recognize a shade, but use the DMC number as the primary key: names may be absent from a chart or written differently by different sellers and stitchers. If your stash includes more than one DMC thread type, record the product line too. A number alone may not tell you whether an item is Mouliné embroidery floss, pearl cotton, or another product.
There is no need to enter every shade DMC has ever sold before the sheet is useful. Start with the colors in your possession, then add rows as you buy or discover more. A spreadsheet you keep current is more valuable than a comprehensive catalog that does not reflect your actual stash.
Choose columns that match your stash
Keep the basic inventory compact enough to update. A useful starting layout is:
- DMC number: The shade number printed on the label or listed in the pattern.
- Color name: Optional descriptive text. Confirm it against a reliable chart if you choose to fill it in.
- Minimum quantity: Your personal threshold for deciding when to restock.
- Skeins owned: The number of full skeins currently available for general use.
- To buy: A calculated amount based on the threshold and the quantity on hand.
- Location: A box, drawer, binder page, or project bag identifier.
- Notes: Useful details such as a partial skein, a reserved project quantity, or a product type.
For a small collection, one row per DMC number is usually easiest to maintain. If you regularly keep the same color in several locations, either list the locations in Notes or use a separate row for each location. The second option makes location-specific counts clearer, but you must avoid treating those rows as separate colors when calculating how many distinct shades you own.
Decide what “quantity” means before entering data. Counting full skeins is quick and consistent, but it does not measure the usable length left in an opened skein. You can add a Partial column with values such as Yes or No, or record an estimated remaining length in its own column. Avoid mixing units—for example, putting a skein count and a length estimate in the same quantity field.
Build the workbook in Excel
In Excel for Microsoft 365 on Windows, enter your column headings in row 1 and your thread records below them. Select the headings and the rows you have filled in, then choose Insert > Table and confirm that the table has headers. A table makes it easier to sort and filter the inventory as it grows. On a Mac, the Insert tab also contains the Table command; labels can vary slightly with the Excel version. Excel for the web has an Insert > Table option as well.
Give each column one job. Store DMC numbers as values rather than embedding them in longer notes, and keep quantities numeric so Excel can calculate with them. If you want a location drop-down, make a short list of the locations you use, select the cells in the Location column, and choose Data > Data Validation. Set the validation criteria to a list and point it at your location options. This reduces variations such as “Blue box,” “blue-box,” and “Box blue,” which can make filtering less reliable.
Freeze the heading row if you have a long list: choose View > Freeze Panes > Freeze Top Row. To make low stock visible, select the relevant quantity or reorder cells and use Home > Conditional Formatting. You can choose a built-in rule or create a rule suited to your own threshold. Color is a visual cue, not a substitute for checking the actual number, so make sure the sheet remains understandable if printed in grayscale or viewed without formatting.
Use a simple restock calculation
The formula in the opening example calculates the gap between a desired minimum and your current stock, but never returns a negative number. With the minimum in C2 and current full skeins in D2, =MAX(0,C2-D2) returns 0 when you have met or exceeded your threshold. For example, a minimum of 3 and a stock count of 5 returns 0; a minimum of 3 and a stock count of 1 returns 2. Put the formula in E2 and copy it down the column for the other colors.
A threshold is personal, not a DMC rule. Someone who stitches occasionally may set the minimum to 1, while a stitcher planning a large project may want to keep a larger reserve of selected shades. The “To buy” result is a reminder based on the numbers you entered; it does not know how much thread a pattern needs or whether a skein is already reserved for a project.
To handle reservations, add a separate column such as Reserved skeins and calculate available stock from owned stock minus reservations. With owned skeins in D2 and reserved skeins in E2, use =MAX(0,D2-E2) in F2 to show available skeins. If D2 is 4 and E2 is 2, F2 returns 2. Then base your reorder calculation on available stock rather than total stock. Label the columns clearly so you do not mistake the amount physically present for the amount free to use.
Keep the inventory accurate as projects change
Update the spreadsheet when thread enters or leaves your stash, rather than waiting for a full recount. When you buy floss, add the skeins to the corresponding row. When you start a project, either subtract the quantity you intend to reserve or record it in the Reserved column. When you finish, return unused thread to general stock and adjust the count. If you use only a portion of a skein, decide whether your system counts it as a full skein, a partial skein, or an estimated length, and apply that rule consistently.
For a project requiring several colors, use the pattern’s color list as a checklist against the inventory. Search or filter the DMC number column for each shade, then compare the quantity available with the pattern’s stated requirement. A pattern’s estimate can depend on fabric, stitch coverage, and the individual’s stitching habits, so treat your inventory as a planning aid rather than a guarantee that a particular amount will be sufficient. Mark project-specific reservations so another project does not appear to have access to the same skeins.
Make occasional physical checks, especially after reorganizing storage or using several project bags. A simple way to find missing entries is to compare the contents of one container with the spreadsheet, then mark that container as checked in a date or audit column. You do not have to audit every color at once; checking a box or drawer during a restock session is easier than rebuilding the entire record later.
Organize colors and protect useful details
Sorting by DMC number is usually the most practical default because patterns commonly refer to numbers. Excel’s table filters can also show only a particular product line, location, or low-stock status. If you sort the whole table, select a cell within the table and sort using the table’s column controls; sorting only one column can separate a color number from its quantity and notes.
A color chart can help with visual identification, but a spreadsheet color fill is not a reliable substitute for the actual floss. Screen colors vary with displays, lighting, and color settings, and a monitor cannot reproduce every thread shade accurately. Keep the number as text or a number field and use a physical chart or labeled skein when an exact visual comparison matters.
For projects where consistency matters, consider noting which skeins are already assigned to a project and keeping their labels until the work is complete. The label can preserve product and batch information that a basic inventory row may not capture. Do not add batch details unless they are useful to you; extra fields are only helpful if you can maintain them.
Spreadsheet, paper list, or dedicated app?
An Excel workbook is a good fit if you want control over columns, filtering, and simple formulas. It can work offline and can be adapted to a large stash, but it only stays accurate when you update it. A paper checklist is faster for a small collection and does not require a device, though it is harder to search, sort, or revise when quantities change. A dedicated craft inventory app may offer phone-friendly scanning or project features, but capabilities, supported thread ranges, and data export vary by app.
Before relying on a downloaded template or app, check what its fields mean and whether you can export your records. A template might list a color catalog without recording whether you own any of it; that is a reference list, not an inventory. Likewise, a spreadsheet shared by another stitcher may use different assumptions for partial skeins, product lines, or stock quantities. The best choice is the one that records your real materials in a way you will keep current.
Common inventory problems to avoid
- Using the name instead of the number: Names can be inconsistent or missing. Keep the DMC number in its own column.
- Mixing product types: Add a Product line column if your stash includes different kinds of DMC thread.
- Counting partial skeins without a rule: Mark them separately or estimate remaining length consistently.
- Forgetting project reservations: Total stock can look available even when it is committed to unfinished work.
- Sorting only one column: Sort the complete table so quantities and locations remain paired with the right color.
- Assuming an empty row means zero: Enter a numeric zero for a confirmed stock count; leave a blank only when you have not checked.
A related misconception is that a complete list of DMC colors automatically tells you what is in your stash. It does not. A catalog can be useful for looking up numbers, but an inventory needs your own quantities and locations. Keeping those two purposes separate makes the workbook easier to trust.
Frequently Asked Questions
Is there an official DMC thread inventory spreadsheet?
DMC color references and charts are not the same thing as a record of your personal stock. If you find a spreadsheet online, check who created it and whether it tracks ownership, quantities, and locations. You can build a useful personal inventory with the columns above without entering a complete color catalog.
What columns should a DMC floss spreadsheet have?
Start with DMC number, optional color name, quantity on hand, storage location, and a restock threshold. Add product line, partial-skein details, or project reservations only when those details solve a real problem in your stash.
How do I find out which DMC colors I am missing?
Compare your owned-color list with a reliable DMC color reference or the colors required by a particular pattern. A sheet containing only the shades you own cannot show every shade absent from your collection unless you also add a reference list to compare against.
Should I count partly used skeins as full skeins?
That depends on how precise you need the inventory to be. For a quick stash list, you can flag a partial skein in Notes. For project planning, record an estimated usable length or keep partials separate so the full-skein count does not overstate what is available.
Can I use this spreadsheet in Google Sheets?
Yes. The basic columns and arithmetic work in Google Sheets too, though the interface paths differ from Excel. The formulas shown here use standard functions available in both programs; if you share a workbook between them, check that formatting and data validation still behave as you expect.
Related
- Bi-Weekly Budget Spreadsheet: Build One That Works
- How to Animate Typing Text in PowerPoint, Step by Step
- Can You Split Just One Cell in Excel? What Actually Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Mac Keyboard Shortcuts: Essential Keys and TipsIn Excel for Mac, use Command+C, Command+V, and Command+Z to copy, paste, and undo; use Command+Arrow to move…
- Freeze Panes in Excel: Keep Rows and Columns VisibleIn Excel for Microsoft 365 on Windows, select the cell immediately below the rows and immediately to the…
- Excel ODE Solver: How to Solve Differential EquationsExcel has no dedicated built-in ordinary differential equation (ODE) solver, but you can calculate approximate solutions with worksheet…
- Excel Day Care in Clementi: Location and Enrolment GuideIf you are looking for Excel Day Care in Clementi, confirm the centre’s current address and operating status…
- How to Add a Watermark to a Photo in WordTo watermark a photo in Word, insert the photo, add a text box or logo on top of…
- Google Sheets Checkbox Conditional Formatting GuideTo apply conditional formatting to a Google Sheets checkbox, select the cells you want to format, open Format…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.