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 I spoke 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. 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.
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. A YouTube video is called 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.
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.
Aiming for the Best Customer Experience
Edit (2020-01-19): Let me conclude this article with a story from my customer Wally who used Coberry to extract all video comments for a giveaway:
Coming into the end of 2020, I had two requirements to finish off the year: Analyze the comments provided on my YouTube channel (over 10,000), and satisfy a promotional giveaway based on views posting the MOST comments on the channel for 2020. Last year, the process I used last year took me 6 hours with lots of cut and paste. Using Coberry, I finished pulling the comments for 100 videos into a spreadsheet in around 1 hour and know the accuracy is 100%! Peace of mind! I will be using Coberry next year for sure.