Skip to navigation

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.

The sample worksheet row below illustrates a reusable column convention that separates raw response fields from provenance and manual analysis columns:

video_id,comment_id,parent_comment_id,comment_text,published_at,source_file,request_id,topic,next_step
7610000000000000001,7610000000000000100,,It wobbles on thick carpet,,page-1.json,example-request-id,Placement,Check supported floor types
  • Raw comment fields: Populate video_id, comment_id, parent_comment_id, comment_text, and published_at from the saved JSON, leaving missing text or parent IDs blank.
  • Provenance and analysis fields: Keep source_file and request_id on every row, and place manual categorization (topic, next_step) in separate columns so source quotes remain untouched.

Step-by-step export and verification checks

  1. 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.
  2. Deduplicate rows: Deduplicate by the combination of video_id and comment_id while preserving each row’s source_file.
  3. 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.
  4. Spot-check provenance: Before sharing the CSV, trace at least one row back to the exact quote in that row’s source_file response.

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.