Convert Kilometers to Miles in Excel & Google Sheets
Written by
Reviewed by
Last updated on February 6, 2023
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:
