How to Convert Feet to Meters in an Excel Table with Copilot
Question details
The user wants to add a calculated column in an Excel table to convert distances (e.g., baseball stadium center-field distances) from feet to meters using Copilot.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Converting measurement units within an Excel data table.
- Observed behavior
- Needs to apply a structured reference formula or a standard Excel conversion formula, and wants to leverage Copilot to automate the column addition.
Ensure your data is formatted as an official Excel Table (Insert > Table) and that you have an active Microsoft 365 subscription with Copilot enabled.
Prompt Copilot to Add a Conversion Column
Use Copilot's natural language processing to automatically generate and insert the conversion formula into your table.
Copilot in Excel can understand conversational prompts and automatically write structured reference formulas for your tables. This saves time compared to manually typing out syntax.
Click the Copilot icon located on the Home tab in your Excel ribbon.
In the Copilot chat pane, type a prompt such as: 'Add a column to convert the Center Field Distance from feet to meters.'
Review the calculated-column formula suggested by Copilot. If it looks correct, click 'Insert Column' to apply it to your dataset.

Manually Insert the CONVERT Function
Use Excel's built-in CONVERT function if you prefer to write the formula manually or do not have Copilot access.
Multiply by the Conversion Factor
A quick alternative using basic arithmetic instead of the CONVERT function.
Effortlessly Convert Measurements with WPS Office
Need to convert feet to meters without relying on expensive AI subscriptions? WPS Spreadsheet offers a powerful, free platform with full support for Excel's CONVERT function and structured table references.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your data table document.
- 2. Add a New Column: Click on the header next to your distance data to create a new column.
- 3. Use the Formula: Type =CONVERT(A2,"ft","m") or multiply the target cell by 0.3048.
- 4. Apply to Table: Press Enter to instantly convert all feet measurements to meters across your dataset.

Frequently Asked Questions
Why is Copilot not suggesting the correct conversion formula?
Copilot's suggestions depend heavily on your prompt's clarity and your data's structure. Ensure your data is formatted as an official Excel Table and use precise wording like 'Add a calculated column that converts feet to meters'.
What is the exact Excel formula to convert feet to meters?
You can use the built-in function =CONVERT(A2, "ft", "m"), or manually multiply the value in feet by the metric conversion factor using =A2*0.3048.
Can I apply the conversion formula to an entire column at once?
Yes. If your data is formatted as an Excel Table (Insert > Table), entering the formula into the top cell of a new column will automatically fill it down the entire column.
What does a structured reference look like in an Excel Table?
A structured reference uses the column name instead of cell coordinates. For example, if your column is named 'Center Field Distance', the structured formula would look like =[@[Center Field Distance]]*0.3048.




