How do I convert data in Google Sheets?

Converts a numeric value to a different unit of measure.

Sample Usage

CONVERT(5.1, "g", "kg")

CONVERT(32, "C", "F")

CONVERT(35.7, "in^2", "m^2")

CONVERT(A1, A2, A3)

Syntax

CONVERT(value, start_unit, end_unit)

• value – the numeric value in start_unit to convert to end_unit

• start_unit – The starting unit, the unit currently assigned to value .

• end_unit – The unit of measure into which to convert value.

Notes

• The following list outlines the available unit conversions by category:

  • Weight – u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton

  • Distance – ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec

  • Time – sec, min, hr, day, yr

  • Pressure – Pa, mmHg, Torr, psi, atm

  • Force – dyn, pond, N, lbf

  • Energy – eV, e, J, flb, c, cal, BTU, Wh, HPh

  • Power – W, PS, HP

  • Magnetism – ga, T

  • Temperature – C, F, K, Rank, Reau

  • Volume – ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3

  • Area – ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2

  • Information – bit, byte

  • Speed – m/hr, mph, kn, admkn, m/s

   

• The use of CONVERT between two different categories of start_unit and end_unit will result in an error. For example, CONVERT(13.2,"ft","C") would result in an error as a result of an attempted conversion from distance units to temperature units.

See Also

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.

Examples

The following example shows CONVERT between different sample start_unit and end_unit arguments.

[wpcc-iframe height=”275″ src=”https://docs.google.com/spreadsheets/d/1OmgrK3QrJAOttk9-3tx7LJxm47hxb9tssgUqY2-YbzU/pubhtml?widget=true&headers=false” width=”480″]