CommentsToSheets

YouTube

=YouTube!A1 · CSV

Export YouTube comments to CSV

Paste the link to a public YouTube video or Short and get every comment and reply as a clean CSV for any spreadsheet or tool. Free up to 5,000 comments, no login to YouTube.

Free per post: YouTube up to 5,000; Instagram up to 1,000; TikTok and Facebook up to 300 comments · replies included · no login

From YouTube to CSV in three steps

  1. On the video or Short, tap Share, then Copy.
  2. Paste the link into CommentsToSheets and press Export.
  3. Download the CSV: UTF-8 with a byte-order mark, one row per comment or reply.

The link looks like youtube.com/watch?v=… or youtube.com/shorts/…. Only public posts can be read.

A CSV that opens cleanly

The CSV is UTF-8 with a byte-order mark, so Excel shows emoji and accents correctly when you double-click it. Comments with commas, quotes or line breaks are quoted properly, so every comment stays in its own row. The same file loads into Google Sheets, Numbers, LibreOffice, a CRM import or a script.

Filtered on the export page (only replies, one row per person, a search), the CSV holds exactly those rows.

YouTube links that work

  • youtube.com/watch?v=…, with or without extra parts such as a time stamp or a playlist.
  • youtu.be/…, the short form from the Share button.
  • youtube.com/shorts/… for a Short.
  • youtube.com/live/… for a live stream's video page.

Channel, playlist and community post links are not videos. Private and members-only videos, videos with comments turned off and videos made for kids have no public comments.

What to know about YouTube

Videos and Shorts with up to 5,000 comments export free, replies included. YouTube's terms allow stored comments for 30 days, so a YouTube export is deleted after 30 days: download the file within that time.

Above the free limit you see the first comments as a labelled preview, and one payment for that YouTube video or Short reads the rest: $4.99 up to 15,000, $9.99 up to 50,000, $14.99 up to 200,000 comments. No subscription needed.

What YouTube hides and how it counts

YouTube's count includes replies. It can also include comments a channel is holding for review and comments from users the channel has hidden, neither of which is public. Live chat is not part of the comments and is not exported. Comments are read newest first, so # 1 is the most recent thread; sort by posted_at_utc to read from the beginning. The file does not say which comments are pinned or have a heart from the creator. To judge a gap, use the five completeness checks.

How YouTube replies arrive

Every reply is read, on free exports too. A reply row has is_reply set to yes and the ID and author of its parent. YouTube IDs are text, not numbers: a reply's ID is its parent's ID, a full stop and its own part, so spreadsheets never round them. The username is the @handle in lower case; a channel without a handle appears by its channel ID, which starts with UC, and user_id is always the channel ID. Threads can be put back in order with four helper columns.

A formula to start with: a link to each commenter's channel

Because user_id (column D) is the channel ID, one formula turns every row into a clickable channel link. In the first free column, N:

=HYPERLINK("https://www.youtube.com/channel/" & D2, C2)

It shows the handle and opens the channel. The same formula works in Excel and Google Sheets. To find the moments of the video people talk about, pull the timestamps out of the comments as shown in how to export YouTube comments to a spreadsheet.

Open the YouTube CSV without changing it

A double-click works for reading: the byte-order mark makes Excel show every alphabet and emoji correctly. Two things a double-click can still change:

  • IDs. YouTube IDs contain letters, so no spreadsheet rounds them. Excel keeps 15 digits of a number, so import with Data, Get Data, From Text/CSV and Do not detect data types when you need IDs exact: why Excel rounds long comment IDs.
  • Columns. In regions where the decimal sign is a comma, a double-click can put the whole row in column A. The same import window fixes it: choose Comma as the delimiter.

If accents ever arrive as é after the file passed through another program, the mark was lost on the way: why emoji and accents break in a CSV. For scripts, read the file as UTF-8 with a real CSV parser, since comments contain commas, quotes and line breaks.

When CSV is the right format

  • Another program will read it. A CRM or help-desk import, a database load, a notebook in Python or R, a BI tool. CSV is the one format they all accept.
  • You want exactly the rows on screen. The CSV follows the filters set on the export page, so "top-level comments containing a word" becomes a file of just those.
  • You want one summary table. Commenters, Mentions, Per day and Hashtags each download as their own CSV.

For reading in a spreadsheet, the CSV is the weakest choice: it cannot say which values are text, so the program opening it guesses. The Excel workbook has the same rows with types fixed, and Copy for Sheets pastes them into Google Sheets without a file. In code, read comment_id, user_id and reply_to_comment_id as strings, and parse posted_at_utc as UTC.

What it cannot do

  • Read private accounts, or comments YouTube hides from everyone (deleted, spam-filtered, restricted).
  • Check who follows, likes or shares: a comment export lists who commented and what they wrote, nothing more.
  • Keep the sheet updated by itself. An export is the post as it was read; export again for newer comments.
  • Post, reply, like or message on YouTube. Nothing asks for a login, so nothing can act on an account.

The columns

#, comment_id, username, user_id, comment, posted_at_utc, likes, is_reply, reply_to_comment_id, reply_to_username, mentions, hashtags, platform. The platform column says youtube on every row, so exports from Instagram, TikTok, YouTube and Facebook can sit in one sheet and still be told apart: compare comments across networks in one sheet. The full walk-through for this network is in how to export YouTube comments to a spreadsheet.

Questions

How many YouTube comments are free?

Up to 5,000 per video or Short, every one of them. The limit is a number of comments, not a time limit.

Do I log in to YouTube?

No. You paste a link to a public post. Nothing asks for a password and nothing is installed.

Are replies included?

Yes, each on its own row with is_reply set to yes and the comment it answers.

Can it check who follows the account?

No. Follows cannot be checked from the comments on YouTube, and this file never claims to. It lists who commented and what they wrote.

Why is a YouTube export deleted sooner?

YouTube's terms allow stored comments for 30 days. Download the workbook or CSV within that time and keep your own copy.

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

Yes. Any public video or Short with comments turned on can be exported. Nothing asks for a Google login.

Are live chat messages included?

No. Live chat is separate from the comments under a video. Comments and their replies are exported.

Why does a username start with UC?

That commenter has no @handle, so the row carries the channel ID, which is unique.

Why are there fewer rows than YouTube shows?

YouTube's count includes comments it hides from everyone, such as spam-filtered or deleted ones. Nobody can read those. The export page shows comments read next to YouTube's number.