A TikTok video peaked three weeks ago. The view counter has slowed. The comment section, somehow, is still adding 200 comments a day — because the meme moved into the replies and took on a life of its own. That's a TikTok-specific problem: the comments often outlive the video and carry more cultural payload than the clip itself. The only way to read that conversation at scale is to pull it out and put it in a spreadsheet. This guide walks you through using ExportComments' TikTok Comments exporter to do exactly that, in Excel, CSV, or JSON.

Why export TikTok comments

TikTok's comment culture is closer to a forum than to a feed. Comments are where "POV" gets written, where main-character syndrome plays out in real time, where creators bait engagement with deliberately wrong information (the rage-bait mechanic), and where memes propagate long after the source video has cooled. Once you've exported the comments to a spreadsheet you can do things the TikTok app actively hides:

  • Harvest comments from a viral trend across dozens of videos to map how the joke or the meme actually evolved — the comment section is often where the real cultural payload lives.
  • Audit your creator's response cadence — which comments did they reply to, how fast, and which top comments did they leave on the table.
  • Extract organic UGC brand mentions — pull every @your_brand from every video in a hashtag and you have a clean source-of-truth list of who's talking about you, with sentiment.
  • Run hashtag-context analysis — pull a hashtag's top videos, export the comments, and read what the audience actually associates with the tag versus what the creators wanted them to.
  • Spot rage-bait patterns — comments piling on a deliberate factual error are a textbook engagement-bait fingerprint and worth flagging when sourcing testimonials.
  • Compare comment cadence between a creator's hits and misses to find the topics that actually open the conversation.

How to export TikTok comments — step by step

Step 1: Grab the video URL

Open the TikTok video and copy its URL from the browser bar. Standard tiktok.com/@username/video/ URLs and short vm.tiktok.com links both work. The video has to be public — private accounts and friends-only videos aren't reachable.

Step 2: Paste the URL into the exporter

Head to the TikTok Comments exporter and paste the URL. For several videos at once — a hashtag rollup, a creator's last ten posts, a competitor scan — switch to bulk mode and paste one URL per line. Bulk runs return one file per URL bundled together in a single ZIP at the end of the job, so each video stays cleanly separated.

Step 3: Pick a format

Choose Excel (.xlsx), CSV, or JSON. Excel is right for pivoting and charting immediately. JSON is right if you're piping the data into a notebook, a sentiment model, or your own dashboard.

Step 4: Start the export

Click Export. The job runs server-side and paginates through every comment plus its replies. Heavy threads on viral videos can take a few minutes; you can close the tab and the file lands in your dashboard plus your inbox when it's ready.

Step 5: Open the file

Open the .xlsx in Excel, Numbers, or Google Sheets. One row per comment, with the columns described below.

Inside the export — what fields you get

Each row is a single comment or reply. You'll find columns for:

  • commenter_handle — the public @username on the comment.
  • display_name — the display name shown next to the handle.
  • comment_text — the full body of the comment.
  • like_count_per_comment — how many likes the comment itself collected.
  • parent_id — empty for top-level comments; populated with the parent comment's ID for replies. TikTok uses a two-level reply tree (comment → reply), so all replies link to a top-level parent.
  • is_creator_comment — Y/N flag identifying whether the comment is from the video owner. Useful for filtering host responses out of the conversation.
  • mentioned_handles — every @mention parsed out of the comment text, ready for tag-network analysis.
  • created_at — original timestamp in UTC.

Common workflows

  • Viral-trend comment harvesting — bulk-export the top 30 videos in a trending hashtag, then concatenate the comment columns and word-cloud the result. The comments often reveal what the trend actually means to the audience, which is rarely what the videos are trying to say.
  • Creator-response audit — filter to is_creator_comment = Y to get every creator reply in one view. Compare reply timestamps to parent comment timestamps to measure response cadence and surface the comments the creator engaged with versus the ones they ignored.
  • Brand-mention extraction from organic UGC — explode the mentioned_handles column, filter to your handle, and you have a clean list of every comment that mentioned your brand across the dataset. Pair with comment_text to score sentiment per mention.
  • Hashtag-context analysis — bulk-export videos under a hashtag, then count the most-frequent words and emojis in comment_text. The vocabulary the audience uses in the comments tells you what the hashtag really means in 2026, not what it meant when it launched.
  • Rage-bait pattern detection — sort by reply count or by like_count_per_comment on a creator's catalog. Videos where one or two comments collect outsized replies ("actually that's wrong because…") are the classic engagement-bait fingerprint.
  • POV / main-character reply patterns — full-text search the comment_text column for "POV" and "main character" to surface the meme-format replies that often outlive the original video by weeks.

Plan limits and API access

The Free tier returns up to 100 comments per export, which is enough to evaluate the format. Personal scales to 5,000 results per export, Premium to 50,000, and Business to 250,000 — enough to capture viral TikTok threads in full. If you'd rather pull comments on a schedule or trigger an export from your own pipeline, the same job is available through the REST API and via webhooks. See pricing for the full breakdown.

FAQ

  • Does this work on private TikTok videos?
    No. The exporter only works on publicly visible videos. Private accounts and friends-only posts return nothing.
  • How deep does the reply tree go?
    TikTok uses a two-level reply tree — top-level comments and replies to those comments. The parent_id column links replies to their parent so you can rebuild the full thread.
  • Are @mentions parsed for me?
    Yes. The mentioned_handles column extracts every @mention from the comment text into its own column, ready to filter or join.
  • Can I export comments from a hashtag instead of a single video?
    Use bulk mode: pull the top videos under the hashtag, paste their URLs one per line, and the run returns one file per video in a single ZIP. Combine the files in Excel for a hashtag-level view.
  • Can I schedule a weekly export?
    Yes. Scheduled exports are available on Premium and Business — useful for tracking comment growth on a video that's still picking up after the initial publication window.
  • Does the Telegram bot trigger exports?
    No. The Telegram bot is notifications only — it pings you when an export finishes, but exports themselves are started from the dashboard or via the REST API.