Tik GhostTikTok comment exporter
This TikTok comment exporter downloads the public comments on a video as a spreadsheet, with each reply under the comment it answers. Choose CSV or Excel; it's free, and there's no sign-in.
How it works
1. Paste the video link
Put the address of the video you want comments from in the box above; a full link or a vm.tiktok.com share link will do.
2. Check the comments
The video page opens with its comments below, so you can see what the export will contain.
3. Export
Press Export comments, choose CSV or Excel, keep or clear Include replies, then press Start export.
What the file contains
Each comment is one row, with these columns: Comment ID, Reply to comment ID, Username, Nickname, Profile URL, Comment, Likes, Replies, Posted (UTC), Language, Pinned by creator, Liked by creator and Image URLs. When replies are included, each one sits directly under the comment it answers, and its Reply to comment ID holds that comment's ID, so threads stay together when you sort or filter. Image URLs lists any photos attached to a comment. The CSV file is UTF-8 with a byte order mark, so accents and emoji come through in Excel and Google Sheets. The Excel file keeps its header row frozen as you scroll.
How the export works
The export runs in your browser tab. It asks our server for one page of comments at a time, builds the file as it goes and saves it to your device at the end. The file is never stored on our servers. Keep the tab open while it works. Before your first export, a quick automatic check confirms that you are a person, and most people never notice it. For the next 30 minutes, exports in the same tab skip the check. A single export can run for up to 30 minutes; if it stops early, or you press Stop and save, the file keeps everything fetched until then.
Why the file has fewer rows than the video shows
An export usually has fewer rows than the comment count on the video. That number counts replies along with top-level comments, so a file without replies falls short of it. It also counts comments that are filtered or hidden. Creators can filter spam, offensive comments or comments with chosen keywords, and those stay hidden until the creator approves them, so no export can include them. The file holds the comments TikTok shows publicly on the video while the export runs.
Questions
How do I export TikTok comments to Excel?
Open the video here by pasting its link above, then press Export comments, choose Excel and press Start export. You get an .xlsx file with a frozen header row.
Can I export TikTok comments to CSV for Google Sheets?
Yes. Choose CSV, and the file opens in Google Sheets as well as Excel. It is saved as UTF-8 with a byte order mark, so names and comments in any language display correctly.
Is the comment exporter free? Are there limits?
It is free. You can run up to 30 exports a day, and each one can take up to 30 minutes, but there is no fixed cap on the number of comments in a file.
Can I include replies?
Yes, Include replies is on by default. Every reply appears right under the comment it answers, with that comment's ID in the Reply to comment ID column.
What happens if the export stops partway?
You still get a file. Whether you press Stop and save, the 30 minutes run out or TikTok stops answering, everything fetched until then is saved.
Do you keep a copy of my export?
No. The file is built in your browser and saved straight to your device; export files are never stored on our servers.
Can I export followers, videos or reposts too?
Yes. On a profile, the Videos, Reposts, Followers and Following tabs each have an export button with the same CSV and Excel choice.