Coberry

How to Export YouTube Comments

YouTube provides no native way to export comments of a video. To help you export all comments, this tutorial shows you how to use Coberry’s free tool to download them for Excel.

  • Matthias Hagemann

Exporting YouTube comments can be done within minutes, often seconds. If you are planning to scrape all comments of one or more videos, the Coberry tool can help you get the task done intuitively, without technical hurdles.

Why Download All Comments

According to the users we’ve spoken to, there are various reasons why downloading all comments of a YouTube video can save your time:

  • You may be running a contest and want to choose a random winner for giveaways.
  • Explore and analyze comment data in CSV with a spreadsheet software.
  • Check timestamps to find out when your audience is active. A graph within Coberry’s dashboard visually shows you the activity at each hour of the day.
  • Identify top commenters and fans on YouTube channels.
  • Save and backup comments before deleting your video.
  • Conduct sentiment analysis on comments with like counts.

How to Export to Excel

Comments can be exported in CSV and you can open the file in Excel for further data analysis. Since YouTube does not provide a built-in functionality to export video comments, users search for third-party solutions like Coberry to fulfill this task.

1. Create Account on Coberry

Sign up with your email address to create a free account. We don’t ask you for any personal details. You just need a valid email address as it needs to be confirmed.

2. Initiate a New Export

Once logged in your dashboard, click the New Export button. A dialog appears in which you can paste the URL to a YouTube video.

Export YouTube video comments.

Depending on the popularity of the video, the export process may take a while to complete. A few hundred comments should finish within a few seconds, but it can easily last a few minutes if a video has tens of thousands of comments.

You’ll be redirected to the asset’s page. We call a YouTube video an asset. To do some basic analysis, you can apply filters on the comments inside the dashboard such as

  • sort comments chronologically, by likes or replies
  • filter comments by keyword or commenter name

You can also do a sentiment analysis on each comment to get a positive, neutral or negative rating for the natural language. Click the Analyze Sentiment button when hovering over a comment.

3. Download All Comments

For a deeper analysis in Excel or in another software, you can download all comments as CSV or TXT file by pressing the Save button on the top right.

Asset page of a finished comment export.

The exported CSV contains all data available for a comment, including:

  • Comment ID and direct link to the comment on YouTube
  • Name of the commenter (author) and link to the commenter’s channel
  • Comment text
  • Email addresses detected
  • Statistical data such as likes and replies count
  • Timestamp of the published date

You can also customize which columns you need during export.

Updated October 26, 2020

Understand your audience better.

With Coberry, you can download all comments of a YouTube video and perform analytics fast. Gain more insights from your audience’s feedback.

Create Free Account

Other Recent Posts