> For the complete documentation index, see [llms.txt](https://help.sortpin.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.sortpin.com/features/sortpin-export-csv.md).

# How to Export Your SortPin Data to CSV

How to export SortPin data to CSV — where the button is, what to do before you click it, and why the 7-day cleanup makes exporting necessary.

{% hint style="success" %}
**Every dashboard has an Export CSV button**, so pins, boards and pinners can all leave SortPin as a spreadsheet. This matters more than it sounds: collected data is deleted after 7 days, so exporting is the only way to keep anything.
{% endhint %}

> 📍 **Where to find it:** open any dashboard — **Pins**, **Boards** or **Pinners** — and look above the results, next to the red clear button.

<figure><img src="https://2471944289-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F1dyhQmzVZzoiyGruwgGi%2Fuploads%2Fgit-blob-f25788bf7b3bb8b4115fa12ef0de7d1a2f0b02f7%2Fsortpin-dashboard-all-pins.png?alt=media" alt="The Export CSV button on the SortPin dashboard"><figcaption><p>The green <strong>Export CSV</strong> button sits above the results on every dashboard</p></figcaption></figure>

## ⚡ The Short Version

1. Open the dashboard holding what you want — **Pins**, **Boards** or **Pinners**
2. Pick the **sub-tab** that matches (Videos, Promoted, AI, Collaborative, Lead…)
3. **Search, filter and sort** until the list is what you want
4. Click **Export CSV**
5. Open the file in Excel, Google Sheets or Numbers

***

## 🎯 Narrow Before You Export

This is the step that makes the difference between a useful file and an unusable one.

A raw export of 34,000 pins is technically your data and practically a wall of noise. A few seconds of narrowing first gives you something you'll actually open twice.

| Want                       | Do this first                           |
| -------------------------- | --------------------------------------- |
| 🎥 Only video pins         | Pins dashboard → **Videos** sub-tab     |
| 💲 Competitor ads          | Pins dashboard → **Promoted** sub-tab   |
| ✨ AI-flagged pins          | Pins dashboard → **AI** sub-tab         |
| 🏆 Best-performing content | Sort by **Most Saves**                  |
| 🤝 Group boards            | Boards dashboard → **Collaborative**    |
| 👥 Outreach leads          | Pinners dashboard → **Lead** sub-tab    |
| 🔍 One creator's pins      | Pins dashboard → **Search for Pinners** |

> ✅ **Check the row count after opening the file.** Compare it with the **"Showing 1 to X of Y results"** line you saw before exporting. If the numbers don't line up the way you expected, re-apply your filter and export again — it's quicker than untangling the spreadsheet afterwards.

***

## 📊 What to Do With the File

### Sort and rank

In Sheets or Excel, sort by the saves column. That alone turns a collection into a ranked list of what works in your niche — the same job the dashboard does, but permanent.

### Compare over time

Export the same search monthly. Two files a month apart show you what's rising, which no single snapshot can.

> 📅 **This is the real reason to export on a schedule.** The 7-day cleanup means SortPin can never show you a trend over months. Your own exports can.

### Build an outreach list

The Pinners dashboard's **Lead** tab exports the people worth contacting. 📚 [Full workflow](https://help.sortpin.com/how-to-get-email-addresses-for-email-marketing-for-free.md)

### Hand work to someone else

A CSV goes to a VA, a client or a teammate without them installing anything.

***

## ⏳ Why Exporting Isn't Optional

Every dashboard says it plainly: *"We'll automatically clean up your data after 7 days."*

|                       | SortPin dashboard | Your exported CSV |
| --------------------- | ----------------- | ----------------- |
| Lifespan              | **7 days**        | Forever           |
| Works after uninstall | ❌                 | ✅                 |
| Shareable             | ❌                 | ✅                 |
| Compare across months | ❌                 | ✅                 |

> 💾 **Treat the dashboard as a working surface and the CSV as the record.** Anyone doing research across more than a week needs the habit of exporting at the end of each session — otherwise the work quietly disappears.

***

## 🛠️ Troubleshooting

### "The file is enormous"

You exported everything. Use a sub-tab, search or filter first, then export again.

### "Accented or non-English text looks wrong in Excel"

A character-encoding mismatch, not a corrupted file. Rather than double-clicking the CSV, use **Data → From Text/CSV** in Excel and choose **UTF-8**. Google Sheets handles it correctly on import without any of this.

### "Nothing downloaded"

Check your browser didn't block it, and look in your Downloads folder — browsers often save without any visible prompt.

### "Fewer rows than I expected"

A filter or sub-tab is still active from earlier. Clear filters, confirm the **Showing … of …** total, then export.

### "I need data from last month"

It's gone — the 7-day cleanup removed it. Nothing can recover it, which is the argument for exporting as you go.

***

## ❓ FAQs

**Q: How do I export my SortPin data?** A: Open any dashboard and click **Export CSV**, the green button above the results.

**Q: Can I export boards and pinners too?** A: Yes. All three dashboards — Pins, Boards and Pinners — have their own Export CSV button.

**Q: Does exporting need a Pro licence?** A: No. Export is available on the dashboards alongside the other free controls.

**Q: What format is the file?** A: CSV, which opens in Excel, Google Sheets, Numbers, or any spreadsheet tool.

**Q: Can I export only the pins from one creator?** A: Yes — use **Search for Pinners** on the Pins dashboard to narrow first, then export.

**Q: How often should I export?** A: At the end of any research session. Data is deleted after 7 days, so anything unexported is on a timer.

**Q: Will exporting slow Pinterest down?** A: No. It reads data already stored locally and doesn't touch Pinterest.

**Q: Can I re-import a CSV back into SortPin?** A: Export is one-way. The file is for spreadsheets and sharing, not for restoring into the extension.

***

## 👉 Related Guides

* [📊 SortPin Dashboards — Pins, Boards & Pinners](https://help.sortpin.com/features/sortpin-dashboards.md)
* [🗂️ Collect Tab — Every Setting Explained](https://help.sortpin.com/features/sortpin-collect-settings.md)
* [📊 How to Sort Pinterest Pins by Saves, Date & Popularity](https://help.sortpin.com/pinterest-growth-and-analytics/how-to-sort-pinterest-pins-by-saves-date-and-popularity.md)
* [✉️ How to Get Email Addresses for Marketing](https://help.sortpin.com/how-to-get-email-addresses-for-email-marketing-for-free.md)
* [🙁 Displaying Data Slowly](https://help.sortpin.com/displaying-data-slowly.md)

{% hint style="info" %}
💬 **Export not behaving as expected?** Tell our [chat support](https://go.crisp.chat/chat/embed/?website_id=48b6c12a-2212-4be1-9e27-2dad7e2d5fb0) team which dashboard and which filters were active.
{% endhint %}
