Start free
new

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
Google Sheets feed: live numbers with =IMPORTDATA(): example screenshot with made-up demo dataGoogle Sheets feed: live numbers with =IMPORTDATA(): example screenshot with made-up demo data
ExampleScreenshot with made-up demo data, not a real customer’s numbers.

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

  1. Settings → API keys: name the key, pick the site and choose “Google Sheets feed”.
  2. Copy one of the formulas shown (the key appears only once) into a cell in Google Sheets.
  3. Change the report or period in the link if you like, for example timeseries.csv?period=90d&interval=week.
  4. 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)

How quietstats works, and the legal caveats →

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

All data in and out features → · All features → · Docs: Google Sheets feed guide → · Compare features with other tools →

Guides on this topic

All website analytics guides →

Set it up
HTML
=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.

Start freeSee pricingSee live demo

Explore quietstats

See your traffic (119)

Live visitors and live eventsTrend charts, headline cards and any date rangeCompare any two date rangesWorld map, countries and regionsDevices, browsers, operating systems and screens

Sources and campaigns (63)

Sources and channelsAI search referralsUTM campaignsSearch keywords from Google Search ConsoleShort links

Behaviour and content (80)

Top pagesPage transitionsScroll depth and engaged timeClick mapVisitor journeys

Goals, events and conversions (83)

Goals and funnelsCustom events and conversion ratesRevenue cards and revenue by sourceEngagement goalsA/B tests with your own tags and a plain-English confidence note

Reports, sharing and alerts (44)

Alerts inbox and rulesReport snapshotsPassword-protected snapshotsOptional public stats pageAnonymous benchmarks against similar sites

Data in and out (42)

CSV and Excel downloadsStats APIImport from Plausible or GA4API playgroundTSV and XML export for every report

Privacy and performance (17)

Zero cookies, privacy built inUnder 1 KB script and single-page appsPages never countedPrivacy proof page and badge for your siteSigned-in sessions

Why quietstats

Why quietstatsPricingLive demoStart free

Compare

quietstats comparedFeature comparisonvs Google Analyticsvs Plausiblevs Fathom Analyticsvs Simple Analyticsvs Umamivs Matomovs Cloudflare Web Analyticsvs GoatCountervs Piwik PROvs PostHogvs Microsoft Clarityvs Pirsch Analyticsvs MixpanelGoogle Analytics alternatives

Learn

Website analytics guidesMetrics handbookAnalytics glossaryPlaybooksGDPR and cookie-free analyticsInstall on SquarespaceInstall on WixInstall on GhostInstall on Google Tag ManagerBlog

Playbooks and tools

Script size calculatorCookie banner checkerPlaybook: Local businessPlaybook: Online shopPlaybook: Blog or publisherPlaybook: SaaS or appPlaybook: Charity or community groupPlaybook: Agency with clientsUTM link checkerConversion rate calculatorCookie banner traffic-loss calculator