Everyone loves a good collection of threads, but unless you have the whole set of DMC threads you’re going to need a way to keep track of what you have, and haven’t got. That’s why we created this awesome colored spreadsheet of all standard, metallic, variations, variegated, Coloris and Étoile 6 strand DMC threads, so you can keep track.
 
Just click the link or image and save the spreadsheet. You can access it on your computer, phone, or put it through googledocs!
 

DMC thread spreadsheet free download by Lord Libidan
DMC thread inventory sheet free download by Lord Libidan

If the above link didn’t work, you may have to use this link: DMC Thread Inventory Spreadsheet direct download
 

Looking for a PDF download?

We have you covered.
Direct download link
 
 
Updated May 2021

 

 

Consider following us on social!

 
               
 
 

This Post Has 142 Comments

  1. Machelle

    Is there a version that is printable? I tried to print the spreadsheet, but it wasn’t formatting correctly and splitting columns between sheets.

  2. Debbie

    Thank you for this sheet. I finally got all my colors checked off and access to it on the go. This helps tremendously for my smocking! I always know what I have (or need). Thanks a million.

  3. Claudia Clawson

    Thank you for this wonderful spread sheet. It is just what I need to track my DMC floss.

  4. Shari

    This is an amazing resource! I am so grateful to you for putting in the work and providing this to everyone who loves to stitch!

    I had a question…the search field works for the first column only on my spreadsheet. (I can search any yarn in the first column and the name and owned columns fill in correctly. However, when I put in a thread number from any column other than the first, the name comes up, but the “owned” field stays at -0-, even if I have indicated a quantity that I actually own. Am I doing something wrong?

    Thank you!!
    Shari

    1. LordLibidan

      Hey!
      Sometimes when you download excel files your computer stops the file from updating automatically.
      On your header bar you should see a “Formulas” tab. In that tab, you should see a “Calculation Options” button; select that and set to automatic. You should also see a “Calculate Sheet” button; hit that too.
      That should fix the issue. If not, drop me another message and we’ll work it out!

      1. Shari

        Wow! That did it!!! Thank you so much – so glad I found you!

        Happy stitching!!

        Shari

      2. Anne

        Hi LordLibidan! Thank you for the amazing spreadsheet! I was inputting values in the 7th column and the search function did not seem to update the number owned. I tried the tip you left for Shari, and it still did not make a difference. Do you have any idea on how I could fix this?

        1. LordLibidan

          Ah, gosh, I’m sorry, that’s a bug! If you download it again it should work.
          If you’ve added numbers already you can copy the whole of the first sheet and just paste it over the top of the new one. The bug fix should still work.
          Sorry about that!

          1. Anne

            Thank you for fixing the bug! It works well now 🙂

      3. Shari

        Hi again. Your update fix worked except I just added some new colors I acquired to my inventory sheet and one field is not updating to show I have a quantity of 1. I tried the update info you gave me previously, but this one field won’t update: 3768 Gray Green – Dark 0

        Let me know if there is some way I can fix this.

        Thank you for your help!!
        Shari

        1. LordLibidan

          Hi Shari,
          I don’t seem to be able to replicate the issue. What does it come up with instead of “1”?
          You appear to have copied in the color name and number, but you have a 0 at the end. Can you confirm you’ve added a “1” into the owned field?

          1. Shari Davis

            Yes – I added a 1 in that field. Then when I put that color number in the search field, it still shows -0-. I tried deleting the “1” in entered and re-adding it, but still when I go to the search field, I get -0- for that color. I tried all the other colors I added and they come up correctly. I tried 3768 again, but I still get -0-. I have automatic calculation set and I tried “calculate sheet” again, but still get the same result.

          2. LordLibidan

            I think I’ll have to have a look at it. I’ve responded by email too.

  5. n

    This is amazing!! Thank you so much!

  6. Candice Z.

    Lord Libidan and Fellow Needleworkers,
    I have just discovered that I can ‘Copy’ and ‘Paste’ Images of the DMC Actual Floss Colours from the Michaels Canada Website.
    Just thought you’d want to know!!!!
    Candice Z. (A grateful cross stitcher)

    1. LordLibidan

      Actually, this was our original idea! But the file size was MASSIVE and depending on the age of your computer could screw the formatting.
      However we do have the current DMC thread color chart to hopefully make things easier!

  7. Danielle

    Thank you so much for the spreadsheet with colors!

  8. Christin T

    I have the Rayon Range Color chart with the actual threads. Let me know if you want a scan to add it to the list
    With the Light Effects are the classical blends and multi blends still in production?

    1. LordLibidan

      The light effects classical blends and multi blends are now just called “metallics” and they can be very hard to find dependant on where you live. Officially I think they may be in production still, but many are sold only in the USA (due to less stringent dye regulations).
      Do you have the old-school rayon range chart with numbers with the five-digit 3XXXX numbers? We’d love a scan if you have one! We know of most of the numbers but we’re struggling to work out if we have them all!

  9. Nicole Rhodes

    My version of Excel is REALLY old. Is there any way you could send me a copy of this in the lowest version possible?

  10. Patricia

    I need 16 colors of DMC 6 strand floss and they are no where – not even on your discontinued list. HELP!

    1. Debbie

      What colors do you need. I realize your post is from Feb 21 but maybe I can help.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.