MYFRESHTOOLS
50% OFF
YouTube › Analytics

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 read
Quick answer
To export YouTube Analytics, open YouTube Studio → Analytics → Advanced mode, set the date range and metrics, then use the export button to save the table as a CSV file or send it to Google Sheets. That covers private metrics like watch time and impressions for your own channel. For public stats (views, likes and comments for every video, on any channel), export the channel with YouTube Channel Backup.

Studio'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.

Know what you need

Private analytics vs public stats

MetricWho can see itWhere to export it
Watch time, average view durationChannel owner and managersYouTube Studio
Impressions, click-through rateChannel owner and managersYouTube Studio
Traffic sources, audience, revenueChannel owner and managersYouTube Studio
Views, likes, comment countAnyoneStudio, or a channel export for any channel
Titles, descriptions, tags, publish datesAnyone (tags are hidden on the page but public in the data)A channel export
Your channel

Export analytics from YouTube Studio

Open Analytics in Studio

Go to studio.youtube.com and choose Analytics in the left menu.

Switch to Advanced mode

Click Advanced mode at the top right. This opens a table you can group and filter, instead of the summary cards.

Pick the date range and the grouping

Choose the range at the top (Lifetime, last 28 days, a custom range). The table is grouped by video by default; switch to traffic source, geography, date or another dimension if that's what you need.

Add the metrics you want

Use the metrics picker to add columns such as watch time, impressions or subscribers gained. Only the columns in the table go into the file.

Export the current view

Click the download icon and choose Google Sheets or a comma-separated values (.csv) file. The download includes the table data, the chart data and the totals.

Every row, not just what's on screen

The table shows a limited number of rows at a time, but the export includes all of them. You don't need to scroll or page through first.
Going further

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.

Any channel

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.


The tool

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

Connect YouTube if it's your channel and you want unlisted and private uploads too.

Run the export

The tool reads the uploads and builds the file.

Open the CSV

Open in Excel or Google Sheets, then join with your Studio export on the video ID if you need both.

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.
In practice

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.

Avoid these

Common mistakes

MistakeWhat goes wrongDo this instead
Exporting the summary cardsYou get totals, not per-video rowsUse Advanced mode before exporting
Comparing the last 28 days to lifetime countersNumbers never matchPick Lifetime, or compare like with like
Opening the CSV with the wrong encodingTitles with emoji or accents look garbledImport as UTF-8 (Data → From Text/CSV in Excel)
Joining files on titleDuplicate or renamed titles break the matchJoin 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.

Related MyFreshTools tools