TikTok comment exporter
Export TikTok comments to CSV in one paste.
Paste a video link and pull up to 10,000 top-level comments with author handles, like counts, and reply counts — plus the reply threads underneath them. Sortable, deduplicated, and ready for a spreadsheet or your own analysis.
Every field that matters
Comment text, @author, likes, reply count, post date, and the parent comment id on every row.
CSV, Excel, or JSON
Open it in Sheets, download a formatted .xlsx workbook, or pipe the JSON straight into your own pipeline.
Sorted for research
Rank by likes or replies to surface the loudest voices in a thread first.
Built for volume
Up to 10,000 comments per export. No scrolling, no copy-paste.
What you actually get
Every row is one comment — top-level, or a reply when reply threads are included. These are the exact column headers, in the exact order they appear in the file — no hidden fields, no “upgrade to see the data” columns left blank.
| Column | Type | What it holds | Example |
|---|---|---|---|
| comment_id | string | TikTok's comment id. Use it to deduplicate across runs. | 7300000000000000001 |
| parent_comment_id | string | Empty for a top-level comment; the parent's comment_id when the row is a reply. Sort by this to rebuild threads. | 7300000000000000000 |
| text | string | Comment body, verbatim, emoji included. | the second tip actually works |
| author_unique_id | string | Commenter's handle, without the @. | examplereader |
| author_nickname | string | Commenter's display name. | Example Reader |
| reply_to | string | Handle this reply addresses. TikTok only supplies it when a reply answers another reply, so it is empty on a direct reply to the parent. | examplereader |
| likes | number | Likes on the comment. Sort by this to find the loudest voices. | 241 |
| reply_count | number | Number of replies underneath it. | 12 |
| created_at | datetime | ISO 8601 UTC timestamp, empty when TikTok doesn't supply one. | 2026-05-14T09:22:11.000Z |
And it opens properly
Most exporters get at least one of these wrong. These are properties of the file we write, not promises.
- Opens clean in Excel
- UTF-8 with a byte-order mark, so emoji and non-Latin handles survive a double-click on Windows instead of turning into mojibake.
- RFC 4180 quoting
- Commas, quotes and newlines inside a caption or comment are escaped properly, so a multi-line comment never splits into two rows.
- Formula-injection safe
- A comment starting with =, +, - or @ is prefixed with an apostrophe so Excel and Sheets treat it as text instead of executing it (CWE-1236).
- CRLF line endings
- The line terminator the CSV spec actually calls for, which is what keeps older Excel builds from collapsing rows.
How it works
- 01
Paste the video link
Any standard TikTok video URL, including vm. and vt. short links.
- 02
Pick your depth
Choose how many comments to pull, up to 10,000, and whether to expand reply threads.
- 03
Export
Download CSV, Excel, or JSON, or save the thread to a collection.
Questions
- Can I export TikTok comments for free?
- No — comment export starts on Pro, which includes 30 comment exports a month, each pulling up to 10,000 top-level comments. The free tier covers watermark-free downloads, not comment exports. Signing up takes no card, so you can see the dashboard before you decide.
- What format are the comments in?
- CSV, an .xlsx workbook with a frozen header row, or JSON for developers. Both include the comment text, @handle, like count, reply count, post date, and the parent comment id that links a reply to its thread.
- How many comments can I pull from one video?
- Up to 10,000 top-level comments per export, plus the replies underneath up to 200 of them when you tick "Include reply threads".
- Is exporting TikTok comments allowed?
- Use it for public content you have the rights to analyze. tikklip stores metadata and links, never the videos themselves. See our Terms for details.
- Do you capture replies?
- Yes. Tick "Include reply threads" and the export expands the most-replied comments and returns their replies as their own rows, linked to the parent by the parent_comment_id column. Up to 200 threads per export.
Get the whole toolkit
Downloads, profile scraping, search and comment exports, and saved collections, in one place. Start free, no card required.
Guides
How to research TikTok comments for a campaign
Pull a video's comments, sort by what matters, and turn the language your audience already uses into campaign angles.
How to see who commented on a TikTok
Where the app shows commenters, and how to turn a video's comment section into a list of handles you can sort.
How to pick a TikTok giveaway winner fairly
Export the entries, apply your rules, remove duplicates, then draw a winner in a way your audience can verify.
How to export TikTok comments to Excel
From a video link to a clean Excel workbook, with the filters and pivots that make a comment section readable.
TikTok comment sentiment analysis, done properly
Export, hand-code a sample, scale it with a model, then check the model against your sample before you report a number.
More tools
Profile scraper
Up to ~2,000 public videos from a handle, exported to CSV with views, likes, and captions.
Search & hashtag export
Any keyword or hashtag, turned into a sortable spreadsheet of videos and stats.
Video downloader
Any link, turned into a watermark-free MP4, an HD copy, and an MP3. Free, no app.