CommentsToSheets

YouTube

=YouTube!A1 · Excel

Export YouTube comments to Excel

Paste the link to a public YouTube video or Short and get every comment and reply as an Excel workbook with the commenters, mentions and days already counted. Free up to 1,000 comments, no login to YouTube.

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

Excel workbook

A workbook, not a list

The Excel download opens with six sheets already laid out, so the questions people ask about a post are answered before you write a formula.

  • Comments: every comment and reply, with real date cells
  • Commenters: one row per person with comments, replies, likes received, first and last time
  • Mentions: who was tagged, how often and by how many people
  • Per day and Hashtags, plus a Read me sheet with the counts and what every column means
  • Header rows frozen and filterable, columns sized to fit
What is in the workbook

From YouTube to Excel 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 Excel workbook: Comments, Commenters, Mentions, Per day, Hashtags and a Read me sheet.

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

What the workbook holds

The Excel download is a workbook, not a single list:

  • Comments: every comment and reply, posted_at_utc as a real date, ids kept as text.
  • Commenters: one row per person with comments, replies, likes received, first and last comment time.
  • Mentions: every tagged account, how many comments tag it and how many different people did.
  • Per day and Hashtags, ready for a chart.
  • Read me: the post link, the network, when it was read, comments read next to the count YouTube shows, and what every column means.

Header rows are frozen and filterable, so sorting by likes or filtering to replies is one click.

What to know about YouTube

Videos and Shorts with up to 1,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 post reads the rest: $4.99 up to 15,000, $9.99 up to 50,000, $14.99 up to 200,000 comments. The same passes apply on every network; there is no subscription.

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.

Questions

How many YouTube comments are free?

Up to 1,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.

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.