Use FXMacroData in Excel
Pull macroeconomic indicators, central-bank policy rates, FX rates, and release-calendar data into Microsoft Excel using Power Query, direct API URLs, or the FXMacroData Excel add-in prototype.
No-code first
Use Excel's Data > From Web workflow to load JSON from production API endpoints.
Analyst friendly
Build CPI, policy-rate, FX, and release-calendar worksheets that refresh from the API.
Add-in path
The repo includes an Office.js add-in prototype with worksheet custom functions.
Power Query from Web
In Excel, open Data > Get Data > From Other Sources > From Web, then paste one of these URLs. Use the Power Query editor to expand the JSON rows into a table.
Latest USD inflation series
https://fxmacrodata.com/api/announcements/usd/inflation
Upcoming AUD release calendar
https://fxmacrodata.com/api/calendar/aud
EUR/USD FX history
https://fxmacrodata.com/api/forex/eur/usd?start_date=2026-01-01
Localized value example for locale routes
Original source value
Rs. 75 per litre
Localized comparison view
$3.41 per gallon
Local number system
Monthly household spend: Rs. 120,000
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://fxmacrodata.com/api/announcements/usd/inflation")),
Rows = Source[data],
TableRows = Table.FromRecords(Rows)
in
TableRows
Excel add-in prototype
The repository already includes an Excel add-in prototype under extensions/excel/. It is the right path for custom worksheet functions after local sideload testing.
Functions
FXMACRODATA.INDICATORFXMACRODATA.FOREXFXMACRODATA.CALENDARFXMACRODATA.CATALOGUE
First tests
=FXMACRODATA.CATALOGUE("usd")
=FXMACRODATA.INDICATOR("usd","inflation")
=FXMACRODATA.CALENDAR("aud")
=FXMACRODATA.FOREX("eur","usd")
Next Microsoft workflows
Excel is the first Microsoft workflow to validate. The same endpoint patterns also support Power BI Web connector reports, Outlook calendar workflows around release dates, and Microsoft 365 Copilot connector planning.