Google Sheets feed: live numbers with =IMPORTDATA()
Most people who want their numbers in a spreadsheet do not want to write code or connect another Google app.
Put your quietstats numbers in a Google Sheet with one formula. No Apps Script, no add-on and no Google sign-in.
Why quietstats: you get this without cookies, a consent banner or storing IP addresses, in every plan including Free.
In every plan, including Free. Data in and out.
📘 Step-by-step guide, with screenshots and diagrams →
Start free, no cardSee live demo
- No cookies or consent banner
- No IP addresses stored
- Groups under 5 visitors hidden
- 845-byte script
- Free plan, no card


What it is
A Google Sheets feed key belongs to one site and can only read that site’s totals as CSV. quietstats shows ready-made =IMPORTDATA() formulas when you create it: headline numbers, visitors per day, top pages, sources and topics, and any other report works by changing the link. Google Sheets refreshes the formulas about once an hour.
Why it matters
Most people who want their numbers in a spreadsheet do not want to write code or connect another Google app. A link that returns CSV is the simplest thing that works.
How it works
- Settings → API keys: name the key, pick the site and choose “Google Sheets feed”.
- Copy one of the formulas shown (the key appears only once) into a cell in Google Sheets.
- Change the report or period in the link if you like, for example timeseries.csv?period=90d&interval=week.
- Revoke the key to stop every link straight away.
Privacy: what is and isn’t collected
Collected
- Nothing new
Never collected
- Your Google account: there is no Google sign-in
- Visitor IDs, IP addresses or single visits
- Cookies, localStorage or anything else stored on the visitor’s device
- IP addresses or user agents (used in memory, then discarded)
- Anything that links a visitor across days (the visitor ID resets daily)
Rows and limits
- Anyone with a link can read that one site’s totals, so share the sheet with care
- Results are refreshed at most every 10 minutes on our side and about hourly by Google
- Counts towards the key’s hourly limit only when the data is refreshed
- One site per key; up to 10 active keys of any kind
“Rows” are database rows written, which is what our hosting is billed on. Reads are not rows written. Methodology →
Questions
Does it work in Excel?
Yes: Excel’s Data → From Web accepts the same CSV link.
Is the key safe in a link?
It can only read one site’s totals as CSV and nothing else, and you can revoke it at any time. Treat the sheet like a shared report.
Which reports can I use?
aggregate, timeseries, breakdown, events, pathways, landing, groups, engagement, topics, products, places, page and ab_tests.
Related features
Data in and outStats API
Data in and outCSV and Excel downloads
Data in and outPivot table: cross any two dimensions
Data in and outDuplicate addresses: one page, several addresses
Data in and outFree import from Google Analytics, Plausible and Fathom
Data in and outSearch keywords from Google Search Console
Sources and campaignsData health check: is your data complete?
Data in and out
All data in and out features → · All features → · Docs: Google Sheets feed guide → · Compare features with other tools →
Guides on this topic
Set it up
=IMPORTDATA("https://quietstats.co.uk/feed/qs_your_feed_key/breakdown.csv?period=30d&property=page&limit=50")Replace YOUR_SITE_ID with the ID on your site’s settings page. Install guides →
Try it on your own site
Free during launch: one site and 5,000 pageviews a month, no card needed. After launch, paid plans start at £5 a month.