How to Convert Square Feet to Square Meters in Excel (2 Formulas)

To convert square feet to square meters in Excel, multiply the cell by 0.092903 — for example, =A1*0.092903. One square foot equals exactly 0.09290304 square meters, so a 1,000 sq ft apartment is 92.9 sq m. Alternatively, use =CONVERT(A1,“ft^2”,“m^2”) for a self-documenting formula. For one-off conversions, try our free unit converter; the step-by-step Excel methods are below.

Method 1: the multiply formula =A1*0.092903

The fastest method is plain multiplication. One square foot equals exactly 0.09290304 square meters (because 1 ft = 0.3048 m exactly, and 0.3048² = 0.09290304). Click the cell where you want the answer — say B2 — and type =A2*0.092903, where A2 holds your square footage. Press Enter: 1,000 sq ft becomes 92.903 sq m. Use 0.09290304 instead of 0.092903 if you want all eight significant digits; for floor plans and listings, four decimals is already overkill. This square foot to square meter formula works in every spreadsheet ever made — Excel, Google Sheets, LibreOffice — because it is just arithmetic, no special function required. It is also the easiest formula to audit: anyone reading the sheet can see the factor and verify it.

Method 2: the CONVERT function =CONVERT(A2,“ft^2”,“m^2”)

Excel has a built-in unit converter, and it handles area. Type =CONVERT(A2,“ft^2”,“m^2”): A2 is your square footage, “ft^2” is Excel’s code for square feet, and “m^2” is its code for square meters. The quotes and the caret (^) are essential — without them Excel throws a #N/A error. The result is identical to the multiply method (CONVERT uses the same 0.09290304 factor internally), but the formula documents itself: six months from now, “ft^2 to m^2” tells you exactly what the cell does, while “*0.092903” sends you hunting for what the magic number means. Use the Excel CONVERT function for area units whenever readability matters — shared workbooks, client files, anything someone else will inherit. One note: CONVERT is an engineering function, so in very old Excel versions (2003 and earlier) it needs the Analysis ToolPak add-in enabled; every version since 2007 includes it by default.

Apply the formula to a whole column with the fill handle

Nobody converts one cell at a time. After entering the formula in B2, hover over the small square in the cell’s bottom-right corner — the fill handle — until the cursor becomes a thin black cross, then double-click. Excel auto-fills the formula down to the last row with data beside it, adjusting A2 to A3, A4, and so on. For a few hundred rows this takes one second. If the adjacent column has gaps, drag the handle manually instead. Pro tip: convert your data range to an Excel Table (Ctrl+T) and the formula auto-fills into every new row you add — future entries convert themselves. And if your square footage lives in scattered cells rather than a column, the same =cell*0.092903 pattern works cell by cell; just point each formula at its own source.

The reverse: convert square meters to square feet in Excel

Going the other way uses the reciprocal factor. One square meter equals 10.7639 square feet, so the formula is =A2*10.7639 (or the exact 10.7639104 for full precision). With CONVERT: =CONVERT(A2,“m^2”,“ft^2”). Real-estate agents working with international listings use both directions constantly: a 120 sq m flat is 120 × 10.7639 = 1,291.7 sq ft. Keep both formulas in your workbook — forward in one column, reverse in another — and you have a two-way converter that never needs the internet. If you would rather not build it, our square feet to square meters converter does the forward trip instantly, and our square-feet-to-square-meters formula guide covers the math behind both directions.

The #1 mistake: converting with the linear factor

This error is everywhere, and it is always the same: multiplying square feet by 0.3048 (the feet-to-meters factor) instead of 0.092903 (the square-feet-to-square-meters factor). A 1,200 sq ft house becomes “365.8 sq m” — nearly four times too big. The rule: area factors are squared length factors. Converting 10 ft to meters uses ×0.3048; converting 10 sq ft to square meters uses ×0.3048². The sneaky variant: converting a room’s length and width separately and then multiplying is actually correct (10 ft → 3.048 m, 12 ft → 3.658 m, area = 11.15 sq m) — the mistake is only when the linear factor gets applied to an already-squared number. Sanity check every result: square meters must always be a smaller number than square feet (a square meter is ~10.76 sq ft). If your “converted” value grew, you used the wrong factor.

Rounding and formatting the results

Raw conversions carry ugly decimals — 92.90304 sq m — so clean them up. For display only, select the column and press Ctrl+1, choose Number, and set 2 decimal places: the underlying value keeps full precision while the sheet shows 92.90. For actual rounding (when the value feeds further math), wrap the formula: =ROUND(A2*0.092903,2). Real-estate convention is 1–2 decimals; construction takeoffs often round to whole square meters with =ROUND(A2*0.092903,0). One caution: never round the source square footage before converting — rounding 1,247.6 sq ft to 1,248 first injects error before the math even starts. Convert at full precision, round the answer.

Use a named factor cell for bulletproof workbooks

If the factor 0.092903 appears in forty formulas, a typo in one of them silently corrupts one row. The professional fix: put 0.09290304 in a single cell — say Z1 — label it “FT2_TO_M2”, and write formulas as =A2*$Z$1. The dollar signs lock the reference so fill-handle copies keep pointing at Z1. Now the factor exists in exactly one place: change it once, and every conversion updates. Better still, name the cell (Formulas → Define Name → “FT2_TO_M2”) and write =A2*FT2_TO_M2 — a formula that reads like English. This pattern pays off the moment a workbook grows past a dozen conversions, and auditors love it.

Troubleshooting: #N/A, #NAME?, and wrong answers

Three errors cover nearly every broken conversion. #N/A from CONVERT almost always means a unit-code typo — the quotes and caret are mandatory, so =CONVERT(A2,ft^2,m^2) without quotes fails while =CONVERT(A2,“ft^2”,“m^2”) works. Copy-pasting from the web sometimes smuggles in curly “smart quotes,” which Excel also rejects; retype the quotes manually. #NAME? means Excel does not recognize CONVERT at all — you are on Excel 2003 or earlier without the Analysis ToolPak; enable it via Tools → Add-Ins, or just switch to the multiply method. Wrong-but-plausible answers usually trace to text in the source cells: if A2 contains “1,000 sq ft” as text instead of the number 1000, both formulas fail or misbehave. Store numbers as numbers (format the column as Number first), keep units in the header row, and the sheet stays clean. When a result looks off, the 10x sanity check from the mistakes section catches it in one glance.

Google Sheets and one-off conversions

Everything above transfers to Google Sheets unchanged: =A2*0.092903 works identically, and Sheets’ CONVERT accepts the same ft^2/m^2 unit codes. LibreOffice Calc handles both methods too. The only environment where CONVERT misbehaves is very old Excel (pre-2007 without the Analysis ToolPak) — the multiply method has no such limitation, which is another reason to default to it. And when you do not need a spreadsheet at all — a single listing, a quick sanity check — skip Excel entirely: our square feet to square meters converter and centimeters to inches converter give instant answers, and the ToolNest homepage rounds up all 130+ free tools. For the pure math behind the factor, see inches to centimeters and grams to ounces.