Skip to content

Microgreens Inventory Spreadsheet: Seed, Trays, Harvests

A free microgreens inventory spreadsheet: seed by the pound and lot, trays sown by date, clamshells, harvested stock with a sell-by, and when to reorder.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 19, 2026 · 5 min read

A microgreens grower's stock is in three places: seed in the bin, trays on the rack that aren't food yet, and clamshells in the cooler with about a week to sell. A microgreens inventory spreadsheet has to show all three, because the question you're really asking is "can I fill Thursday's orders?", and the answer depends on what was sown ten days ago, not on what's in the cooler today. The sheet below counts seed by the pound and lot, logs every sowing as a lot with its harvest date, and tracks what's cut. A made-up grower's week is filled in.

The short version

  • Seed in pounds, by variety, with the supplier's lot and a reorder amount.
  • Every sowing is a row: crop, date, trays, expected harvest day.
  • Harvested clamshells get the sowing's lot and a sell-by.
  • Know seed per tray and clamshells per tray for each crop.
  • TaroStack takes seed off its lot when you record a sowing and dates the harvest. More below.

An example sheet

Hilltop Greens is a made-up grower in Asheville, North Carolina. Six of its nine rows:

Item Unit On hand Reorder at Unit cost Value Status
Seed, sunflower (black oil) lb 38 25 $3.10 $117.80 OK
Seed, pea (speckled) lb 44 25 $2.20 $96.80 OK
Seed, radish (daikon) lb 9 10 $9.50 $85.50 REORDER
Seed, broccoli lb 6 5 $14.00 $84.00 OK
Coco coir, compressed block 12 8 $7.25 $87.00 OK
Trays, 10 x 20 each 160 120 $1.90 $304.00 OK

Clamshells, labels and 46 finished clamshells of sunflower shoots bring it to $1,132.58. Radish seed is at its reorder amount.

Two numbers for each crop

Everything else follows from these, and they're yours to measure:

Crop Seed a tray Clamshells a tray (2 oz) Days to harvest
Sunflower 8 oz 8 10
Pea 10 oz 9 10
Radish 1.5 oz 6 8
Broccoli 1 oz 5 10

These are this grower's own figures. Yours depend on your seed, your trays and your light.

With them, the seed row turns into trays. Thirty-eight pounds of sunflower is 608 oz, or 76 trays, or about 608 clamshells. At 12 trays a week, that's six weeks of seed. Nine pounds of radish is 96 trays, which sounds like plenty until you notice it's the costly seed with a three-week lead time from this supplier.

Sowings are lots

Sown or cut Lot Trays or clamshells Date
Sown Nov 9 SUN-1109 12 trays Harvest Nov 19
Cut Nov 17 SUN-1107 96 clamshells Sell by Nov 24

The lot is the crop and the day it was sown. SUN-1107 was sown November 7, cut on the 17th, and its 96 clamshells carry that code. Twelve trays at 8 clamshells is 96, so nothing went missing between the rack and the cooler.

The first row is the one that answers Thursday's question. Twelve trays of sunflower will be ready on the 19th, good for about 96 clamshells. If standing orders for that day add up to 110, you know nine days ahead, when it's still possible to sow two more trays for the following week or warn a chef.

The supplier's seed lot matters as well. Seed has been the source of outbreaks in sprouts, and buyers ask microgreens growers about theirs. The row for sunflower seed SF-25-1140 is where a recall of that seed lot would start.

Get the spreadsheet

Download the microgreens inventory spreadsheet. Four sheets: inventory with value and REORDER, lots for seed, sowings and harvests, a count sheet, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. Packaging choices are in how to package microgreens for sale.

Where this stops working

Sowing happens three times a week across eight crops, each with its own days to harvest. Working back from Thursday's orders to what should have been sown on which day is a small planning problem, repeated daily, and a spreadsheet makes you do it in your head.

How TaroStack does it

TaroStack treats a tray like any other batch.

A sowing is a batch. A tray of sunflower is a recipe: 8 oz of seed, coir, a tray's worth of clamshells and labels at harvest. Record the sowing and the seed comes off its lot. The harvest becomes stock with a lot and a sell-by.

The seed lot is on the record. Which seed lot grew which clamshells is noted automatically. A seed recall is one report, down to the customers.

What can I sow? "What could I make right now" shows how many trays the seed on hand allows.

Planning, on Growth. Standing orders and your days to harvest become a plan of what to sow and when, as drafts you approve.

Sell the oldest first. Clamshells go out first-expired-first-out, with an alert before one passes its day.

The job Spreadsheet In TaroStack
Seed after a sowing Subtract ounces by hand Comes off with the batch
What's ready Thursday Count back the days Batches with harvest dates
What to sow today In your head A plan, on Growth
Which seed lot fed a customer Two sheets and memory One report

Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes, with planning). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

How do you keep track of microgreens trays?

Give each sowing a code with the crop and the date, write it on the tray, and log the trays sown and the expected harvest day.

How much seed do I need per tray?

It varies by crop and grower: from about an ounce for broccoli to 8 or 10 oz for sunflower and pea in these examples. Weigh what you use.

Is growing microgreens profitable?

It can be, with standing orders and little waste. The numbers are in is a microgreens business profitable, and stock for a mushroom side in mushroom inventory spreadsheet.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.