Sheet links
Every address that answers as a table, how the table is built, what a link costs and what a cell shows when something is wrong.
A sheet link is a Narwhal address that answers with a table a spreadsheet can read. It is a normal GET address with format=csv and a Sheets key at the end.
https://api.narwhalapi.com/v1/fx/rates/USD?currencies=EUR,IDR&format=csv&key=YOUR_SHEETS_KEYcurrency,rate,timestamp,stale
EUR,0.90718,2026-11-15T16:00:00Z,false
IDR,18222.7,2026-11-15T16:00:00Z,falseParameters
| Parameter | Required | Meaning |
|---|---|---|
format=csv | yes | Answer as a table. |
key | yes | A Sheets key from Team and keys in your dashboard. An API key is refused here. |
| the route's own | as the route says | The same parameters as the JSON call, for example start, end, currencies, countries. |
Addresses
Replace the words in braces. Country is a three-letter code such as USA.
| Data | Address after https:/ |
|---|---|
| Holidays in a year | / |
| Next holiday | / |
| Release calendar | / |
| CPI, latest and history | /, / |
| Inflation | /, / |
| GDP | /, / |
| GDP growth | /, / |
| Unemployment | /, / |
| Labour force participation | /, / |
| Trade | /, / |
| Any series | / |
| Policy rate | /, / |
| Rate decisions | / |
| Central bank reserves | / |
| Equity risk premium, all countries | / |
| Equity risk premium, one country | /, / |
| Commodity prices, all | / |
| One commodity | /, / |
| Exchange rates | /, /, / |
| Rate decision odds | /, / |
How the table is built
- One header row, then one row per item. A call that returns one thing gives one row.
- A nested field becomes a column with a dot, such as
value.actual. - A list of plain values is joined with
;. - An empty value is an empty cell. True and false are
trueandfalse. - Numbers keep the exact text the API sends.
- The release calendar gives one row per release, sorted by time.
value_says how many figures a release has; the row shows the first.count - A call with no rows gives an empty answer.
What a link costs
A link is the address with your key. Its first load on a day costs what that call normally costs. Every other load of the same link that day is free. Days change at midnight UTC. Changing anything in the address makes a new link.
What a cell shows when something is wrong
The cell shows one line. The answer has HTTP status 200 so a spreadsheet displays it; the real status is in the x-narwhal-status header.
| Line in the cell | Real status |
|---|---|
| Narwhal: this Sheets key is switched off or not valid. Copy a new link from https://narwhalapi.com/dashboard. | 401 |
| Narwhal: this is an API key, not a Sheets key. Make a Sheets key at https://narwhalapi.com/dashboard and use it in the link. | 401 |
| Narwhal: a Sheets key reads data routes only, and the link must end in format=csv. | 403 |
| Narwhal: out of credit. Add credit at https://narwhalapi.com/dashboard and refresh this sheet. | 402 |
| Narwhal: too many requests. This sheet will update on its next refresh. | 429 |
| Narwhal: bad parameter. (what is wrong) | 400 or 422 |
Next
Was this page helpful?