Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert feet to meters in Excel and Google Sheets
Topic:Unit conversionExcel & Google Sheets
=CONVERT(B2,"ft","m")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter measurements in feet in column B.
- 2In column C, enter =CONVERT(B2,"ft","m").
- 3Or use =B2*0.3048 as the equivalent direct formula.
- 4Copy down for all rows and format to 2 decimal places.
Tips
- For architecture or construction data, you may need to convert feet+inches separately: convert feet and inches to decimal feet first, then to meters.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I convert meters back to feet?
Use =CONVERT(B2,"m","ft") or =B2/0.3048.
Can I convert feet to centimeters in one step?
Yes. Use =CONVERT(B2,"ft","cm") directly — CONVERT handles the two-step conversion automatically.
More on Unit conversion
See all →How-to
How to convert minutes to hours
Turn a number of minutes into decimal hours by dividing by 60. The same simple formula in Excel and Google Sheets.
How-toHow to convert inches to centimeters
Multiply the inch value by 2.54 or use the CONVERT function to change inches to centimeters in Excel or Google Sheets.
How-toHow to convert kilograms to pounds
Multiply kilograms by 2.20462 or use CONVERT to change kg to pounds in Excel or Google Sheets instantly.
How-toHow to convert Celsius to Fahrenheit
Multiply Celsius by 9/5 and add 32, or use the CONVERT function, to change temperatures in Excel or Google Sheets.
How-toHow to convert miles to kilometers
Multiply miles by 1.60934 or use CONVERT with 'mi' and 'km' units to change miles to kilometers in Excel or Sheets.
How-toHow to convert bytes to megabytes
Divide byte values by 1048576 (2^20) to convert bytes to megabytes in Excel or Google Sheets.