Sqm to Sqft Excel Formula
Two working formulas, the exact unit strings CONVERT accepts, and how to convert price per square metre rather than just area.
Conversions completed
Two ways to do it in Excel
Square metres to square feet can be done with a plain multiplication or with the CONVERT function. The multiplication works in every Excel version and every language; CONVERT is cleaner but is fussy about the unit codes.
| Method | Formula for a value in A1 | Result for 85 |
|---|---|---|
| Multiplication | =A1*10.7639104 | 914.93 |
| CONVERT | =CONVERT(A1,"m2","ft2") | 914.93 |
| Reverse (ft² to m²) | =A1/10.7639104 | 7.90 |
| Reverse with CONVERT | =CONVERT(A1,"ft2","m2") | 7.90 |
The unit codes that trip people up
- The code is "m2", not "m²" and not "sqm". Typing the superscript character returns #N/A.
- The same applies to "ft2". There is no "sqft" code.
- CONVERT is not available in Excel for the web in some tenants; the multiplication always works.
- In non-English Excel, CONVERT requires localised unit names, so a copied formula may break. Multiplication avoids the problem entirely.
Price per square metre to price per square foot
Property comparisons often need the unit price converted, not the area. If A1 holds area in m², B1 the price per m², then price per ft² is =B1/10.7639104. To compare a metric listing against a US listing, convert both to the same basis before dividing.
| What you have | What you want | Formula |
|---|---|---|
| m² area, price per m² | price per ft² | =B1/10.7639104 |
| ft² area, price per ft² | price per m² | =B1*10.7639104 |
| m² area and total price | price per ft² | =B1/A1/10.7639104 |
Reference table to check your formula
| Square metres | Square feet | Formula reverse check |
|---|---|---|
| 25 m² | 269.1 ft² | 232 (reverse check) |
| 50 m² | 538.2 ft² | 465 (reverse check) |
| 59 m² | 635.1 ft² | 548 (reverse check) |
| 74 m² | 796.5 ft² | 687 (reverse check) |
| 84 m² | 904.2 ft² | 78 (reverse check) |
| 100 m² | 1076.4 ft² | 929 (reverse check) |
| 150 m² | 1614.6 ft² | 1394 (reverse check) |
| 200 m² | 2152.8 ft² | 1858 (reverse check) |
Related pages
Frequently Asked Questions
What is the formula for sqm to sqft in Excel?
=A1*10.7639104, or =CONVERT(A1,"m2","ft2"). Both give the same result.
Why does CONVERT return #N/A?
The unit codes must be "m2" and "ft2". Typing the superscript character m² causes the error.
How do I convert price per square metre?
Divide the price per m² by 10.7639104 to get price per ft².
