Convert Kilometers to Miles in Excel & Google Sheets
Download Example Workbook
Download the example workbook
This tutorial will demonstrate how to convert values given in kilometers to miles in Excel & Google Sheets.
Convert Kilometers to Miles
The CONVERT Function can be used to convert values given in kilometers to miles. Simply enter the unit abbreviations into the function:
=CONVERT(B5,"km","mi")
Convert Miles to Kilometers
By switching the measurements arguments, we can convert the values given in miles to kilometers:
=CONVERT(B3,"mi","km")
Convert Values in Kilometers to Miles in Google Sheets
The conversion of kilometers to miles using the CONVERT Function works the same in Google Sheets as in Excel:
