How to convert feet to inches, miles, and meters easily in Excel?
If you find yourself needing to convert measurements from feet to inches, miles, meters, or even centimeters in Excel, how can you do so efficiently? This article outlines some clever methods to swiftly handle conversions between feet and other common units of measurement like inches, miles, and meters, facilitating your work in Excel.
 |  |  |
- Convert feet to inches, miles, and meters with Conversion factors
- Convert feet to inches, miles, and meters with Kutools for Excel
- Convert feet to inches, miles, and meters with Convert function
Comparison of Methods for Converting Feet to Inches, Miles, and Meters
Excel provides several ways to convert measurements in feet to inches, meters, nautical miles, or statute miles. The following table compares the methods introduced in this article.
| Feature | Conversion Factors | Kutools Unit Conversion | Excel CONVERT Function |
|---|---|---|---|
| Convert feet to inches | ✔ | ✔ | ✔ |
| Convert feet to meters | ✔ | ✔ | ✔ |
| Convert feet to nautical or statute miles | ✔ | ✔ | ✔ |
| Batch conversion | Requires filling formulas | ✔ | Requires filling formulas |
| Requires formulas | ✔ | ✘ | ✔ |
| Requires remembering conversion factors | ✔ | ✘ | ✘ |
| Requires unit codes | ✘ | ✘ | ✔ (ft, in, m, Nmi, mi) |
| Select units from lists | ✘ | ✔ | ✘ |
| Preview results before applying | ✘ | ✔ | ✘ |
| Keep original values and add results as comments | ✘ | ✔ | ✘ |
| Setup process | Multiply the source value by the correct conversion factor and fill the formula down | Select the range, choose Distance, select the source and destination units, preview the result, then click OK or Apply | Enter the CONVERT formula with the correct unit codes and fill it down |
| Best for | Simple conversions when the conversion factor is already known | Fast batch conversions without remembering factors or unit codes | Formula-based conversions that update when source values change |
| Ease of use | Easy | Very easy | Moderate |
Convert foot to inches, miles, and meters with Conversion factors
As we know, 1 foot = 12 inches. Therefore, we can convert the measurement unit from foot to inch by multiplying 12.
Step 1: In Cell C2 enter the formula below, and press Enter key.
=A2*12
Step 2: Click the Cell C2, and drag the fill handle to the cells that you will fill this formula.
You will then see all foot measurements converted to inches.
You can apply the same way to convert the foot measurements to miles and meters with conversion factors.
- "1 foot = 0.3048 meters"
- "1 foot = 0.0001646 Nautical miles"
- "1 foot = 0.0001894 Statute miles"
Convert feet to inches, miles, and meters with Kutools for Excel
Can you convert measurement units in Excel without remembering conversion factors or functions? Yes, the “”Unit Conversion“” tool of Kutools for Excel can help you quickly convert between measurement units in Excel.
Step 1: Select a range you want to work with.
Step 2: Click the "Kutools" > "Content" > "Unit Conversion". See screenshot:
Step 3: Specify the "Distance" unit in the drop-down box of "Units", and then select the source unit in the left box, the unit you want to convert to in the right box, and you will see the result in the Preview box. See screenshot:
Step 4: Click Ok or Apply.
You can convert feet to meters or miles using the same steps.
- If you want to keep the source unit in the cells and show results in the comment, you can check the "Add results as comment" option. Click to learn more about this Unit Conversion feature.
Kutools for Excel - Supercharge Excel with over 300 essential tools, making your work faster and easier, and take advantage of AI features for smarter data processing and productivity. Get It Now
Convert foot to inches, miles, and meters with Convert function
It is hard to remember all of the conversion factors clearly. We can apply Excel's CONVERTfunction to change foot measurements to inches, miles, and meters. For example, we can convert foot to inches as follows:
Step 1: In Cell C2, enter the formula below, and press the Enter key.
=Convert(A2, "ft", "in")
Step 2: Click the Cell C2, and drag the fill handle to the cells that you will fill this formula.
| Conversion | Formulas |
| Convert Foot to meter | =Convert(A2, "ft", "m") |
| Convert Foot to Nautical Miles | =Convert(A2, "ft", "Nmi") |
| Convert Foot to Statute Miles | =Convert(A2, "ft", "mi") |
Conclusion
The conversion factor method is straightforward when you already know the required relationship, such as 1 foot = 12 inches or 1 foot = 0.3048 meters. However, different target units require different factors, so this approach becomes less convenient when you frequently switch between measurement systems.
Excel's CONVERT function avoids manually entering conversion factors and provides a reliable formula-based solution. It supports feet-to-inches, feet-to-meters, feet-to-nautical-miles, and feet-to-statute-miles conversions, but users must know the correct unit codes such as ft, in, m, Nmi, and mi.
Kutools for Excel's Unit Conversion provides the most convenient workflow for frequent or batch conversions. Users can select the source and destination units directly from lists, preview the converted values before applying them, and optionally keep the original measurements while adding the converted results as comments. This eliminates the need to remember either conversion factors or Excel unit codes.
Related articles:
- Convert currencies
- Convert between dollars, pounds, euros
- Unit conversions
- Convert time measurement between hour, minutes, seconds, or day
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in