What should a fabric stash spreadsheet track? Most people start with name and yardage, then find out at the quilt shop that those two columns can’t answer the questions that matter: Do I already own this? Is it enough? Where did I put it?
Here’s a column set that answers all three, a sample sheet, the rules that keep yardage consistent across fat quarters, bundles and scraps, and a simple way to pair each row with a photo. It works the same in a spreadsheet or a paper planner.
It’s written by the developer of QuiltPull, an iPhone app that logs your stash from photos, sorts it by color and lets you ask “Do I have this?” at the shop (app page · view on the App Store).
The 13 columns (one row per fabric)
| Column | Example | What it answers |
|---|---|---|
| ID | F-023 | Links the row to a photo and a tag on the fabric |
| Name / print | Navy small floral | Finding it, shopping |
| Cut | Yardage / FQ / F8 / strip bundle / square bundle / scrap bag | How to write the amount |
| Color | Blue | Searching by color, planning a pull |
| Amount | 1½ yd / 2 FQ / 40 strips | Is it enough? |
| Width | 44″ / 108″ wide back | Backing and binding math |
| Fabric type | Cotton / linen / flannel | Pairing fabrics |
| Designer / collection | As printed on the selvage | Matching a collection |
| Store and price | Local shop, price per yard | Stash value, reordering |
| Date bought | 2026-05 | Using older fabric first |
| Storage | Shelf 2, bin B | Pulling it out |
| Prewashed | Yes / No | Prep before cutting |
| Earmarked for | Baby quilt for June | Reserving fabric |
You don’t need every column on day one. ID, cut, color, amount and storage are enough to answer “do I have it, where is it, is it enough?” Fill in the rest as you use each fabric.
Rules for the amount column
Amount is where stash sheets drift. Write it differently by cut:
- Yardage: length, in one unit for the whole sheet (yards or meters, not both)
- Fat quarters and fat eighths: a count, plus a yardage equivalent in its own column (1 FQ = ¼ yd, 1 F8 = ⅛ yd by area[1])
- Strip and square bundles: the number of strips or squares. Counts vary by bundle, so copy it from the label[2]
- Scrap bags: one row per color bag, with the amount as “bag”. Measuring every scrap is how stash logs die
- When you use fabric: update the amount. Mark used-up rows instead of deleting them, so you can see later which quilt they went into
For converting cuts to yardage, see the fat quarter size and yardage chart.
Don’t skip width
Quilting cotton is usually 42″–44″ wide, while backing fabric comes as wide as 108″[3]. Binding and backing yardage are both worked out by dividing by width (how much fabric for quilt binding and backing). Without a width column, you’ll be unfolding fabric to measure it every time.
Sample sheet
| ID | Name / print | Cut | Color | Amount | Width | Storage | Earmarked |
|---|---|---|---|---|---|---|---|
| F-001 | Cream solid | Yardage | White | 2¾ yd | 44″ | Shelf 1 | Background |
| F-002 | Navy small floral | FQ | Blue | 2 FQ (½ yd equiv.) | — | Bin A | Baby quilt |
| F-003 | Red gingham | F8 | Red | 1 F8 | — | Bin A | — |
| F-004 | Blue strip bundle | Strip bundle | Blue | 40 strips | — | Bin C | — |
| F-005 | Green scraps | Scrap bag | Green | Bag | — | Bin D | — |
| F-006 | Wide cream back | Yardage | White | 2¼ yd | 108″ | Shelf 2 | Backing |
(Made-up example for illustration)
Photographing your stash
A row can’t show you the print. A photo can, and it doubles as a way to audition a fabric pull on screen.
- Lay a tag with the row’s ID on the fabric and shoot both together
- Shoot the front so the print is readable. Add the back if it’s a different color
- Shoot the selvage too. You can copy the designer and collection names from it later
- Use the same spot and similar light each time so colors compare fairly
- Put the ID in the photo’s file name or caption
If you’re logging dozens at once, shoot everything first and fill in rows afterward. It goes much faster.
Paper, spreadsheet or app
| Paper planner | Spreadsheet | Photo-first stash app | |
|---|---|---|---|
| Getting started | Write right away | Set up columns first | Start by shooting |
| Finding a fabric | Tabs or color pages | Sort and filter | Search by color or name (varies by app) |
| Seeing the print | Glue on a swatch | Photos kept separately | Photo is the row |
| At the shop | If you bring it | On your phone | On your phone |
| Yardage math | By hand | Formulas | Depends on the app |
Which fits depends on how many fabrics you have and where you want to look things up. Whatever you use, the 13 columns plus a photo per row make it easy to move to something else later.
Why stash logs stall
- Trying to fill every column on day one and stopping at fabric ten
- Mixing yards and meters so totals don’t add up
- Not updating amounts after cutting, so the sheet and the shelf drift apart
- No ID linking photos to rows
- Logging scraps one by one
In QuiltPull, a photo is the row
QuiltPull keeps these columns, with the photo first:
- Pick several photos and each becomes a fabric. Amounts can wait
- QuiltPull reads the color from each photo on your iPhone and sorts your stash by color. Fix colors by hand any time
- Up to 3 photos per fabric (front, back, selvage), plus width, fabric type, designer, collection, store, storage, price and prewashed
- Cuts: yardage, cut piece, fat quarter, fat eighth, 2½″ strips, 10″ and 5″ squares, and scrap bags
- Grid or list. Sort by color, date added, date bought, amount or name. Filter and search
- At the shop, “Do I have this?” on the To Buy tab checks your stash by color, name, designer or collection
- Export a ZIP with all your fabrics, quilts and photos, and import it on a new iPhone
Every feature is free. The free version holds 30 fabrics in your stash. Used-up fabrics and samples don’t count, and quilts, boards, To Buy and progress photos are unlimited. QuiltPull Pro is a one-time purchase that removes the 30-fabric limit and the watermark on share cards (app page · view on the App Store).
Summary
- One row per fabric. Start with ID, cut, color, amount and storage
- Write amounts by cut: length for yardage, counts for FQs, F8s and bundles, “bag” for scraps
- Keep a width column for backing and binding math
- Shoot each fabric with its ID tag so photo and row stay linked
- Mark used-up fabric instead of deleting it
Sources
- Wikipedia, “Fat quarter” https://en.wikipedia.org/wiki/Fat_quarter
- Liz Johnson, “A Lesson in Pre-Cut Fabric Bundles,” Sew4Home (2018) https://sew4home.com/a-lesson-in-pre-cut-fabric-bundles-names-sizes-shapes-more/
- Sew Nikki, “Calculating Backing Yardage – Quilt Backing Chart” https://sewnikki.com/calculating-backing-yardage-quilt-backing-chart/
(All checked November 18, 2026)
About the sources for this article This article is based on information from public agencies, official sites and specialist media, reorganized by the editors from a recording and organizing perspective. Figures and statements about specifications or safety were checked against primary sources where possible.
This article organizes information from a recording and organizing perspective. If you notice an error or outdated information, please contact us. Last verified: November 2026

