Guide
How to get Google Trends data into a spreadsheet
Google Trends is one of the best free signals for what people care about, but getting its numbers out of the website and into a spreadsheet is fiddlier than it should be. This guide explains what the numbers mean, compares three ways to export them, and lists the mistakes that quietly ruin comparisons.
First, what the numbers mean
Google Trends doesn’t show search volume. Every chart is scaled from 0 to 100, where 100 is the busiest point for that search term, place and time range. Everything else is relative to that peak.
- The scale changes with your settings. Change the time range or the country and the same week can get a different number, because the peak it’s measured against has changed.
- Terms are only comparable in the same chart. Two terms compared together share one scale. Two terms looked up separately each have their own 100, so their numbers can’t be compared directly.
- The data is a sample. Trends works from a sample of searches, so pulling the same query on different days can give slightly different values, especially for small terms.
- Small terms show as zero. When there isn’t enough search activity, Trends shows 0 rather than a low number.
Option 1: download the CSV
Every chart on trends.google.com has a small download arrow in its top corner. It saves that chart as a CSV file you can open in Google Sheets or Excel.
Good for: a one-off check. Not great for: anything regular. It’s one chart at a time, the files need tidying before you can combine them, and you have to remember to do it.
Option 2: an unofficial Python library
Free libraries such as pytrends talk to the same endpoints the Trends website uses, so you can pull data with a few lines of code.
Good for: developers who want full control. Not great for: reliability. The endpoints aren’t an official API, so they can change without notice, and heavier use runs into “429 Too Many Requests” errors that need waiting, retries and proxies to get around.
Option 3: a hosted tool on the Apify Store
The Apify Store has ready-made tools, called Actors, that collect Google Trends data in the cloud. You type in your keywords, pick a country and time range, and get the results as JSON, CSV or Excel. Runs can be scheduled, so a sheet can fill itself up every day or week.
Good for: regular reporting and anyone who doesn’t want to maintain code. Not great for: zero budget, since you pay a small amount per run after Apify’s free monthly credit.
Our own Google Trends Scraper is on the Apify Store. It returns one tidy row per keyword, place and date, so the data drops straight into a spreadsheet without any reshaping.
Which one should you use?
| You want to… | Use |
|---|---|
| Check one chart, once | The CSV download |
| Build something custom and don’t mind fixing it | A Python library |
| Keep a running history with no upkeep | A scheduled tool on Apify |
Five mistakes that make comparisons wrong
- Comparing numbers from separate lookups. Put the terms in the same comparison, or they won’t share a scale.
- Changing the time range halfway through. Keep one range for a whole analysis, or every number shifts.
- Mixing countries. “Worldwide” and “United States” are different scales. Pick one and stay with it.
- Comparing more than five terms at once. Trends allows five per comparison. To go further, keep one “anchor” term in every batch and rescale the others against it.
- Not writing down when you pulled the data. Because the data is sampled, save the date of every pull next to the numbers.
If you need Trends data on a schedule, or a tool for another public source, get in touch.