CommentsToSheets

Guides

How to export TikTok comments to Excel or Google Sheets

TikTok has no export button for comments, and the app shows them a screen at a time. This guide gets a video's comments into a spreadsheet, explains which of the numbers on the video the file can match, and gives the first formulas worth running.

Updated Nov 19, 2026 · 6 min read

Which TikTok links work

Copy the link from the Share menu of the video. Every shape TikTok hands out is accepted:

LinkWhere it comes from
tiktok.com/@name/video/7301234567890123456The address bar on a computer.
vm.tiktok.com/ZMabc123/ or vt.tiktok.com/ZSabc123/Share, Copy link in the app. A short link with no video number in it.
tiktok.com/t/ZTabc123/Share, Copy link in the app in some regions.
tiktok.com/@name/photo/7301234567890123456A photo post (a carousel of images).

A short link is followed once to find the video it points to, so it works the same as the long one. If a short link is refused, open it in a browser, wait for the page to load and copy the long address instead. A link to a profile, a sound or a search page is not a video and cannot be exported.

Export the video

  1. Paste the link on the TikTok to Excel page or the home page and press Export.
  2. Wait for the export page. It shows comments read next to the number TikTok shows on the video.
  3. Pick a format: the Excel workbook with ten sheets, Copy for Sheets for a paste into Google Sheets, a live link for =IMPORTDATA, or a CSV.

Videos with up to 300 comments export free. Above that the page shows a labelled preview, and the options for reading the rest are on the pricing page. Nothing asks for a TikTok login, so the export cannot post, like or follow on anyone's account.

What TikTok hides from every reader

The number under the speech bubble on a video is TikTok's own total. A file of public comments is usually a little shorter, for reasons no tool can change:

  • Filtered comments. Creators can switch on filters for spam and offensive comments, or a list of keywords. Filtered comments wait for the creator's approval and are not public until approved.
  • Comments held for review. With Filter all comments on, nothing is public until the creator approves it.
  • Comments only their author can see. TikTok sometimes leaves a comment visible to the person who wrote it and to nobody else.
  • Deleted comments and removed accounts. The total does not always drop at once.
  • Videos with comments switched off, private accounts and friends-only videos. There is no public list to read.

The total TikTok shows includes replies. Compare it with all rows in the file, not with the top-level comments alone. The guide on why the row count and the displayed count differ covers what size of gap is normal.

How replies arrive

A reply is a row of its own with is_reply set to yes, reply_to_comment_id holding the comment it sits under, and reply_to_username holding who wrote that comment. TikTok keeps reply threads one level deep: an answer to a reply is listed under the same top-level comment and usually starts with an @mention of the person answered.

TikTok serves each reply thread separately, one request per thread. On a free export every top-level comment is read and reply threads are read up to a limit. A paid export reads far more reply threads, within a budget. When replies were left unread, the export page says how many, and the workbook's Read me sheet has a Replies not read line with the same number, so the file never passes for more than it is.

To see how many replies you have: =COUNTIF(Comments!H:H, "yes"). To put threads back in reading order, follow rebuild reply threads in a spreadsheet.

What is in the columns for a TikTok video

  • username is the @handle, lower case, without the @. TikTok also shows a display name on screen; the handle is the part that is unique, so that is what the file holds.
  • user_id is TikTok's own number for the account. It stays the same when someone changes their handle.
  • comment_id and user_id are 19 digits long. The workbook and Copy for Sheets keep them as text. A CSV opened by double-click in Excel rounds them: see why Excel rounds long comment IDs.
  • posted_at_utc is in UTC. Convert it before reading anything into the hours: convert UTC timestamps to your time zone.
  • platform says tiktok on every row, which matters once you stack exports from several networks.
  • A comment that is only a sticker or an image has no text, so its comment cell can be empty.

First formulas for a TikTok export

These work in Excel and Google Sheets with the workbook's sheet names.

QuestionFormula
Top-level comments=COUNTIF(Comments!H:H, "no")
Share of comments that tag a friend=COUNTIFS(Comments!H:H, "no", Comments!K:K, "?*") / COUNTIF(Comments!H:H, "no")
Comments by the creator=COUNTIF(Comments!C:C, "fernhill.market")
Most liked comment=INDEX(Comments!E:E, MATCH(MAX(Comments!G:G), Comments!G:G, 0))
Comments asking a question=COUNTIF(Comments!E:E, "*~?*")

The tilde in the last formula matters: a bare ? is a wildcard for any single character in COUNTIF, and ~? means a real question mark. Replace fernhill.market with the creator's handle.

TikTok comment sections are short and repetitive compared with other networks: many rows are one emoji or one tagged friend. The word and emoji frequency guide is the fastest way to see what the section is about, and the spam guide shows how to set the copy-paste rows aside first.

Mistakes to avoid

  • Treating the file as live. An export is the video as it was read. A video that is still spreading gains comments by the hour; export again when you need the newer ones.
  • Counting mentions as followers. A comment export lists who commented and what they wrote. It cannot tell you who follows the creator, who liked the video or who shared it.
  • Judging reply counts from a free export of a busy video. Check the Read me sheet first. If replies were left unread, the reply numbers are a floor, not a total.
  • Opening the CSV by double-click and then sorting by ID. The rounded IDs no longer match TikTok's. Use the workbook when IDs matter.

FAQ

Does a vm.tiktok.com short link work?

Yes. Short links from the app (vm.tiktok.com, vt.tiktok.com and tiktok.com/t/) are followed to the video they point to and exported like a full link.

Can I export comments from a private TikTok account?

No. Only public videos can be read. There is no login step, so nothing can see what a logged-in follower would see.

Why does the file have fewer rows than TikTok shows?

TikTok counts comments it shows to nobody: filtered, held for review, visible only to their author, or recently deleted. On a free export of a busy video, unread reply threads add to the gap, and the export page says how many.

Are TikTok photo posts supported?

Yes. A photo post link (tiktok.com/@name/photo/…) exports the same way as a video link.

Does the file show the commenter display name?

No. The username column holds the unique @handle. Display names repeat and change, so they are not used to identify a row.