For your own workbook
Board Foot Calculator for Excel & Google Sheets
One formula, =B2*C2*D2*E2/12, does board feet in any spreadsheet. This page gives you that formula in the right column layout, a downloadable cut-list template that already has it filled in, and the one input mistake that quietly inflates most lumber sheets.
What is the board foot formula in Excel?
Set the sheet up in this order — quantity, then the three dimensions, then the calculation — and one formula serves every row:
| Column | Heading | Unit | Example row |
|---|---|---|---|
| A | Part | text | Seat rail |
| B | Qty | pieces | 4 |
| C | Thickness | inches | 1.25 |
| D | Width | inches | 6 |
| E | Length | feet | 8 |
| F | Board feet | BF | =B2*C2*D2*E2/12 → 20 |
Two rules keep the number honest. Length goes in feet, not inches — that is what the ÷ 12 is there for; if you prefer inches everywhere, divide by 144 instead. And quantity multiplies in the same formula, so four rails of 4 BF each read as 16 BF without a second column.
In Google Sheets the formula is identical. If you would rather not copy it down 200 rows, put this one line above the board foot column instead:
=ARRAYFORMULA(IF(B2:B="","",B2:B*C2:C*D2:D*E2:E/12))
What does a worked spreadsheet cut list look like?
Here is a small bench job keyed into the layout above, so you can check your own sheet against real arithmetic rather than trusting the cell:
| Part | Qty × T × W × L | Board feet |
|---|---|---|
| Seat slats | 2 × 1.25 × 10 × 8 | 16.67 |
| Legs | 4 × 1.5 × 5.5 × 3 | 8.25 |
| Shelf | 1 × 1 × 12 × 4 | 4.00 |
| Braces | 2 × 1 × 3 × 6 | 3.00 |
Total — =SUM(F2:F5) | 31.92 BF | |
At $6.50 per board foot that is $207.46 of stock before waste, which you add as a multiplier on the total, not row by row — see the waste factor guide for the percentages I use.
Do I type nominal or actual sizes into the sheet?
This is where a lumber spreadsheet goes wrong, and it is the same trap as nominal versus actual sizes in the yard. A 2×4×8 deck board is sold as 2 × 4 × 8 but arrives at 1.5 × 3.5. Both are correct entries; they answer different questions:
| You typed | Board feet | What that number means |
|---|---|---|
| Nominal (2 × 4 × 8) | 5.33 BF | What a dimensional-softwood dealer bills — 52% more than the wood present |
| Actual (1.5 × 3.5 × 8) | 3.50 BF | The wood physically in the board, and how hardwood is priced |
So: pricing trim lumber from a home-centre flyer, use nominal and your sheet matches the receipt. Planning a hardwood project or estimating what a load will weigh and cost per usable board foot, use actual throughout and never mix the two in one column. Fifty 2×6×10s are 500 BF nominal and 343.75 BF of real wood — that gap is the reason I check a buyer's sheet before I quote from it.
What a spreadsheet will not do for you
Three things the template cannot, and the tool on this site can:
- Round each board the way a yard does. A dealer's tally rounds width and length per board and applies species rules, so 20 rows of identical numbers can still arrive at a different total — the reason two calculators disagree applies to spreadsheets too.
- Switch pricing basis. A quote may arrive in $/MBF, per piece or per linear foot. Convert it before dividing into your total; the lumber cost calculator handles those bases.
- Hold the species list. Hardwood thickness is quoted in quarters (4/4, 8/4) not inches, and that conversion is easy to fat-finger in a cell. The hardwood thickness guide is the lookup I keep next to the keyboard.
A spreadsheet is right when the list is long, the pricing is per species, and you want the file to survive as a record you can re-quote next year. For a single run of boards or a same-day answer at the yard, the cut list calculator is faster — it prices, weighs, saves in the browser and needs no setup.
Frequently asked questions
What is the board foot formula in Excel?
If column B is quantity, C thickness in inches, D width in inches and E length in feet, the formula for row 2 is =B2*C2*D2*E2/12. Copy it down the column and the divide-by-12 conversion to board feet is handled for every row.
Should I enter nominal or actual sizes in a lumber spreadsheet?
It depends who is reading the number. Dimensional softwood is billed on nominal sizes, so a 2×4×8 row entered as 2*4*8/12 matches the dealer’s 5.33 board feet even though the board only holds 3.5 board feet of wood. Solid hardwood is billed on the actual rough size, so enter what you bought — just don’t mix the two conventions in one column.
Does the template work in Google Sheets?
Yes. Import the .csv through File → Import → Upload and the formulas in column F evaluate the same way; if you open the file directly rather than importing it, check that the rows split into six columns. Sheets users can also drop one ARRAYFORMULA above the board foot column instead of copying the row formula down.
Can a spreadsheet round each board the way a lumber dealer tallies?
Not reliably. A spreadsheet totals what you type per row, while a yard tally rounds each board’s width and length and applies the species’ rounding rules. That difference alone can move an order a few percent, which is why a spreadsheet is a planning tool and the dealer’s ticket is the invoice.