Get a currency exchange rate (2024)

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More...Less

With the Currenciesdata type you can easily get and compare exchange rates from around the world. In this article, you'll learn how to enter currency pairs, convert them into a data type, and extract more information for robust data.

Get a currency exchange rate (1)

Note:Currency pairsareonly available to Microsoft 365 accounts (Worldwide Multi-Tenant clients.)

Use the Currenciesdata type to calculate exchange rates

  1. Enter the currency pair in a cell using this format: From Currency / To Currencywith the ISO currency codes.

    For example, enter "USD/EUR" to get the exchange rate fromoneUnited States Dollar toEuros.

  2. Select the cellsand then select Insert > Table.Although creating a table isn't required, it'll make inserting data from the data type much easier later.

  3. With the cells still selected, go to the Data tab and select the Currenciesdata type.

    If Excel finds a match between thecurrency pair and our data provider, your text will convert to a data type and you'll see the Currenciesicon

    Get a currency exchange rate (2)

    in the cell.

    Note:If you see   Get a currency exchange rate (3) in the cell insteadof the Currenciesicon, then Excel is having difficulty matching the text with data. Correct any mistakes and press Enter to try again. Or, select the icon to open the Data Selector where you can search for a currency pair or specify the data you need.

  4. To extract more information from the Currenciesdata type, select one or more converted cells and select the Insert Data button Get a currency exchange rate (4) that appears or press Ctrl/Cmd+Shift+F5.

  5. You'll see a list of all the fields available to choose from. Select the fields to add a new column of data.

    For example,Pricerepresents the exchange rate for the currency pair,Last Trade Timerepresents the time the exchange rate was quoted.

  6. Once you have all the currency data that you want, you can use it in formulasor calculations. To ensure your data is up to date, you can go to Data > Refresh All to get an updated quote.

    Caution:Currencyinformation is provided "as-is" and may be delayed. Therefore, this data should not be used for trading purposes or advice. See About our data sourcesfor more information.

Seealso

Stocks and geography data types

How to write formulas that reference data types

FIELDVALUE function

#FIELD! error

Need more help?

Want more options?

Discover Community

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Get a currency exchange rate (2024)

FAQs

Get a currency exchange rate? ›

Local banks and credit unions usually offer the best rates. Major banks, such as Chase or Bank of America, often offer the added benefit of having ATMs overseas. Online peer-to-peer foreign currency exchanges. Online bureaus or currency converters, such as Travelex, provide convenient foreign exchange services.

How do I get the best exchange rate for currency? ›

Local banks and credit unions usually offer the best rates. Major banks, such as Chase or Bank of America, often offer the added benefit of having ATMs overseas. Online peer-to-peer foreign currency exchanges. Online bureaus or currency converters, such as Travelex, provide convenient foreign exchange services.

Where do you find currency exchange rates? ›

OANDA's Currency Converter allows you to check the latest foreign exchange average bid/ask rates and convert all major world currencies. OANDA Rates™ are foreign exchange rates compiled from leading market data contributors.

What is the cheapest way to buy currency? ›

Though there may be a small fee if you exchange less than a certain amount, your bank or credit union will almost always be the cheapest place to exchange currency. You may be able to order currency at a branch location, by phone, or online to have it delivered to you or to pick up at a branch.

Where can I find official exchange rates? ›

The Treasury Reporting Rates of Exchange dataset provides the U.S. government's authoritative exchange rates to ensure consistency for foreign currency units and U.S. dollar equivalents across all reporting done by agencies of the government.

Is it cheaper to get euros in the US or in Europe? ›

With time at your disposal, you'll be able to see exactly what the fee and rate is, and how many euros you'll get for your dollars. It's possible of course that you might get a better deal when you land in Europe. It may well be the case that fees are lower and exchange rates better.

Should I get foreign currency before I travel? ›

Ordering currency from your bank before you travel is almost always better than using the airport currency exchange. Sally French is a travel rewards expert who joined NerdWallet in 2020. She previously wrote about travel and credit cards for The New York Times and its sibling site, Wirecutter.

Where is the best place to get an exchange rate? ›

Where to exchange currency before you leave
  • Avoid changing money at the airport. ...
  • High street banks are unlikely to be competitive on exchange rates. ...
  • Look at online currency specialists. ...
  • Consider a specific account for currency exchange. ...
  • Use low or no fee credit and debit cards. ...
  • Pay in the local currency.
May 16, 2024

What is today's conversion rate? ›

US Dollar Exchange Rates Table Converter
US Dollar1.00 USDinv. 1.00 USD
Euro0.9251861.080864
British Pound0.7870131.270627
Indian Rupee83.3512660.011997
Australian Dollar1.5116250.661540
6 more rows

What is the best website for foreign currency? ›

MakeMyTrip makes the process of buying and selling currency absolutely smooth. Whether you would like to opt for crisp currency notes, or go for BookMyForex multi-currency cards, MakeMyTrip, allows you to buy foreign currency at unbeatable currency exchange rates.

How to exchange money without a fee? ›

Where can you exchange currency without paying large fees?
  1. Use airport kiosks prior to leaving the US.
  2. Buy traveler's checks or foreign currency cash from your bank or credit union.
  3. Choose an online exchange bureau.
  4. Buy currency on arrival at your hotel or in popular tourist areas.

Who has the cheapest currency exchange rate? ›

Currently, the Iranian Rial is considered the world's least valuable currency.

Which US banks offer foreign currency exchange? ›

Financial institutions that allow you to exchange foreign currency
  • America First Credit Union: Credit union members may visit select branches to exchange up to $5,000. ...
  • Bank of America: Bank of America customers may exchange up to $10,000 online. ...
  • Citi: You can call or visit a branch to exchange over 50 types of currency.
May 8, 2024

How can I get better exchange rates? ›

Travel agents often offer more competitive rates. And the Post Office is worth checking. But you are almost certain to get a better deal if you shop around online through companies such as Travelex and Moneycorp, and pick up the foreign currency at an airport or ferry port.

Which money exchange gives the best rate? ›

Orient Exchange is one of the best foreign currency exchange in India. The most expensive option is airport exchange which should only be used as a last resort.

Do you get a better exchange rate using a credit card? ›

The reason you get a favorable exchange rate with a credit card is the issuer is operating at much more scale and they're able to do a large volume of transactions,” said Greg McBride, the chief financial analyst at Bankrate, a personal finance site.

Is it better to exchange currency at home or abroad? ›

Where to Get Good Rates: ATMs and Local Banks. The best place to exchange money is a local ATM or a bank. Many foreign banks are happy to exchange your dollars for local currency for a better rate than you find elsewhere, or you can go to an ATM to skip the line.

Top Articles
Latest Posts
Article information

Author: Aron Pacocha

Last Updated:

Views: 6572

Rating: 4.8 / 5 (48 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Aron Pacocha

Birthday: 1999-08-12

Address: 3808 Moen Corner, Gorczanyport, FL 67364-2074

Phone: +393457723392

Job: Retail Consultant

Hobby: Jewelry making, Cooking, Gaming, Reading, Juggling, Cabaret, Origami

Introduction: My name is Aron Pacocha, I am a happy, tasty, innocent, proud, talented, courageous, magnificent person who loves writing and wants to share my knowledge and understanding with you.