This tutorial explains how to download YouTube comments in Excel. YouTube Comments Scraper is a free online tool that intelligently scrapes YouTube comments and helps you download them in a CSV file. Also, you can opt to get the comments in JSON format as well. In the downloaded files, it lists the comment ID, name of the commentator, timestamps, comment text, likes, replies, etc. It can save the data in any of the specified file formats and after getting the comments, you can do whatever you want.
If you want to get all the comments from any YouTube video, then you can use this tool. Here it just takes the URL of the video and then scrapes the comment. However, the time it takes to get you all the comments depends on their number. If there are 100K comments then it will take a lot of time or can even fail. But it worked fine for me in downloading around 1000 comments from a YT video. You can use this tool without creating an account to get all the comments right in a CSV file.
How to Download YouTube Comments in Excel?
YouTube Comments Scraper is an open source tool as well. If you want to check out its source code then you can do that. Also, if you want to host it on your own server then you can do that too. If you have any idea of Docker then you can easily host it on a server like DigitalOcean.
To download YouTube comments from any video, access the homepage of YouTube Comments Scraper. After that, enter the URL of the video and proceed. It will show you the information of the video and then it will start scraping the comments. You can see the progress of the scrapping on the main interface of the website and then wait for the process to finish.
When it has scraped all the comments, it will show you all of them. If you want to read those comments then you can do that. By default, it shows the JSON preview of the comments. But you can switch to the spreadsheet view as well. Next, use the Download button from the top to download the comments. And choose the format in which you want to download the comments data. By default, it will include all the information in the final file like comment ID, comment text, number of likes, etc. But you can choose what data you want in the final CSV file.
In this way, you can use this free and open source tool to scrape YouTube comments and download them in an Excel compatible file. All you have to do is just use the URL of any YouTube video and get all the comments in CSV or JSON format. However, if the input video have many comments then it may take some time.
Also see: How to Download YouTube Playlist as CSV File
Final words
YouTube Comments Scraper is a very nice online tool that you can use to download YouTube comments. I really liked the way it works to get me the YouTube comments in an Excel spreadsheet. It is very useful for the sentiment analysis of a YouTube video. So, if you want to get all the comments on a YouTube video, simply use this tool and get the comments in a few minutes.
