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
A packaged add-in can add custom worksheet functions for repeatable analyst workflows.
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 workflow
Power Query is the supported path today. A packaged add-in is the natural next step for custom worksheet functions and repeatable analyst workflows.
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
The same endpoint patterns also support Power BI Web connector reports, Outlook calendar workflows around release dates, and Microsoft 365 Copilot workflows.