How to convert Celsius to Fahrenheit in Excel and Google Sheets

Topic:Unit conversion

Excel & Google Sheets

=CONVERT(B2,"C","F")

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 Celsius temperatures in column B.
2In column C, enter =CONVERT(B2,"C","F") to convert to Fahrenheit.
3Alternatively, use =(B2*9/5)+32 for a transparent formula.
4Copy the formula down for all temperature readings.

Tips

Use =(B2*9/5)+32 when you want the formula to be self-explanatory in documentation or when CONVERT availability is uncertain.

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

Can I convert Fahrenheit back to Celsius?

Yes. Use =CONVERT(B2,"F","C") or the manual formula =(B2-32)*5/9.

Does CONVERT support Kelvin?

Yes. Use "K" as the unit identifier. For example =CONVERT(B2,"C","K") converts Celsius to Kelvin.

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 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 feet to meters

Multiply feet by 0.3048 or use CONVERT with 'ft' and 'm' to change feet to meters in Excel or Google 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 AVERAGE

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

Last reviewed: May 28, 2026