ShortIntelTikTok comment export guide
How to Export TikTok Comments to XLSX and Review the Data
ShortIntel collects available public comments for one video, records where collection stopped, and creates an XLSX workbook for review. It does not promise every historical comment.
Open TikTok Comment ExporterWhat the Export Contains
- Input
- One public TikTok video link
- Output
- One compressed XLSX workbook
- Worksheets
- Comments, Replies, and Export Info
- Top-level limit
- Up to 2,000 available comments
Export and Check the Workbook
Large public discussions can take longer because comments and available reply pages are requested before the file is built.
01
Paste one public video link
Copy the URL of the individual public TikTok video and paste it into Comment Exporter. Confirm that the returned creator and post are correct.
02
Load the available public comments
Start the export and keep the page open while ShortIntel follows public top-level comment pagination and requests available reply bodies within its safety limits.
03
Review collection status in Export Info
Open the workbook's Export Info sheet to compare source-reported totals, fetched rows, reply counts, page requests, and the reason collection stopped.
04
Review Comments and Replies
Use the Comments and Replies sheets for available IDs, account fields, text, likes, reply counts, and timestamps. Empty cells mean the source did not return that value.
Use Each XLSX Worksheet for a Different Check
Comments contains deduplicated top-level rows. Replies contains available reply bodies. Export Info documents the video source, collection totals, pages fetched, limits, and completion status.
Keeping status data separate from comment rows makes the workbook easier to audit and prevents a partial collection from looking complete by accident.
Understand Source Counts and Collection Limits
Each export is capped at 2,000 top-level comments, 2,000 reply bodies, 120 source page requests, or 45 seconds of collection. The first reached boundary is recorded in Export Info.
TikTok's displayed comment total can include replies, removed content, filtered content, or items the connected public source cannot return. A difference between the displayed total and workbook rows is therefore documented rather than hidden.
Know What Is and Is Not Stored
The XLSX file is generated in server memory and returned with no-store response headers. ShortIntel does not save the generated workbook to a database, object storage, or project history.
To reduce repeated paid source requests, recently fetched public comment results for the same video can be cached for about one hour. This source cache is separate from the downloaded XLSX file on your device.
Comment export FAQ
Questions About TikTok Comment Exports
Does the XLSX contain every TikTok comment?
No. It contains the available public rows returned before the source ends or a recorded collection safety limit is reached.
Are replies included?
Available reply bodies are written to the Replies sheet. Export Info compares reported reply counts with the reply rows retrieved.
Why are some spreadsheet cells empty?
ShortIntel does not infer missing IDs, names, counts, or timestamps. An empty cell means the source did not return that field.
Does ShortIntel keep the downloaded XLSX?
No. The workbook is generated in server memory as a no-store response and is not saved to a database, object storage, or project history.