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 collection of currency conversion spreadsheet functions enables you to convert amounts from different currencies or get a list of the latest foreign exchange rates for a basket of currencies, either from today or a historical date of your choosing. These functions use 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.

Learn more about currency conversion spreadsheet functions and syntax here.

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!