Line board vs spreadsheet, Miro & Airtable

The tools, side by side

Each tool does some of the job well. The pattern to notice is the bottom half of the table: the closer you get to the plan and the buy, the more the general-purpose tools fall away.

None of the ticks in the general-purpose columns are wrong — a spreadsheet really does compute totals, Miro really is a good place to arrange images, Airtable really can hold structured records. What none of them do is hold all of it at once and keep it connected as the season changes.

Why spreadsheets go stale

A spreadsheet is the natural home for the numbers — option counts, price tiers, margin targets, and the running total that has to hit the open-to-buy. That part it does well, and for the numeric line plan it’s often the right tool. The problem is that apparel is a visual product, and a grid of cells can’t show you the range. You can see that a category has “18 options”; you can’t see that fourteen of them are the same idea in a different color.

So the visual work happens somewhere else — a deck, a wall, a second file — and now there are two artifacts to keep in step. The spreadsheet doesn’t know the images exist, and the images don’t know the numbers changed. That gap is where a board built off a spreadsheet goes stale: not because the spreadsheet is bad, but because it was never meant to be the picture.

Why Miro and whiteboards drift

Miro, FigJam, and physical walls solve the spreadsheet’s blind spot: they’re built for laying images out and reviewing them together, and for that first pass they’re genuinely good. Airtable goes a step further — it’s a real database with a gallery view, so you can attach records to tiles. Both are a real improvement on a static file.

The limit is the same for all of them: there is no data connection to the plan. An Airtable or Miro board is disconnected from the base data — it doesn’t know what a colorway or a price tier means, and it doesn’t know the open-to-buy moved. Cut a style at the review and the option count doesn’t follow; shift a price tier and the totals don’t update. Someone has to reconcile the board and the plan by hand, every time, and between those passes the board drifts from the numbers it’s supposed to represent. You can model apparel structure into Airtable by hand, but you’re rebuilding — record by record — what a purpose-built line board already knows.

What a line board built for planning adds

A line board built for planning starts from the thing the general-purpose tools are missing: it understands apparel structure. Each tile isn’t a sticky note or a row — it’s a style, with colorways, a price tier, a category, and an option count, and the board stays connected to the plan and the open-to-buy behind it. So the picture and the numbers are the same object seen two ways, not two files someone has to keep married.

That’s what changes at the line review: cut a style in the room and the option count drops, the price-tier balance updates, and the running total against the open-to-buy moves with it. The board doesn’t go stale because there’s nothing to reconcile — the decision made visually is the same decision the numbers record. And because it’s connected downstream, the range on the board flows into the assortment and the buy instead of being re-keyed. That connection is what Canvas, the visual line board inside RetailNorthstar, is built to do.

When a spreadsheet or whiteboard is still fine

None of this means you should reach for a planning system on day one. For an early or small range — a handful of styles, one or two price tiers, a single delivery — a spreadsheet and a Miro board may be exactly right, and adding heavier tooling would slow you down for no gain. The same goes for quick, ad-hoc work: a first-pass mood layout, a one-off review, a sketch of an idea you’re not committed to yet. That’s what whiteboards are for.

The switch is worth making when the range gets big enough that keeping the picture and the numbers in step by hand becomes the job — when styles run into the dozens, when several people edit the same season, and when the board has to feed a real buy against an open-to-buy. That’s the point where “fine to start with” turns into “drifting from the plan,” and a line board built for planning starts paying for itself.

• ✓Spreadsheets, Miro, and Airtable can each hold a range, but none of them know what a style, colorway, price tier, or open-to-buy is.
• ✓A spreadsheet does the math but can’t show the range; Miro and Airtable can show it but stay disconnected from the plan behind it.
• ✓That disconnection is why static boards go stale: nothing on the board moves when option counts, costs, or the OTB change.
• ✓A line board built for planning keeps the picture and the numbers in sync, so a change made visually flows into the option counts, the assortment, and the buy.
• ✓For an early, small, or ad-hoc range, a spreadsheet or whiteboard is still the right tool — switch when keeping the two in step by hand becomes the work.

• What is a line board? →
• How to build a line board, step by step →
• Internal vs wholesale line sheet →
• Visual line planning tools compared →
• From mood board to assortment →

Frequently asked questions

Can you build a line board in a spreadsheet?

Yes, and plenty of teams start there. A spreadsheet can hold every style, colorway, price tier, and option count in rows, and it does the math on totals better than any board. What it can’t do is show the range — you read a spreadsheet as numbers, not as a set of products side by side — so the visual judgment a line board exists for (balance, story, color flow) is the one thing it isn’t built for.

Can you use Miro or Airtable as a line board?

You can, up to a point. Miro (and other whiteboards) are excellent for laying images out visually, and Airtable is a flexible database with a gallery view. The gap is the same in both: they don’t know what a style, colorway, price tier, or open-to-buy is, and the board is disconnected from the base data. When option counts, costs, or the OTB change, nothing on the board moves — you re-arrange it by hand, and it drifts from the plan.

Why does a static board go out of date?

Because a board built in a slide deck, spreadsheet, Miro, or Airtable is a snapshot: it’s correct the day it’s made and knows nothing about the plan behind it. The moment a style is cut, a price tier shifts, or the open-to-buy moves, the board keeps showing the old picture until someone updates it by hand. By the time the buy is built, the picture and the numbers usually disagree.

What makes a line board different from a whiteboard?

A whiteboard (Miro, FigJam, a physical wall) is a blank visual canvas — it will hold anything you put on it but understands none of it. A line board built for planning understands apparel structure: it treats each tile as a style with colorways, a price tier, a category, and an option count, and it stays connected to the plan and the open-to-buy. So a change made on the board flows into the numbers instead of being re-keyed somewhere else.