Export TikTok Comments to Excel or CSV (Feature check)
Use TT Picker’s TikTok Comment Picker to run a fair giveaway draw. Free to try – 3 free picks, Pro for unlimited.
If you want every comment from a TikTok video sitting in rows and columns, TikTok itself will not help you. There is no download link, no "export" button, nothing in the app's own menus. To get there, you need a tool built for the job, and it's worth knowing upfront which tool does which part, because the two obvious candidates — a general comment exporter and a giveaway picker like TT Picker — are not the same thing.
This guide gives you the short answer, a clean step-by-step for the method that works, exactly which columns you end up with, what TT Picker's own export is actually built for, and what to do with the data afterward.
Can you export TikTok comments?
Yes, but not from TikTok directly. A third-party comment export tool reads the public comments on a video — the same ones any viewer could see — and writes them into a CSV or Excel file, one row per comment. That's the whole mechanism: there's no special access, no hidden data, just the public comment section turned into a spreadsheet instead of a scrolling feed.
Two things limit this. The video and its comments have to be public, since export tools see what a logged-out viewer sees. And deleted or hidden comments won't appear, because once a comment is gone from the live page, there's nothing left to read.
Export comments with a comment export tool, step by step
For a full, structured export, a dedicated export tool is the practical route. The flow is the same across most of them.
- Copy the video link. On mobile, open the video, tap Share, then Copy Link. On desktop, copy the URL straight from the address bar.
- Paste the link into the export tool. Most work from a public URL with no TikTok login required.
- Choose your fields. Username, comment text, date posted, and like count are the standard set. Some tools also offer reply count and the commenter's profile link.
- Pick a file format. CSV works everywhere; XLSX opens cleanly in Excel without the encoding issue described below.
- Run the export and download the file.
A few practical notes before you rely on this for a big video. Free tiers almost always cap how many comments you can pull per video or per month, so a viral post with tens of thousands of comments may only partially export on a free plan. Photo posts (carousels) have comment sections too, and most export tools handle them the same way they handle videos.
What about TT Picker's export?
This is worth being precise about, because it's easy to assume any tool with "export" in its pricing list does the same job. TT Picker is a giveaway picker first — you load a video's comments to run a random draw, not to pull every comment for its own sake. Its advertised export, listed under the $5/month Pro plan, is a "PDF, Excel & CSV Winner Certificate" export, tied to a completed draw rather than a stand-alone comment dump. The site states entry counts are shown before the draw for easy verification, but it does not publicly document, on its pricing or tool pages, whether the certificate itself contains the full per-comment entry list or a summary of the draw and winner.
So if your goal is a complete spreadsheet of every comment on a video for analysis, don't start with a giveaway picker — start with a dedicated comment export tool, as above. If your goal is running a fair giveaway and keeping a record of the draw, TT Picker's own flow (and its guide to picking a winner from TikTok comments online) is the more direct path, and it already handles the part a raw export doesn't: removing duplicate entries so each commenter counts once.
What columns you actually get
Here's what a real export gives you, broken out by which tool you used.
From a comment export tool, expect one row per comment with:
- Username of the commenter
- Comment text, exactly as posted
- Date posted (and often the time)
- Like count on that comment
- Reply count, in tools that track it
- Profile link, in some tools
That's a genuinely useful dataset. It's sortable, filterable, and good for anything from sentiment review to counting unique commenters.
From TT Picker's Winner Certificate export, what's confirmed on the site is narrower: the number of entries the draw used, and the winner selected. The site's own language says "detailed reporting shows exactly how winners were selected," which points toward the certificate documenting the draw process, but TT Picker does not spell out on its public pages whether that reporting includes a row for every individual entry. If a full entry list with eligibility flags matters to you — for example, for a client audit — ask the tool directly or test it on a trial draw before you rely on it for that purpose, rather than assuming it from the plan description.
What to do with the export
Once comments are in a spreadsheet, a few jobs come up constantly.
Giveaway audit. If you ran a draw and need to show a client or a regulator that the pool was complete and the pick was fair, a full export taken before you clean anything is the backbone of that proof. The guide to proving a draw was fair covers what fields matter and the order you should capture them in — export first, then filter, so the exclusions stay visible rather than disappearing from the record.
Sentiment and feedback review. With comments in rows, you can sort by like count to surface what resonated most, filter by keyword to isolate reactions to a specific product or feature, or paste a column into an AI assistant and ask for a quick positive/negative/neutral breakdown.
Content ideas from FAQs. Scanning a sorted, de-duplicated comment list is a fast way to spot the questions people keep asking, which often make better content prompts than guessing from scratch.
Client reporting. If this export feeds into a recurring report, pair it with the numbers that actually matter to a client rather than just the raw comment count. The guide to giveaway metrics for client reports breaks down which figures (like eligible entries versus raw entries) tell the real story.
Saving comments before they're deleted
One more reason to export sooner rather than later: TikTok comments can disappear without warning. The creator can delete any comment on their own video, commenters can delete their own, and TikTok's automated filters can remove comments silently with no notice to either side. None of this is reversible from TikTok's side — there's no recently-deleted folder and no restore option.
If a comment section matters to you, whether it's a giveaway entry pool, feedback you want to keep, or a thread you might need later, the only reliable move is exporting or saving it before anything happens to it. The guide to saving TikTok comments before they're deleted covers the methods that actually hold up, including what to do if a comment is already gone.
Frequently Asked Questions
Yes. Most comment export tools offer a free tier that covers CSV or XLSX exports, usually capped by comment count per video or per month.
Not as a stand-alone feature. TT Picker's export is a Winner Certificate tied to a completed draw, available on its $5/month Pro plan. It isn't advertised as a general-purpose "export every comment" tool, so for a full comment dump, use a dedicated export tool instead.
That's a character-encoding mismatch, not lost data. In Excel, use Data → From Text/CSV and set the file origin to Unicode UTF-8 (65001), or export directly to XLSX to avoid the issue entirely.
Yes. Photo posts have comment sections too, and most export tools read them the same way they read video comments.
No. If picking a winner is the goal, a comment picker reads the comments, removes duplicates, and draws directly — faster than exporting a spreadsheet and selecting a row by hand.