Export YouTube Comments to CSV

Paste a video link, narrow the comments down to what you need, and download them as a spreadsheet for Excel or Google Sheets.

Free export, no account and no email required.

CSV export

Download YouTube comments as a spreadsheet

Open Export, choose CSV, and the file is in your downloads. No signup, no email form, no waiting for a link.

  • Opens in Excel, Google Sheets and Numbers - no conversion step
  • Emoji, accents and non-Latin scripts arrive intact
  • Free for the first 250 rows, as often as you like

Filters carry over

Export what you searched for, not everything

Search for a keyword or pick one author first. The file holds the view you are looking at, in the order you see it.

  • Keyword search, author filter and sort order all apply to the file
  • The 40 comments that mention your product, instead of all 40,000

What is in the file

One row per comment, twelve columns

Plain text, UTF-8, with a header row. The same twelve fields in CSV and in JSON.

commentId
YouTube’s id for the comment.
parentId
Empty: the file holds top-level comments.
author
The commenter’s display name.
authorChannelUrl
Link to the commenter’s channel.
text
The comment, as plain text.
likeCount
Likes on the comment.
replyCount
Replies underneath it.
publishedAt
When it was posted (ISO 8601, UTC).
updatedAt
When it was last edited.
hasQuestion
True when it contains a question mark.
hasTimestamp
True when it points at a moment, like 3:42.
wordCount
Words in the comment.

Full exports Supporters

Every comment, with no row cap

Supporters export every comment of any video in one file. A big one is prepared in the background, so you can keep browsing while it is written.

  • CSV or JSON
  • Date-range and comment-length filters on the export
  • A large file waits on the Exports page for 24 hours

Part of every supporter plan, from $5/month. What supporters get

Frequently asked questions

How do I export YouTube comments to Excel?

Paste the video URL into Hadzy, wait for the comments to load, then open the Export menu and pick CSV. The file downloads to your computer as hadzy-comments-VIDEOID.csv and opens directly in Excel, Google Sheets, or Numbers. It is written as UTF-8 with a byte-order mark, so accented characters and emoji survive the trip into Excel instead of turning into mojibake.

Can I export comments from a video I do not own?

Yes. Any public video with comments enabled can be exported, whether or not it is your channel - Shorts and livestream replays included. Nothing is exported for private videos, or for videos with comments turned off, because that data is not public.

What columns are in the exported CSV?

commentId, parentId, author, authorChannelUrl, text, likeCount, replyCount, publishedAt, updatedAt, hasQuestion, hasTimestamp and wordCount. There is one row per comment, and the comment text is stripped of YouTube’s HTML markup. Replies are not in the file; replyCount says how many each comment has.

Is there a free YouTube comment export tool?

This one. Hadzy exports without an account, an email address, or a trial: paste a URL, click Export, get a CSV. The free export covers the first 250 rows of whatever you have filtered to. Core Supporters ($5/month on Patreon) export every comment of any video with no row cap, and can also export JSON - a large file is prepared in the background and downloads when it is ready. The free cap exists to keep bulk scrapers from turning a free tool into their data pipeline; it is what keeps the search itself free and ad-free for everyone else.

Can I export the comments as JSON instead?

JSON export is a Core Supporter feature. It returns the same fields as the CSV as an array of objects, which is easier to feed into a script, a notebook, or another tool without parsing a spreadsheet first.

Does the export respect my search and filters?

Yes - that is the point of exporting from the view rather than the video. Your keyword search, author filter, and sort order are applied to the file, so the rows come out in the order you see them on screen. Filtering the export by date range, or to comments of at least a given length, is a supporter feature.

More from Hadzy

Export a video’s comments

Paste the video link in the box above, then open Export once the comments are in.