> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.beatapi.io/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.beatapi.io/_mcp/server.

# How do I export comments to CSV?

> Build TikTok comment CSVs manually from saved JSON responses using one UTF-8 row per comment, deduplicated by video_id and comment_id.

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:

```csv
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](/guides/tiktok-video-comments), 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](https://beatapi.io/pricing).