How to export YouTube comments to Excel
Open the video on YouTube, click the InsightSocial icon, pick how many comments you want (100, 250 or 500) and press Scrape. The extension opens reply threads as it goes and keeps going if you switch to another tab. When it finishes, download Excel, CSV or JSON, or send the rows to Google Sheets.
What each row contains
One row per comment or reply: the text, the author's name, channel ID and avatar, whether the author is verified, whether the comment was written by the video's own channel, likes, reply count, the date, and a link that opens the video at that comment. Replies carry the ID of the comment they answer, so you can rebuild each thread in a spreadsheet. Every row also names the video and its channel.
Dates come from YouTube's "3 weeks ago" text, so a recent comment is dated to the day and an old one to the month or year.
Picking the videos
To compare the comments across a channel's uploads, export the channel's video list first with the YouTube Channel Scraper, sort it by views, then run this scraper on the videos that matter. Comparing comment-export tools? See the best ExportComments alternatives.
Want the comments in code instead? The InsightSocial API returns a video's comments as JSON with one key.