How to convert feet to meters in Excel and Google Sheets

Topic:Unit conversion

Excel & 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

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

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.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

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

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 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 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 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 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 to convert bytes to megabytes

Divide byte values by 1048576 (2^20) to convert bytes to megabytes in Excel or Google Sheets.

Formulas used

CONVERT ROUND / ROUNDUP / ROUNDDOWN PRODUCT

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026