Home/Spreadsheets/Craft & Fiber/Yarn Stash and Project Tracker
Yarn Stash and Project Tracker
A yarn stash tracker that tells a knitter or crocheter READY or SHORT before they cast on, and shows the whole stash as a wall of color with yardage, dye lots, value and how many years it would take to knit through at their current pace. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What it does
- Every skein you own shown as a wall of color, grouped by colorway family, with skeins and yards per family
- READY or SHORT on every project in the queue, with the exact yardage gap spelled out
- Dye lots tracked per skein, so the mismatch is not discovered halfway up a sweater
- Your full stash inventory: dye lot, yardage left, storage location, and what it cost
- Cost per wear on finished projects, from what the skeins actually cost
- Every pattern you own, the yardage it needs, and whether you have made it yet
- Spending against an annual budget, with spent, remaining and percent used
- Every needle and hook size pre-listed, so the fourth pair of US 8s never gets bought
- Years to knit through the whole hoard at your own stated pace - the number that sells the file
- Opens in Excel and in Google Sheets
$5.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription

See it in action
What buyers say
- ★★★★★
Love the spreadsheet and seller is very responsive with spreadsheet additions & suggestions.
Read this listing's reviews on Etsy
What it looks like


Every tab in the workbook
These are the actual sheet names in the file, in order, read out of the workbook itself.
- START HERE
- Stash Wall
- Project Queue
- Yarn Stash
- Projects
- Pattern Library
- Needles and Hooks
- Yarn Spending
- Settings
Works in
- Microsoft Excel 2016 or later, Windows and Mac
- Google Sheets — upload to Drive and open
- No macros, no add-ins, no subscription
Others in Craft & Fiber
- Excel + Google SheetsCross Stitch Stash TrackerPaste any pattern's DMC list and the workbook tells you what you own, what is short…$8.99View →

- Excel + Google SheetsCraft Show Vendor KitA craft show vendor kit that answers the only question that matters after a market…$6.99View →

- ExcelDMC Colour ChartThe complete DMC six-strand range on ten printable pages, with a swatch, a name and the…$3.99View →

- ExcelCraft Stash Tracker BundleA craft stash tracker bundle for knitters, crocheters and cross stitchers: a yarn stash…$15.99View →
