Trendilens
Sign inSign up

Export TikTok comments to Excel or CSV

Excel and CSV are how most teams filter “price”, “shipping” and unanswered questions after a post takes off. TikTok has no spreadsheet button — here is a reliable path via collection + JSON.

What “Excel export” means here

You need rows: comment text, author, likes, timestamps and a parent id so replies stay tied to their thread. Screenshots and the in-app pane do not give you that.

Trendilens collects the public thread first. The same cabinet token returns JSON you can open in Excel, Google Sheets or Power Query — that is the practical “download to Excel” flow.

Step-by-step: link → list → spreadsheet

Work in this order so you do not spend balance on the wrong video.

  1. Copy the post link in TikTok (Share → Copy link). Short vt.tiktok.com links work.
  2. Paste it on the Trendilens home page and confirm the free metadata card — author, stats, description, sound.
  3. Run the full collection. Top-level comments arrive with replies; author’s replies are marked. You pay for comments actually collected.
  4. Save the breakdown to the library if you will return later or turn on refresh while the post is still live.
  5. Pull JSON with the cabinet token (see /api-docs). In Excel: Data → Get Data → From JSON / From File, or paste into Sheets and split columns. Save as .xlsx or .csv.

Suggested columns

Keep the table flat enough for filters, but preserve thread context.

  • comment_id and parent_id (empty for top-level) — rebuilds the tree
  • text, username, like count, create time
  • is_author_reply — skip threads already answered
  • post_url / post_id — join several exports in one workbook

CSV vs XLSX

CSV is universal for CRM imports and scripts. XLSX is better when non-technical teammates need filters, freeze panes and shared OneDrive/Sheets workflows.

Both start from the same JSON. Transform once, then Save As the format your pipeline expects.

Limits and honest constraints

Only public posts. Private accounts, deleted videos and audience-restricted clips cannot be collected — and we do not try to bypass that.

A sensible per-post cap stops endless jobs. Billing is still per comment actually returned. Metadata stays free before you collect.

  • No official TikTok .xlsx button — third-party collection is the workaround for public posts
  • Replies matter: export them or you will miss “DM me” answers under the first line
  • Very large posts may hit the cap — re-check library / refresh rather than assuming infinite scroll

After the sheet is ready

Filter for commercial phrases, hand the file to support, or load JSON straight into a CRM without Excel in the middle. For product context see the export use-case; for parsing options see the parser guide.

Frequently asked questions

Is there a one-click Download XLSX in Trendilens?

The reliable path is collect → JSON via the cabinet token → open in Excel or Sheets. That avoids brittle one-off file formats and matches how most CRMs ingest data.

Can I export TikTok comments to CSV the same way?

Yes. Open the JSON in a spreadsheet tool and save as CSV, or transform with Power Query / a small script.

Are replies included in the Excel rows?

Yes if you map each comment and reply to a row and keep parent_id. Collection already returns threaded replies.

Do I need Python for Excel export?

No. Collection is in the browser; Excel or Sheets can ingest JSON without code. Python is optional for automation.

Does this work for private TikTok accounts?

No. Only public posts.

Where is the API documented?

See /api-docs. The same token covers library, watching, AI and keyword alerts with a webhook.

Read next