Workshop guide · cut list spreadsheet
Build a Cut List Spreadsheet That Is Ready for the Saw
A spreadsheet is excellent for controlling the source list: names, dimensions, quantities, materials, and revisions. It becomes fragile when it is also asked to behave like a two-dimensional nesting tool. Keep the list clean, then hand its rectangles to a layout step.
Use one row for one manufacturing decision
Combine parts only when their finished size, material, thickness, grain direction, and treatment are identical. Two cabinet sides can share a row; a left side with a finished face and a hidden stretcher of the same size usually should not. The purpose of the ID is to survive the trip from design to spreadsheet to diagram to physical part.
Choose one unit for the workbook. If you work in fractional inches, keep a machine-readable decimal or numeric value behind the displayed fraction. Text such as 24 3/8 cannot be sorted or multiplied reliably unless the sheet converts it. Millimeter users should still label the unit in the header rather than relying on memory.
- Part ID and plain-English name
- Finished width, finished length, and quantity
- Material and thickness
- Grain lock or allowed rotation
- Finished-face or edge-banding notes
- Project revision and cut status
Let formulas catch list errors
Use data validation to block blank quantities, zero dimensions, and mixed units. Flag duplicate part IDs with conditional formatting. Calculate line area as width multiplied by length multiplied by quantity, then total it by material and thickness. Those totals are useful for budgeting and for spotting an extra zero before it becomes a purchasing mistake.
A spreadsheet can also compare the total part area with stock area, but label that result as a lower bound. It cannot infer whether the rectangles fit, how many kerfs occur, whether grain permits rotation, or whether a table-saw sequence is practical without a much more complex model.
line area = width × length × quantity | lower-bound sheets = ceiling(total part area ÷ usable sheet area)
Separate finished dimensions from cutting allowances
The source list should state what the part must be when complete. Put rough-cut allowance, edge banding, or final-trim instructions in dedicated fields rather than quietly adding them to the finished dimension. Otherwise the next person—or you two weeks later—cannot tell whether a number is intentional.
Saw kerf belongs to the layout between parts, not inside every finished part dimension. Edge trim belongs to the stock definition. Keeping those concepts separate prevents double-counting when the spreadsheet is transferred to a diagram or an optimizer.
Create a clean handoff to the layout
Freeze the revision before laying out sheets. Filter by one material and thickness, then transfer part ID, width, length, quantity, and grain constraint. Add the actual stock sizes and measured kerf in the layout tool. After the diagram is approved, write its sheet number and cut status back to the spreadsheet rather than editing dimensions in two places.
Print or export a shop copy with large part IDs and checkboxes. Label each physical part as it is cut. If a dimension changes, revise the source row, increment the revision, and regenerate the layout; manually patching the diagram leaves two competing versions of the truth.
edit dimensions in the spreadsheet → regenerate the layout → replace the old shop copy
Questions
Can Excel or Google Sheets optimize a plywood layout?
They can store the cut list and calculate areas well. Two-dimensional nesting with kerf, rotation, grain, and cut order needs a dedicated model or tool; an area formula alone is not enough.
Should the spreadsheet dimensions include saw kerf?
No. Keep finished part dimensions clean and apply kerf between parts in the layout. This avoids oversize parts and double-counted allowances.
What is the most important cut list column?
A stable, unique part ID. It connects the design, dimensions, diagram, labels, and cut status when several parts share similar sizes.