Why Your TikTok Comment Export Has Fewer Comments Than TikTok Shows
· 3 min read
A TikTok video may show a higher comment count than the number of rows in a CSV or Excel export. The two figures describe different things: one is the count displayed by TikTok when you looked; the other is the set of comments delivered by an export at a particular time. A gap is worth investigating, but it does not by itself prove that the export failed or identify why a specific comment is missing.
Check the comparison before drawing conclusions
- Record the source. Save the public video URL, the displayed comment count, and the date and time you saw it. Counts can change, so a number copied yesterday is not a reliable baseline for an export today.
- Check the export settings. Paste the public link into the TikTok Comment Exporter. Note whether you included replies, when the export ran, and whether it completed. If you need the full available result, check whether your free allowance or account credits affect how much you can download; the pricing explanation describes the current limits.
- Count the delivered records, not spreadsheet lines. In CSV, exclude the header row. In Excel, check for active filters or hidden rows. Use the comment_id field to spot duplicate records, and parent_id to distinguish replies from top-level comments. Keep the original file unchanged while you investigate.
- Compare like with like. A top-level-only export should not be compared with a number that may include replies. If the video or its comment visibility changed between checks, record that timing rather than treating the two counts as a simultaneous measurement.
- Inspect a small sample. If a particular public comment matters, check whether you can still see it on TikTok and whether its ID or text appears in the file. The comment viewer can help review available comments, but a spot check cannot establish the cause of every missing row.
Possible reasons for a gap
Comments can become unavailable, be removed or moderated, or change visibility. Replies may be excluded by your chosen settings. A large export may also be incomplete if it stopped before finishing. These are possibilities to investigate, not a diagnosis of any individual video. TikTok's displayed number and the set retrievable at export time need not be identical.
If the difference is material, rerun the export once with the same settings and document both attempts. Do not promise a perfect match: a later run may retrieve a different set as the public thread changes. If you need to report a limitation to a client or team, state it plainly rather than silently treating the displayed count as the size of your dataset.
Report the dataset you actually analyzed
A useful note is: “On [date and time], TikTok displayed [X] comments for [video URL]. Our completed export delivered [Y] comment records with replies [included/excluded]. The analysis below uses those [Y] records.” Add the export file and your counting method so someone else can check the result.
For competitor or audience research, compare videos using the same settings and record each video's coverage separately. The competitor research workflow shows how to review themes without ranking videos solely by exported row count.
If you run AI comment analysis, keep its scope separate from the CSV or Excel count: TokSift currently samples up to 500 comments per video for AI analysis, according to its pricing page. A theme or sentiment finding from that sample should not be described as a measurement of every comment on the video.
FAQ
Does a lower export count mean TokSift lost comments?
Not necessarily. First confirm the run completed, check replies and limits, and compare the file with the count recorded at the same time. The gap alone does not reveal its cause.
Can I recover every comment behind TikTok's displayed number?
Do not assume so. A displayed count is not a guarantee that every historical comment remains publicly retrievable. Work from the records actually delivered and document any coverage gap.
Should I use the displayed count or the CSV row count in a report?
Use the delivered comment-record count to describe your analyzed dataset. You can also report TikTok's displayed count, with its observation time, as context. Keep the two labels distinct.
Does AI analysis cover my entire export?
Not necessarily. The current AI analysis limit is up to 500 sampled comments per video. State that sample size separately from the number of rows exported.
Try it on your own video
Paste a TikTok link and get the comments as CSV or Excel. No TikTok login, and the first batch on every video is free.
Export comments