If you need google sheets how to convert currency for a budget, invoice, or price tracker, the fastest path is to use a live exchange-rate formula instead of typing values by hand. Google Sheets can pull current rates, apply them to amounts, and even update a whole table automatically. You can also change the displayed currency format so the numbers look right in your sheet.
Use the built-in currency conversion formula
The simplest currency conversion in Google Sheets uses the built-in GOOGLEFINANCE function. It pulls the current exchange rate between two currencies and returns a live rate you can multiply by your amount. This is the core Google Sheets formula to convert currency.
Basic formula
Put your amount in one cell, then use this pattern in another cell:
=A2*GOOGLEFINANCE(“CURRENCY:USDGBP”)
If A2 contains a dollar amount, this converts it to British pounds. Replace USDGBP with the pair you need, such as EURUSD or JPYUSD. The formula for currency conversion in Google Sheets is the same idea every time, amount times exchange rate.
Convert between any two currencies
Use this structure:
=amount_cell*GOOGLEFINANCE(“CURRENCY:FROMTO”)
Examples:
- =A2*GOOGLEFINANCE(“CURRENCY:USDEUR”)
- =B2*GOOGLEFINANCE(“CURRENCY:GBPINR”)
- =C2*GOOGLEFINANCE(“CURRENCY:AUDCAD”)
If you want a single exchange rate without converting an amount, use =GOOGLEFINANCE(“CURRENCY:USDEUR”). That gives you the currency converter Google Sheets formula rate only.
Convert a list of amounts in one sheet
For a column of prices, place the conversion formula in the first result cell and fill it down. This is the cleanest way to handle currency conversion Google Sheets users need for invoices, sales logs, or travel budgets.
- Enter the original amounts in one column.
- Enter the target currency code in the formula, for example USD to EUR.
- In the first result cell, use =A2*GOOGLEFINANCE(“CURRENCY:USDEUR”).
- Drag the fill handle down the column.
- Format the result cells as currency in the target currency.
If you want the same conversion rate applied to a whole range, lock the rate in one cell first. For example, put =GOOGLEFINANCE(“CURRENCY:USDEUR”) in D1, then use =A2*$D$1 down the column. This keeps the sheet easier to edit.
Change the currency display and default currency
Formula results and cell formatting solve different problems. The formula changes the value. The currency format changes the symbol, decimals, and display. If you are asking how to change currency in Google Sheets, this is the part that controls how the number looks.
Format cells as currency
Select the cells, then apply Format, Number, Currency. Google Sheets uses the spreadsheet locale to choose the default symbol and number style. If you need a specific currency symbol, choose More formats, then More currencies, and pick the one you want.
Set or change the default currency
To change default currency in Google Sheets for the whole file, go to File, Settings, then change the Locale. The locale controls the default currency, decimal separator, and date formatting. If your sheet is set to the wrong region, changing the locale is the right fix for how to set currency in Google Sheets at the file level.
Use cell formatting if only one table needs a different currency. Use locale settings if the whole spreadsheet should use a different default currency.
Convert currency on a specific date
If you need currency conversion on date in Google Sheets, use the historical rate version of GOOGLEFINANCE. This matters for accounting records, past invoices, and month-end reports where the current rate is not correct.
Historical exchange rate formula
Use this structure:
=GOOGLEFINANCE(“CURRENCY:USDEUR”,”price”,DATE(2025,1,15))
That returns the USD to EUR rate for January 15, 2025. You can multiply that result by your amount to get the converted value for that date.
For a date in a cell, use:
=A2*GOOGLEFINANCE(“CURRENCY:USDEUR”,”price”,B2)
Here, A2 is the amount and B2 is the date. This is the most direct currency conversion formula Google Sheets supports for time-specific pricing.
Troubleshoot common currency conversion problems
Most problems come from an invalid currency code, a bad cell reference, or a formatting mismatch. Google Sheets currency formula functions expect three-letter currency codes such as USD, EUR, GBP, JPY, and CAD.
When the formula returns an error
Check that both currency codes are valid and in the right order. USDGBP means from US dollars to British pounds. If the formula uses the wrong pair, the result will be off by a large amount. Also check that your amount cell contains a number, not text.
When the number looks wrong
If the result is correct but the display looks strange, apply currency formatting to the result cell. A plain number can appear without a currency symbol, which makes it seem incomplete. If you are editing existing data, use how to edit currency in Google Sheets by changing the cell format, not the value itself.
When you need manual conversion instead
Use a fixed rate if you need a locked exchange rate for a contract or report. Put the rate in one cell, enter the number manually, and multiply by that cell. This avoids changes when the live market rate updates.
Frequently Asked Questions
How do I put currency in Google Sheets?
Select the cells, then go to Format, Number, Currency. To choose a specific symbol, open More currencies and pick the one you need. This changes the display, not the underlying value.
What is the currency converter Google Sheets formula?
The standard formula is =A2*GOOGLEFINANCE(“CURRENCY:USDEUR”) for converting an amount from USD to EUR. Replace the amount cell and currency pair with your own values.
Can Google Sheets convert money using a date?
Yes. Use GOOGLEFINANCE with the price attribute and a DATE() value, then multiply by the amount. This gives you a historical money conversion instead of today’s rate.
How do I change the default currency for the sheet?
Open File, Settings, then change the spreadsheet Locale. That changes the default currency, decimal style, and other regional settings for the file.
Related Posts:
Google Sheets
- How to Delete Columns in Google Sheets
- How to Insert Multiple Rows in Google Sheets
- How to Convert Google Sheets to PDF
- How to Reference Another Sheet in Google Sheets
- How to Save Google Sheets to Your Computer
- How to Hide Formulas in Google Sheets
- How to Protect Cells and Sheets in Google Sheets
- How to Delete or Remove a Filter View in Google Sheets
- How to Calculate Totals in Google Sheets
- How to Sort Numbers in Order in Google Sheets
- How to Link Google Sheets to Google Calendar
- How to Resize Cells to Fit Text in Google Sheets
- How to Sort by Date in Google Sheets
- How to See Edit History in Google Sheets
- How to Make a Graph in Google Sheets
- How to Print Google Sheets on One Page
- How to Rename a Column Header in Google Sheets
- How to Export Google Sheets to CSV (and Import One)
- How to Search in Google Sheets
- How to Change Row Height in Google Sheets
- How to Insert or Remove Page Breaks in Google Sheets
- How to Add Cells and Columns in Google Sheets (SUM)
- How to Delete Multiple Google Sheets at Once
- How to Change Cell Color With a Formula in Google Sheets
- How to Lock a Formula or Cell in Google Sheets
- How to Add Bullet Points in Google Sheets
- Google Sheets Won’t Let You Edit: Fixes
- How to Merge Cells in Google Sheets
- How to Calculate Hours Worked in Google Sheets
- How to Subtract in Google Sheets