Excel
Connect Excel to Scrolls with Power Query — no Python, no formulas required.
Option A — OData feed
In Excel: Data → Get Data → From Other Sources → OData Feed, then enter:
http://localhost:8000/odata/Navigator will list entity sets and functions, including:
| Resource | Path |
|---|---|
| FRED catalog | /odata/FredCatalog |
| FRED observations | /odata/FredObservations |
| FRED wide series | /odata/FredSeriesWide?series_ids=GDP,UNRATE |
Option B — CSV From Web
Data → Get Data → From Web and paste a CSV URL:
http://localhost:8000/fred/catalog.csv
http://localhost:8000/fred/series.csv?series_ids=GDP,UNRATE&start_date=2020-01-01The same pattern works for other sources: replace fred with edgar, bls, census, eurostat, imf, or bis.

