How-toResearch

How to Export Pinterest Data to CSV, Excel or Google Sheets

Export Pinterest pin data, including saves, comments, creators and links, to a CSV file for Excel or Google Sheets. Step-by-step, plus spreadsheet ideas.

PinBee Team4 min read
How to Export Pinterest Data to CSV, Excel or Google Sheets

Pinterest research gets serious the moment you put it in a spreadsheet. Instead of scrolling and trying to remember which pin had more saves, you can sort, filter, chart and share your findings like real data.

The problem: Pinterest has no "export" button for search results or other people's pins. This guide shows the ways to get Pinterest data into a CSV file you can open in Excel or Google Sheets, and what to do with it once it is there.

What data can you export?

There are two very different kinds of Pinterest data:

  1. Your own account analytics. Impressions, saves, outbound clicks and audience data for pins you published. Pinterest Analytics can export this for business accounts.
  2. Research data about any pin. Saves, comments, creators, links and dates for pins in a search, a board or a competitor's profile. Pinterest does not export this, so you need a tool.

This guide covers both, with a focus on research data, since that is where most people get stuck.

Method 1: Export your own analytics from Pinterest

If you have a Pinterest business account:

  1. Open Analytics from your Pinterest business menu.
  2. Choose the date range and filters you want.
  3. Look for the Export option and download the CSV.

This is great for tracking your own performance over time, but it only includes your pins. It cannot tell you how competitors' pins or a niche perform.

Method 2: Export research data with PinBee

PinBee is a Pinterest analytics extension for Chrome, Edge and Firefox. It reveals the numbers Pinterest hides on every pin, and PinBee Pro can export them to CSV.

  1. Install PinBee and activate Pro (Yearly includes a 3-day free trial).
  2. Search Pinterest for your keyword.
  3. Load more results by scrolling, or use auto-scroll to collect them automatically.
  4. Apply any filters you want, for example only pins from the last 30 days or over 1,000 saves.
  5. Click CSV to download the results.

From your Library

PinBee saves every pin you scan into a private Library on your computer, so research from many sessions builds up in one place. Open the Library, search or filter it, and export what you need to CSV in one click.

From advertisers and accounts

Pro also exports specialised lists:

What the CSV contains

Each row is a pin, with columns such as its link, title, image link, engagement numbers (saves, reactions, shares, repins, comments), a last-activity date, the creator, the account that shared it and the source website, plus video and advertiser details where available. If you scanned a pin more than once, each scan gets its own row, so you can see how its numbers changed. The file opens directly in Excel, Google Sheets, Numbers or any data tool.

Method 3: Copy by hand

You can always open pins one by one and type the numbers into a spreadsheet. For five pins, that is fine. For a hundred, it takes hours, and Pinterest hides many numbers from the search grid anyway. A tool is worth it once research becomes a habit.

Opening the CSV

Google Sheets: File, then Import, then Upload, and choose the CSV. Select "Replace spreadsheet" or "Insert new sheet".

Excel: open the file directly, or use Data, then From Text/CSV, if accented characters or emoji look wrong. Choose UTF-8 encoding.

Turn on a filter row (Data, then Create a filter in Sheets; Sort and Filter in Excel) so you can sort any column instantly.

Six useful things to do with Pinterest data

1. Rank ideas by momentum

Add a column for saves per day: saves divided by the number of days since the pin's date. Sorting by this column shows what is growing fastest, which is the same idea behind PinBee's viral score.

2. Compare formats

Use a pivot table to compare average saves for video vs static pins in your niche. It tells you which format your audience prefers.

3. Find the winning websites

Count how often each source website appears among the top pins. The sites that keep winning are the ones to study, or to partner with.

4. Build a content calendar

Filter to pins from the same season last year and sort by saves. That is your list of proven seasonal ideas to plan for this year.

5. Track a competitor over time

Export a competitor's account analysis every month and compare. You will see which topics they push and which ones stick.

6. Share with a client or team

A clean spreadsheet with a few charts is far more convincing than screenshots when you recommend a Pinterest strategy.

Tips for clean data

  • Filter before exporting so the file contains only relevant pins.
  • Note the date you exported: engagement numbers change over time.
  • Keep one sheet per keyword or project, and a master sheet that combines them.
  • Remember the numbers are a snapshot. Re-export to update.

The bottom line

Pinterest only exports your own analytics. To get research data on any pin, search, board or competitor into Excel or Google Sheets, use a tool like PinBee Pro, which exports searches, your Library, advertisers and account analyses to CSV in one click.

Get PinBee free, and start a 3-day Pro trial when you are ready to export. New to the numbers? Start with how to see pin stats on Pinterest.

All articles