CommentsToSheets

TikTok

=TikTok!A1 · CSV

Export TikTok comments to CSV

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

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

From TikTok to CSV in three steps

  1. On the video, tap Share, then Copy link.
  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 tiktok.com/@name/video/… (a vm.tiktok.com short link works too). 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.

What to know about TikTok

Videos with up to 300 comments export free. On a free export every top-level comment is read and reply threads are read up to a limit; the export page says how many replies were left unread. A one-time pass reads every reply.

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 tiktok on every row, so exports from Instagram, TikTok, YouTube and Facebook can sit in one sheet and still be told apart.

Questions

How many TikTok comments are free?

Up to 300 per video, every one of them. The limit is a number of comments, not a time limit.

Do I log in to TikTok?

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 the comment it answers. On a free export reply threads are read up to a limit and the page says how many replies were not read; a pass reads them all.

Can it check who follows the account?

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

Why are there fewer rows than TikTok shows?

TikTok'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 TikTok's number.