How to Export YouTube Analytics Data (Studio CSV and Per-Video Stats)
Studio exports your private metrics. A channel export covers the public ones, for any channel.
Published 18 November 2026 · 7 min readStudio's charts are fine for a glance, but the moment you want to sort videos by watch time, share numbers with a sponsor or build a monthly report, you need the data in a spreadsheet. YouTube does let you export it. The button is just easy to miss, and it only covers channels you manage.
This guide walks through the Studio export step by step, how to get every video in one file, and what to do when you need the same numbers for a channel that isn't yours.
Private analytics vs public stats
| Metric | Who can see it | Where to export it |
|---|---|---|
| Watch time, average view duration | Channel owner and managers | YouTube Studio |
| Impressions, click-through rate | Channel owner and managers | YouTube Studio |
| Traffic sources, audience, revenue | Channel owner and managers | YouTube Studio |
| Views, likes, comment count | Anyone | Studio, or a channel export for any channel |
| Titles, descriptions, tags, publish dates | Anyone (tags are hidden on the page but public in the data) | A channel export |
Export analytics from YouTube Studio
Open Analytics in Studio
Switch to Advanced mode
Pick the date range and the grouping
Add the metrics you want
Export the current view
Every row, not just what's on screen
Exporting more than one report
- Save the view. Studio remembers the comparison you built; reuse it each month so the columns line up when you combine files.
- One dimension per file. Each export covers one grouping. For "videos by traffic source", export per video or add a secondary dimension where Studio allows it.
- Automation needs the API. The YouTube Analytics API answers custom queries and the YouTube Reporting API produces scheduled bulk reports. Both need a developer project and code.
Studio is the right tool for your own private numbers. It can't help with a competitor's channel, a client channel you don't manage, or a list of every upload with its description and tags. For that you'd be copying from each video page by hand.
Export public stats for any channel
Public stats are enough for a lot of jobs: spotting a competitor's best videos, checking which of your own uploads still lack tags, or giving a client a list of every video with its view count. Join the file with your Studio export on the video ID column and you have private and public data side by side.
How MyFreshTools helps
What the tool does
YouTube Channel Backup exports a channel's uploads to a CSV: title, description, tags, thumbnail, view, like and comment counts, and the video URL. If you only need stats for one playlist, the YouTube Playlist Export does the same per playlist, with durations and dates, in CSV or Excel.
Who it's for
- Creators who want every upload's public numbers in one sheet.
- Marketers and agencies comparing channels they don't manage.
- Anyone building a report that mixes Studio data with titles and tags.
How to use it
Paste a channel link or @handle
Run the export
Open the CSV
Requirements and limits
- A free account is needed, and each run costs 1 credit.
- The free plan covers the latest 50 videos; paid plans export the full channel.
- Public metrics only. It can't read watch time, impressions, CTR, traffic sources or revenue; those stay in Studio.
- CSV output, no built-in schedule. Run it again for a fresh snapshot.
Examples
A monthly report for a sponsor
A creator exports Lifetime, grouped by video, with views, watch time and average view duration from Studio, then adds the channel export for titles and publish dates. Joined on video ID, the sponsor gets one sheet sorted by watch time, and the same saved view produces next month's version in minutes.
Sizing up a competitor
A marketer can't see a competitor's watch time, but a channel export gives every upload's views, likes and comment counts. Sorting by views per day since publishing shows which topics keep pulling an audience, without any private data.
Finding uploads with no tags
A channel manager filters the export's tags column for blanks and finds 40 older videos with none. That's a concrete fix list, which Studio's analytics alone wouldn't show, because tags aren't an analytics metric.
Common mistakes
| Mistake | What goes wrong | Do this instead |
|---|---|---|
| Exporting the summary cards | You get totals, not per-video rows | Use Advanced mode before exporting |
| Comparing the last 28 days to lifetime counters | Numbers never match | Pick Lifetime, or compare like with like |
| Opening the CSV with the wrong encoding | Titles with emoji or accents look garbled | Import as UTF-8 (Data → From Text/CSV in Excel) |
| Joining files on title | Duplicate or renamed titles break the match | Join on the video ID |
Frequently asked questions
Yes. In YouTube Studio's advanced mode, export the current view as a .csv file and open it in Excel, or choose Google Sheets and download it from there as .xlsx.
Not the private metrics. Watch time, impressions, click-through rate, traffic sources and revenue are only visible to the channel's owner and managers. Public numbers (views, likes, comment counts) can be exported for any channel.
Studio reports are filtered by the date range you picked and are finalised with a short delay, while the public counter is lifetime and live. Pick 'Lifetime' and wait a couple of days for recent videos before comparing.
In advanced mode, keep the table grouped by video, set the date range, and export. The export includes every row in the current table, not only the ones visible on screen.
Not from Studio. Developers can use the YouTube Reporting API for scheduled bulk reports, or the Analytics API for custom queries. Without code, set a reminder and export the same saved view each time.
The takeaway
Your private analytics come from Studio's Advanced mode export. Public stats for any channel come from a channel export. Put them together on the video ID and you have the full picture.