Home/Spreadsheets/Hobby & Life Trackers/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 you get
- 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
- Opens in Excel and in Google Sheets
$14.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription

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
What it looks like


Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Stash Wall
- Project Queue
- Yarn Stash
- Projects
- Pattern Library
- Yarn Spending
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 Hobby & Life Trackers
- Cross Stitch Stash TrackerPaste any pattern's DMC list and the workbook tells you what you own, what is short…$13.99View →

- 75 Hard & 75 Soft TrackerAll three versions in one file — 75 Hard, 75 Soft, or your own rules — with the streak…$9.99View →

- Houseplant Collection TrackerA houseplant collection tracker that shows every plant you own and which ones need you…$8.99View →

- Perfume Collection TrackerA perfume collection tracker built around fill level and cost per wear, showing every…$6.99View →
