Use FXMacroData in Excel

Use five worksheet functions to bring macroeconomic indicators, FX rates, commodities, and release calendars into Excel. You can also load API data through Power Query.

Power Query from Web

In Excel, open Data > Get Data > From Other Sources > From Web, then choose Advanced, paste one of these URLs, and add an HTTP request header named X-API-Key with your API key as the value. Use the Power Query editor to expand the JSON rows into a table.

Latest USD inflation series

https://api.fxmacrodata.com/v1/announcements/usd/inflation
Header: X-API-Key: YOUR_API_KEY

Upcoming AUD release calendar

https://api.fxmacrodata.com/v1/calendar/aud
Header: X-API-Key: YOUR_API_KEY

EUR/USD FX history

https://api.fxmacrodata.com/v1/forex/eur/usd?start_date=2026-01-01
Header: X-API-Key: YOUR_API_KEY

Localized value example for locale routes

Locale routes should preserve the source value and add unit or currency comparison views without hiding the original publisher format.

Power Query M pattern

let
    Source = Json.Document(Web.Contents("https://api.fxmacrodata.com/v1/announcements/usd/inflation", [Headers = [#"X-API-Key" = "YOUR_API_KEY"]])),
    Rows = Source[data],
    TableRows = Table.FromRecords(Rows)
in
    TableRows

Excel add-in workflow

The add-in uses Excel custom functions and dynamic arrays. Use an up-to-date Microsoft 365 version of Excel on Windows or Mac, or Excel for the web. Excel on iPad and older perpetual Windows editions do not support this workflow.

Install from the manifest

1. Download the FXMacroData manifest and save the XML file to your computer.
2. In Excel for the web, open a workbook, choose Home > Add-ins > More Settings > Upload My Add-in, then browse to the saved XML file and select Upload. Some versions show this under Insert > My Add-ins.
3. Open Home > FXMacroData. For an organisation-wide installation, ask your Microsoft 365 administrator to deploy the same manifest through Integrated apps.

If uploading is unavailable, your organisation may restrict add-ins. Windows and Mac installation methods are covered in Microsoft's installation guide. Download the manifest here; installation does not require an AppSource listing.

Connect your account

Catalogue lookups and the USD calendar work without a key. Free USD indicator data covers the most recent 90 days, with a 15-minute delay after publication and 100 requests per day per IP. FX rates, commodities, non-USD data, and longer history require an active FXMacroData subscription.

Copy your key from API management into the FXMacroData pane, choose Save Key, then Test Key. Keep keys out of worksheet cells and formulas. The key is saved in Office add-in storage on this device/browser profile; use Clear Key before sharing that profile. Workbook collaborators can see returned data and need their own access to refresh protected formulas.

=FXMACRODATA.CATALOGUE("usd")
=FXMACRODATA.INDICATOR("usd","inflation")
=FXMACRODATA.CALENDAR("usd")
=FXMACRODATA.FOREX("eur","usd")
=FXMACRODATA.COMMODITY("gold")

Enter one formula in an empty area and press Enter. Results spill into adjacent cells; clear any blocking cells if Excel shows #SPILL!. Time-series formulas accept optional start date, end date, header, and row-limit arguments, for example =FXMACRODATA.INDICATOR("eur","inflation","2025-01-01",,TRUE,250).

Calendar times are UTC. When the publisher has announced a date without a time, the calendar shows Time TBA; it does not represent midnight as a confirmed release time. An empty result means no matching published data or schedule was returned.

For #NAME?, check that the add-in is installed and your Excel version supports custom functions. For an access error, save and test a subscription key. Re-enter a formula after changing the key to retry it. For help, contact info@fxmacrodata.com without including your API key.

Bulk downloads

Subscribers can take a currency's complete published history as one file instead of paging through the API. Each bulk file holds every public series for that currency and is refreshed daily. Open it from Data Studio → Bulk downloads while signed in, or fetch it directly:

https://fxmacrodata.com/data-export/bulk/usd.parquet
https://fxmacrodata.com/data-export/bulk/usd.csv.zip

Replace usd with any supported currency code. Columns: date (date32), indicator, val (float64), previous_value, announcement_datetime (UTC, millisecond timestamp), publication_time_status and revision_count. The zipped CSV holds the same table with ISO-8601 release times and opens directly in Excel or Power Query. Single-series downloads also accept format=parquet, which mirrors the CSV columns with typed values and adds a revisions JSON column.

import pandas as pd

usd = pd.read_parquet("fxmacrodata_usd_all_series.parquet")
cpi = usd[usd["indicator"] == "inflation"].set_index("date")["val"]