By tokviewer.app editorial team
The best TikTok comment export format depends on the question you want to answer. A flat CSV is easy to filter, while JSON preserves nested replies and source metadata. For most review work, keep a stable comment ID, video ID, author handle, text, timestamp, parent ID, and moderation status in every row.
Key Takeaways
- Use CSV for spreadsheets and JSON when reply structure matters.
- Keep IDs and timestamps unchanged so exports can be compared later.
- Remove unnecessary personal data before sharing a file.
Choose CSV for everyday analysis
CSV works well when a team needs to sort comments, filter keywords, or count recurring questions. Use one row per comment and reserve columns for comment_id, video_id, created_at, author_handle, text, parent_id, and status. Keep the original text in one field; do not split a sentence into columns merely because it contains punctuation.
If a value contains a comma, quote it according to the CSV standard. Save the encoding as UTF-8 so emoji and non-English comments remain readable. A spreadsheet is a viewing layer, not the source of truth: keep an untouched copy beside any cleaned version.
Use JSON when replies and metadata matter
JSON is better for nested conversations. A parent comment can contain a replies array, reaction counts, language labels, or the exact source response. This structure helps when you want to understand whether a creator answered a question or whether a complaint received follow-up.
Before importing JSON into a spreadsheet, decide how to flatten it. Keep parent_id in the flattened rows so a reply can be connected back to its parent. Never infer conversation order from row order alone; use timestamps and IDs.
Preserve IDs across exports
IDs are the bridge between exports. If you normalize usernames or translate text, retain the original ID in a separate immutable column. The TikTok comment ID guide explains why replacing IDs makes later reconciliation difficult.
Add an export timestamp and the source video URL to the file metadata. If a later export contains fewer rows, you can distinguish a deleted comment from a failed request or a changed filter.
Illustrated worksheet
This diagram summarizes the example in this article.
Build a review-ready schema
A useful working table includes the original text, a human review label, and a short reason for that label. Keep moderation notes separate from the author's words. For example, review_label=question and review_note=asks about setup are safer than rewriting the comment itself.
If you calculate engagement or response rates, record the denominator and time window. The TikTok engagement-rate guide shows why a percentage without its formula is hard to compare.
Protect people in exported files
Comments may contain names, locations, or sensitive stories. Export only what the analysis needs, restrict access, and remove private fields before sending a CSV to a wider team. Do not publish a comment merely because it is visible on a public video.
A careful format preserves context without making the file harder to use. Start with CSV for a focused question, retain JSON when thread structure matters, and keep the original IDs in both.
Top comments (0)