Convert Pounds to Kilograms in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to convert values given in pounds to kilograms (or kilograms to pounds) in Excel & Google Sheets.
conversion from lbs to kg

Using the CONVERT Function

The CONVERT function is the best method to convert value given in pounds to kilograms.

Let’s test the above formula on the example for better understanding. Say in column B we have some weight measurements that need to be converted to kilograms. Type the following formula in cell C4 and drag it down:


convert lbs to kg

Convert Kilograms to Pounds

Just by switching the measurements arguments, we can convert the values given in kilograms to pounds:


convert kg to lbs

Convert Pounds to Kilograms in Google Sheets

The conversion of pounds to kilograms using the CONVERT Function works the same in Google Sheets as in Excel:

convert lbs to kg google sheets

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List