How to Download Data from Google Merchant Centre. And Why.
I use two spreadsheet formulas to find missing products and analyse Google Merchant Centre data. Find out how to download and manipulate TSV files here.
Downloading data from Google Merchant Centre (GMC) can be a useful way of analysing the performance of your products. But Google doesn’t exactly make it easy.
Most platforms give you download options like .csv, .xlsx, or Google Sheets. GMC doesn’t. If you download product data, it’s a .tsv file inside a .zip folder.
However, if you persevere and manage to open the file, you’ll unlock new options in terms of checking for issues and analysing the performance of your products.
More stories
What's happening in ChatGPT Ads? A round up from August 2026
We tracked 3,286 UK advertisers running ChatGPT Ads in August (up 14% MoM): here is how commercial adoption, creative copy, and automated bidding are shaping up.
Retail is heading into Black Friday with bot traffic surging. Here's what to do to minimize wasted ad spend
The Best Self-Made Automation Tool I've Built
The Death of the Static Product Title in AI Max Shopping
The click got easier to buy, and harder to understand
- 1How Postcode Bidding Increased Local Inventory Ad Impressions by 300% and Local Sales by 40%Teodor Yordanov · Strategy
- 2Are AI Overviews Killing Your PPC Performance? What The Data Tells UsMery Hayles · PPC
- 3Auditing your Advantage+ Shopping campaigns before they quietly waste your budgetTeodor Yordanov · Social Media Advertising
- 4Retail is heading into Black Friday with bot traffic surging. Here's what to do to minimize wasted ad spendBen Harris · News
- 5MER vs ROAS: How to Create an MER Target That Actually Means SomethingCraig Graham · Measurement
Across the Desks
What's happening in ChatGPT Ads? A round up from August 2026
Retail is heading into Black Friday with bot traffic surging. Here's what to do to minimize wasted ad spend
How to Download Data from Google Merchant Centre. And Why.
Master the Search Page: How I Am Combining SEO and PPC to Maximise Visibility while Slashing Budget Waste
Stop Clicking, Start Prompting: How I Use GSC’s New AI Features (Agency vs. In-House Playbook)
The Best Self-Made Automation Tool I've Built
AI Watermarks are coming & why you won't care
The Content desk is opening shortly. Vetted practitioners are welcome to file: contribute a piece.
Stop reacting to daily noise. Defend fewer, better numbers.
· From the Measurement Desk