Excel does not have one universal live exchange-rate function: currency conversion requires a rate you enter, a connected currency data type, an imported rate table, or another data source. For a simple conversion, multiply by a rate quoted as target currency per source currency; for a reusable workbook, store rates with their dates and sources.
The difficult parts are using the rate in the correct direction, deciding whether it is current or historical, and keeping the result auditable. Here are seven practical ways to do it.
Before converting: check the exchange-rate direction
Suppose you have USD 100 and want euros.
- A rate of 0.92 EUR per USD means one dollar buys €0.92. Multiply: =100*0.92, producing €92.
- A rate of 1.087 USD per EUR expresses the reverse relationship. Divide: =100/1.087, producing approximately €92.
Currency pairs are often written as USD/EUR or EUR/USD, but do not assume the notation is being used consistently. Confirm which currency is the base and which is the quote before building the formula.
Also remember that applying a dollar, euro, or pound symbol through number formatting changes only the appearance of a number. It does not convert the underlying value.
Method 1: Multiply by a manually entered exchange rate
This is the best option for a one-off calculation or when you have an approved rate from a bank, card provider, broker, or finance team.
| Cell | Value |
|---|---|
| A2 | Amount in source currency |
| B2 | Target currency per source currency |
| C2 | Converted amount |
For USD 100 at a rate of 0.92 EUR per USD, enter A2: 100, B2: 0.92, and C2: =A2*B2.
Format C2 as euros after calculating it. Keep the rate in a separate cell rather than burying it in the formula; that makes the calculation easier to inspect and update.
If your available rate is USD per EUR instead, use =A2/B2.
Recommended Free Tools
For a transaction or report, add the rate date and source in adjacent cells. A manually entered rate is not automatically updated.
Method 2: Use Excel’s Currencies linked data type
The Currencies data type is available in Excel for Microsoft 365 and Excel for Microsoft 365 for Mac, but Microsoft says currency pairs are available only to Microsoft 365 accounts for Worldwide Multi-Tenant clients. It can retrieve a currency pair and expose fields such as its price and last trade time. See Microsoft’s instructions for getting a currency exchange rate.
- Enter a currency pair such as USD/EUR in a cell. Microsoft also documents the colon form, USD:EUR.
- Select the cell or range. You can optionally format the entries as a table; Microsoft recommends this because adding fields is easier.
- Choose Data > Data Types > Currencies.
- When Excel recognizes the pair, the cell displays a linked-data-type icon.
- Select the cell, choose Insert Data, and add the Price field.
- Multiply your source amount by the extracted price.
If B2 contains the converted currency pair, =B2.Price returns the rate field. You can then use =A2*B2.Price. The general syntax is =FIELDVALUE(B2,”Price”).
To request updated information, select Data > Refresh All. The data may be delayed and is supplied as-is, so do not treat it as a guaranteed real-time trading quote or a locally stored historical rate.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errorsIf Excel does not recognize the pair
A question-mark icon means Excel could not confidently match the text to a currency data type. Check the ISO codes and use the Data Selector to search for the intended match. Do not convert the linked cell to ordinary text: formulas referring to fields such as B2.Price can then return #FIELD!.
Method 3: Store rates in a table and use XLOOKUP
A rate table is more reliable than scattering rates throughout a workbook. Create an Excel table named Rates with columns like these:
| From | To | Rate | Rate date | Source |
|---|---|---|---|---|
| USD | EUR | 0.92 | 2025-01-15 | Approved source |
| EUR | GBP | 0.86 | 2025-01-15 | Approved source |
Assume A2 contains the amount, B2 the source currency, and C2 the target currency. Use =A2*XLOOKUP(B2&C2,Rates[From]&Rates[To],Rates[Rate]).
This joins the currency codes into a lookup key, finds the correctly oriented rate, and multiplies it by the amount. If the pair does not exist, XLOOKUP returns #N/A. For a clearer message, use =IFERROR(A2*XLOOKUP(B2&C2,Rates[From]&Rates[To],Rates[Rate]),”Rate not found”).
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Older Excel versions without XLOOKUP can use a helper column containing =From&To, then retrieve the rate with INDEX and MATCH. A reversed pair is not automatically interchangeable; either store both directions or explicitly calculate the reciprocal. Preserve rate dates and sources when historical results must be reproducible.
Method 4: Import rates with Power Query
Power Query is useful when rates arrive as a CSV, JSON response, web table, XML file, or another workbook. It is generally easier to maintain than manually copying rates into formulas. Microsoft says Power Query is available in Excel for Windows, Mac, and the web; the Web connector in Excel for Windows requires Microsoft Edge WebView2 Runtime. See Microsoft’s Power Query availability information.
Rank #3
- Choose Data > From Web or Data > Get Data > From Other Sources > From Web, depending on your Excel version and ribbon layout.
- Enter the source URL and select OK.
- In Navigator, choose the relevant table or data object.
- Select Transform Data to clean it, or Load to import it directly.
- In Power Query Editor, set the exchange-rate column to a numeric type and remove irrelevant rows or columns.
- Choose Home > Close & Load or Close & Load To….
Once the imported table is loaded, use it with a lookup formula or merge it with your transaction data. Refresh it with Data > Refresh All. In Excel for the web, queries can also be refreshed from Data > Queries.
Power Query problems to expect
- The provider changes column names or the structure of its table.
- The response is JSON or XML rather than a visible HTML table.
- Authentication expires or the site blocks anonymous requests.
- Excel interprets a rate as text, preventing arithmetic.
- Your formulas continue pointing to an old range instead of the refreshed query table.
For historical reporting, do not silently replace the original rate. Keep an as-of date and source, or save a dated snapshot of the imported table.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minutePC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11Method 5: Call an exchange-rate API with WEBSERVICE
On Windows desktop Excel, =WEBSERVICE(“API_URL”) can request text from a compatible web endpoint. Excel does not provide one universal exchange-rate API through this function. You must supply an endpoint from a provider, and that provider determines the URL, authentication method, limits, licensing, and response format.
If the service returns XML, =FILTERXML(WEBSERVICE(“API_URL”),”XPATH”) can extract a value. The XPath must match the provider’s actual XML response. JSON responses require a different parsing approach and may be more practical through Power Query or a script.
Important limitations
- WEBSERVICE depends on Windows operating-system features and does not return results on Excel for Mac.
- FILTERXML is unavailable in Excel for Mac and Excel for the web.
- A failed request, unsupported protocol, URL longer than 2,048 characters, or response longer than 32,767 characters can produce #VALUE!.
- API endpoints and response schemas can change, and free services may impose quotas or require keys.
For a workbook used by other people, Power Query is often easier to inspect and refresh. Never label an API result “live” unless you know the provider’s update schedule and Excel’s refresh behavior. Check the provider’s current documentation before relying on an endpoint.
Method 6: Use EUROCONVERT for legacy euro currencies
EUROCONVERT is not a general current-market currency converter. It is designed for fixed European Union conversion rates involving the euro and participating legacy currencies such as DEM, FRF, ITL, and ESP.
The syntax is =EUROCONVERT(number,source,target,full_precision,triangulation_precision). For example, =EUROCONVERT(A2,”DEM”,”EUR”).
It can convert a participating legacy currency to euros, euros to a participating legacy currency, or one participating legacy currency to another through the euro. It does not fetch current USD/EUR or GBP/USD market rates.
If Excel returns #NAME?, activate the add-in:
- Choose File > Options > Add-Ins.
- At the bottom, set Manage to Excel Add-ins.
- Select Go.
- Check Euro Currency Tools and select OK.
The optional precision arguments control rounding and intermediate euro precision. The function also does not apply currency number formatting.
Method 7: Automate the process with VBA, Office Scripts, or another workflow
Automation makes sense when many workbooks or transactions need regular conversion. A script can:
- Retrieve rates from an approved provider or internal table.
- Write the rates into a worksheet table.
- Apply a conversion formula.
- Record the source and retrieval timestamp.
- Refresh the process when requested or on a schedule supported by the surrounding automation system.
VBA is suited to Windows desktop workflows. Office Scripts are designed for supported Microsoft 365 web and automation scenarios. Either approach still needs a rate source; a script does not create exchange-rate data.
Build the business rule before writing the automation. Decide whether the workbook needs the latest rate, the transaction-date rate, an end-of-day rate, or a manually locked rate. Preserve rates used in completed reports rather than replacing them with today’s rate during every refresh.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Format the converted result without changing its value
After the formula produces a numeric result:
- Select the result cells.
- Use Home > Number, or press Ctrl+1.
- Choose Currency or Accounting.
- Select the appropriate symbol and decimal places.
Currency places the symbol beside the amount. Accounting aligns symbols and decimal points and commonly displays zeros as dashes and negatives in parentheses.
Avoid using DOLLAR just to make the result look formatted: =DOLLAR(number,[decimals]). DOLLAR returns text. Text-formatted results can be ignored or mishandled by functions such as SUM, AVERAGE, MIN, and MAX. Use number formatting when the result must remain usable in later calculations.
Free tools Windows power users keep installed
One-click scans. No signup required.
Best Value
- Used Book in Good Condition
Which Excel currency method should you use?
| Need | Best choice |
|---|---|
| One calculation with a known rate | Manual rate and multiplication |
| Microsoft 365 workbook needing a convenient current quote | Currencies linked data type, if available to the account |
| Repeatable workbook with controlled rates | Rates table plus XLOOKUP |
| Regular imports from a file or web source | Power Query |
| Windows-only formula connected to a compatible API | WEBSERVICE, with careful parsing |
| Historical participating European currencies | EUROCONVERT |
| Large-scale or scheduled processing | VBA, Office Scripts, or external automation |
FAQ
Does Excel have a CONVERT function for currencies?
No. Excel’s general CONVERT function is not a universal live foreign-exchange converter. Currency conversion requires an exchange rate, an imported data source, the Currencies linked data type, or another workflow. EUROCONVERT is a specialized fixed-rate function for euro-participating currencies.
Can I convert currencies by changing the cell to a dollar or euro format?
No. Currency formatting changes only the displayed symbol, decimal places, and layout. It does not change the number. You must calculate the converted value first, usually by multiplying or dividing by the correctly oriented exchange rate.
Why is my currency conversion backwards?
The exchange rate is probably quoted in the opposite direction. If the rate is target currency per source currency, multiply. If it is source currency per target currency, divide by that rate or use its reciprocal.
What is the most reliable way to keep currency conversions auditable?
Store rates in a separate table with the source currency, target currency, rate, effective date, and source. Use a lookup or Power Query to apply the rate, and preserve the rate used for completed reports instead of overwriting it during a later refresh.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Is the Currencies data type available in every Excel version?
No. Microsoft documents the feature for Microsoft 365 accounts, and currency pairs are available only to Worldwide Multi-Tenant clients. Availability can depend on the account and region.
The Bottom Line
For a quick calculation, enter the rate in a dedicated cell and multiply by it. For a reusable workbook, store dated rates in a table and retrieve them with XLOOKUP. Use the Currencies data type or Power Query when a connected refresh is appropriate, and reserve WEBSERVICE or automation for workflows that can handle API failures and maintenance. Whichever method you choose, verify the rate direction and keep the rate date and source alongside the result.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
