Skip to content
fetch.li
Get a key

Spreadsheets and no-code

Live UK cells
without Apps Script.

Google Sheets can call public URLs. fetch.li returns answer as a one-liner with format=text, or a proper table with format=csv. Every successful GET still leads with ok, answer, and say in JSON mode.

Full Sheets guide Try a live GET
  • 8 / 10s burst
  • 12 / minute
  • 60 / hour

IMPORTDATA

Formulas that stay readable

Prefer format=text or format=csv over regex on JSON. Google runs the fetch from Google's servers, so the whole org shares one demo IP bucket.

One cell

format=text

=IMPORTDATA("https://fetch.li/v1/fx?from=GBP&to=EUR&amount=100&format=text")

Returns the answer string only. Good for FX lines, coat checks, and VAT totals.

A table

format=csv

=IMPORTDATA("https://fetch.li/v1/uk/bank-holidays?year=2026&format=csv")

Spreads into rows and columns. Ideal for holiday calendars and anything you would otherwise paste from GOV.UK.

Shared demo

60 requests per hour

The public demo allows 8 calls per 10 seconds, 12 per minute, and 60 per hour per network. When Sheets calls fetch.li, that network is Google's, not yours. Many volatile IMPORTDATA cells across a large workspace can hit 429s. Cache values, use manual recalculation, or move heavy jobs to a server with a Bearer key.

Spreadsheets and no-code guide · Demo limits