CommentsToSheets

YouTube

=YouTube!A1 · Google Sheets

Export YouTube comments to Google Sheets

Paste the link to a public YouTube video or Short and get every comment and reply as rows in Google Sheets, by paste or by a live =IMPORTDATA link. 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

Copy for Sheets

Copy, paste, done

One button puts the rows you are looking at on the clipboard as tab-separated text with headers. Paste into Google Sheets or Excel and it lands one value per cell, up to 20,000 rows at a time.

  • Respects your filters: only replies, one row per person, a search
  • Multi-line comments stay in one cell
  • Comments that start with = + - or @ stay text, never formulas
  • Long ids stay exact instead of being rounded
How Copy for Sheets works

From YouTube to Google Sheets in three steps

  1. On the video or Short, tap Share, then Copy.
  2. Paste the link into CommentsToSheets and press Export.
  3. Press Copy for Sheets and paste into cell A1, or make a live link and paste the =IMPORTDATA formula it gives you.

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

Two ways into Google Sheets

Copy for Sheets. On the export page, press Copy for Sheets, click cell A1 in your sheet and paste. The rows land one value per cell with headers, multi-line comments stay in one cell, and a comment that starts with = or @ stays text instead of turning into a formula.

Live link. Press Make a live link and copy the formula it shows:

=IMPORTDATA("https://commentstosheets.com/s/…csv")

Paste it into A1 and Google Sheets fetches the comments itself. The link serves exactly what the export holds, needs no login in the sheet, and stops working when you make a new one or when the export is deleted.

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.