Currency
+
Google Sheets
+
Microsoft Excel

Currency conversion in your spreadsheet

Get live, refreshable currency conversion in Microsoft Excel and Google Sheets.

Convert currency, with live or historical data, in your spreadsheet

This Foreign Exchange Currency Conversion utility uses rates available through the Foreign exchange rates API service. This service provides a free exchange rates API for current and historical foreign exchange rates published by the European Central Bank. This Currency Conversion spreadsheet integration for Google Sheets and Microsoft Excel enables you to convert currencies as well as list currency rates. This add-on will enable you to integrate on-demand, refreshable currency conversion without leaving your spreadsheet.

For example, with this Excel and Google Sheets add-on you can:

  • Convert a currency amount to another currency, at current rate or rate based on a historic date.
  • List foreign exchange rates for a basket of different currencies, at the current rates or based on a historic date.

Click here to learn more about the specific syntax for each of the Currency Conversion spreadsheet functions.

Demonstration

Getting Started

Flex.io makes it easy to create, use and share custom spreadsheet functions that import data from services you know and love. Click on the button below to use the currency conversion function collection with Microsoft Excel or Google Sheets.

Need Help?

Have questions? Need help with installation? Need other Foreign Exchange functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Currency Converter

Returns an amount in one currency type from an amount in another currency type

Syntax

=FLEX("YOUR_TEAM_NAME/currency-converter", amt, cur1, cur2, [date])

Parameters

Property Type Description Required
amt number The value to convert from one currency to another true
cur1 string The currency type to convert from true
cur2 string The currency type to convert to true
date date The exchange rate date false

Sample Usage

=FLEX("YOUR_TEAM_NAME/currency-converter", 100, "USD", "EUR")
=FLEX("YOUR_TEAM_NAME/currency-converter", 200, "EUR", "USD", "2018-12-31")
=FLEX("YOUR_TEAM_NAME/currency-converter", A1, B1, C1)

Notes

This function uses the https://exchangeratesapi.io API to convert the rates from one into another.

The following currency types are allowed: CAD, HKD, ISK, PHP, DKK, HUF, CZK, GBP, RON, SEK, IDR, INR, BRL, RUB, HRK, JPY, THB, CHF, EUR, MYR, BGN, TRY, CNY, NOK, NZD, ZAR, USD, MXN, SGD, AUD, ILS, KRW, PLN

Currency Exchange Rates

Returns a list of currency exchange rates for a particular currency and date

Syntax

=FLEX("YOUR_TEAM_NAME/currency-rates", cur, [date])

Parameters

Property Type Description Required
cur string The currency type to use as the base true
date date The exchange rate date false

Sample Usage

=FLEX("YOUR_TEAM_NAME/currency-rates", "USD")
=FLEX("YOUR_TEAM_NAME/currency-rates", "EUR", "2018-12-31")
=FLEX("YOUR_TEAM_NAME/currency-rates", A1, B1)

Notes

This function uses the https://exchangeratesapi.io API to list the rates.

The following currency types are allowed: CAD, HKD, ISK, PHP, DKK, HUF, CZK, GBP, RON, SEK, IDR, INR, BRL, RUB, HRK, JPY, THB, CHF, EUR, MYR, BGN, TRY, CNY, NOK, NZD, ZAR, USD, MXN, SGD, AUD, ILS, KRW, PLN

Use Currency in your spreadsheet now!