How do I export comments to CSV?
Export TikTok comments by building a UTF-8 CSV manually from your saved JSON responses, with one row per comment. Extract the comment ID, exact comment text, timestamp, and parent comment ID (for replies) directly from each saved JSON response.
Recommended UTF-8 CSV columns and sample row
The sample worksheet row below illustrates a reusable column convention that separates raw response fields from provenance and manual analysis columns:
- Raw comment fields: Populate
video_id,comment_id,parent_comment_id,comment_text, andpublished_atfrom the saved JSON, leaving missing text or parent IDs blank. - Provenance and analysis fields: Keep
source_fileandrequest_idon every row, and place manual categorization (topic,next_step) in separate columns so source quotes remain untouched.
Step-by-step export and verification checks
- Collect and save raw pages: Follow the video comment guide, save every response alongside its request ID, and reuse already-saved pages instead of refetching.
- Deduplicate rows: Deduplicate by the combination of
video_idandcomment_idwhile preserving each row’ssource_file. - Protect spreadsheet formatting: Import long numeric IDs as plain text so spreadsheets do not round them, and import comment strings that could be parsed as formulas as text as well.
- Spot-check provenance: Before sharing the CSV, trace at least one row back to the exact quote in that row’s
source_fileresponse.
Why export is manual and how pages are billed
Build the CSV manually from saved responses because automated conversion requires a verified fixed output structure, which the TikTok comment action does not define yet. Each additional comment page fetched is a separate billed request—see BeatAPI pricing.

