CONVERT Function – Google Sheets

CONVERT Function Summary

Function Type: Parser

The CONVERT function returns a converted numerical value for a specified unit.

CONVERT Function Animation - Google Sheets

CONVERT Function Purpose

Convert a numerical value from one unit of measure to another. Both units of measure need to be in the same category. There are 13 different categories.

  • Weight
  • Distance
  • Time
  • Pressure
  • Force
  • Energy
  • Power
  • Magnetism
  • Temperature
  • Volume
  • Area
  • Information
  • Speed

CONVERT Syntax

=CONVERT(value, start_unit, end_unit)
  • Function Name.
  • value- [Required] The numerical value to be converted to a different unit.
  • start_unit- [Required] The initial unit of measurement.
  • end_unit- [Required] The unit of measurement you will convert your value to.

Sample of the CONVERT Function

  • =CONVERT(A1,"ft","in")
  • =CONVERT(32,"F","C")
  • =CONVERT(A1,"yr","day")

CONVERT Practice Sheet

Copy our practice sheet below to see all of the available CONVERT variables you can utilize. We have created a simple dynamic dropdown menu so you can easily select the category, start unit, and end unit. We will utilize the CONVERT function to convert the provided value, but also provide the formula used to convert your unit. Now, you can easily see the proper variables being used.

Convert Function Practice Sheet Google Sheets
Copy Practice Sheet

CONVERT Variables

Category: WeightGoogle Sheets’ Variables
U (Atomic Mass Unit)u
Graingrain
Gramg
Ounce Massozm
Pound Masslbm
Stonestone
Slugsg
Hundred Weightcwt
Hundred Weight (UK)uk_cwt
Tonton
Ton (UK)uk_ton
Category: DistanceGoogle Sheets’ Variables
Angstromang
Pica (1/72 inch)Picapt
Pica (1/6 inch)pica
Inchin
Footft
Yardyd
Meterm
Ellell
Milemi
U.S. Survey Milesurvey_mi
Nautical MileNmi
Light-Yearly
Parsecparsec
Category: TimeGoogle Sheets’ Variables
Secondsec
Minutemin
Hourhr
Dayday
Yearyr
Category: PressureGoogle Sheets’ Variables
PascalPa
Millimeter of MercurymmHg
TorrTorr
PSIpsi
Atmosphereatm
Category: ForceGoogle Sheets’ Variables
Dynedyn
Pondpond
NewtonN
Pound-Forceibf
Category: EnergyGoogle Sheets’ Variables
Electron VolteV
Erge
JouleJ
Foot-Poundflb
Thermodynamic Caloriec
IT Caloriecal
British Thermal UnitBTU
Watt-HourWh
Horsepower-HourHPh
Category: PowerGoogle Sheets’ Variables
WattW
PferdestärkePS
HorsepowerHP
Category: MagnetismGoogle Sheets’ Variables
Gaussga
TeslaT
Category: TemperatureGoogle Sheets’ Variables
CelsiusC
FahrenheitF
KelvinK
RankineRank
RéaumurReau
Category: VolumeGoogle Sheets’ Variables
Cubic Angstromang^3
Cubic PicaPicapt^3
Teaspoontsp
Modern Teaspoontspm
Tablespoontbs
Cubic Inchin^3
Fluid Ounceoz
Cupcup
U.S. Pintpt
Pint (UK)uk_pt
Quartqt
Literl
Quart (UK)uk_qt
Gallongal
Gallon (UK)uk_gal
Cubic Feetft^3
Bushel (US)bushel
Oil Barrel (US)barrel
Cubic Yardyd^3
Cubic Meterm^3
Measurement TonMTON
Gross Registered TonGRT
Cubic Milemi^3
Cubic Nautical MileNmi^3
Cubic Light-Yearly^3
Category: AreaGoogle Sheets’ Variables
Square Angstromang^2
Square PicaPicapt^2
Square Inchesin^2
Square Feetft^2
Square Yardsyd^2
Square Metersm^2
Arear
MorgenMorgen
Acre (UK)uk_acre
Acre (US)us_acre
Hectareha
Square Milesmi^2
Square Nautical MilesNmi^2
Square Light-Yearly^2
Category: InformationGoogle Sheets’ Variables
Bitbit
Bytebyte
Category: SpeedGoogle Sheets’ Variables
Meters Per Hourm/hr
Miles Per Hourmph
Knotskn
Admiralty Knotadmkn
Meters Per Secondm/s

Keyboard Shortcuts

WindowsMac
Control (Ctrl) + Shift (⇧) + ArrowCommand (⌘) + Shift (⇧) + Arrow
Purpose: Highlight all cells in a columnPurpose: Highlight all cells in a column or row

Relate Blogs

Relate Functions

  • DATE: Converts a year, month, and day into a date.
  • DATEVALUE: Converts a provided date string in a known format to a date value.
  • TIME: Converts an hour, minute, and second into a time.
  • TIMEVALUE: Returns the fraction of a 24-hour day the time represents.
Google’s Official CONVERT Documentation