← All guides

Guide

How to get Google Trends data into a spreadsheet

November 2026 · 6 minute read

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.

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, onceThe CSV download
Build something custom and don’t mind fixing itA Python library
Keep a running history with no upkeepA scheduled tool on Apify

Five mistakes that make comparisons wrong

  1. Comparing numbers from separate lookups. Put the terms in the same comparison, or they won’t share a scale.
  2. Changing the time range halfway through. Keep one range for a whole analysis, or every number shifts.
  3. Mixing countries. “Worldwide” and “United States” are different scales. Pick one and stay with it.
  4. 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.
  5. 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.