Start free

How to use Google Sheets feed (IMPORTDATA)

Put your quietstats numbers in a Google Sheet with one formula. No Apps Script, no add-on and no Google sign-in.

Integrations, API & AIFeature page: Google Sheets feed: live numbers with =IMPORTDATA()
Google Sheets feed (IMPORTDATA): example screenshotGoogle Sheets feed (IMPORTDATA): example screenshot
Example screenshot with made-up data, not a real customer’s numbers.

What it does

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 to use it

  1. In Settings → API keys, pick the site and choose “Google Sheets feed”, then create the key.
  2. Copy a formula, for example =IMPORTDATA("…/feed/KEY/timeseries.csv?period=30d&interval=day"), into a cell.
  3. Change the report name or the query to get other numbers; the site is always the key’s own.
  4. To stop the sheet updating, revoke the key.

How it works

How a Sheets feed link works1. Google Sheets fetches /feed/KEY/report.csv about once an hour. 2. The key is checked: a Sheets feed key for one site, not revoked. (otherwise: Revoked or another kind of key: an error row.) 3. Fresh copy in the 10-minute cache? Send it. (otherwise: Otherwise build it and count one request.) 4. CSV of that site’s totals fills the cells.1Google Sheets fetches/feed/KEY/report.csv aboutonce an hour.2The key is checked: a Sheetsfeed key for one site, notrevoked.Revoked oranother kind ofkey: an errorrow.3Fresh copy in the 10-minutecache? Send it.Otherwise buildit and count onerequest.4CSV of that site’s totalsfills the cells.
From handleFeed in src/api.js. No Google sign-in.

Privacy

Limits

Plans

Every plan, including Free. quietstats is free during launch: the Free plan covers 1 site and 5,000 pageviews a month, and no card is needed. See pricing.

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.

Set it up

Show the install snippet
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 shown on your site’s Manage page.

Related

Feature page: Google Sheets feed: live numbers with =IMPORTDATA() → What it is, why it matters, privacy and how other tools do it.

Guides on this topic

All website analytics guides →

Related features

Browse all 448 features →

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