How to export TikTok comments to Excel or CSV
You can download TikTok comments as an Excel workbook or CSV directly from Trendilens. Collect comments first, then use Export. There is no need to convert JSON or use an API token.
From a post link to a spreadsheet
- Copy the public TikTok post link using Share → Copy link. A video link or a short TikTok share link works.
- Paste it into the form on this page and select Preview post for free. Check that the author and description match the post you want.
- Continue to the workspace and sign in. Confirm comment collection from your shared credit balance.
- Once collection finishes, open Export in the analysis toolbar and choose Excel (.xlsx), CSV or JSON. For Excel, open the comments sheet.
- In Excel, open the comments sheet. Turn on filters to search comment text, compare dates or group rows by username.
Choose CSV, Excel or JSON
- Excel (.xlsx): separate post and comments sheets. Open the comments sheet to filter rows by text, author or date.
- CSV: post metadata comes first, followed by a separate comments header and rows. For a CRM import, keep the comments section and map its columns.
- JSON: the structured analysis, including collected replies, for your own tools. Download it from the same Export menu; an API token is not needed for file downloads.
What your comment export contains
Each collected comment or reply has its own row in the spreadsheet. Fields include text, username, likes, timestamps and comment IDs. parent_comment_id links a reply to its parent; fields that the platform does not return can be empty.
| comment_id | parent_comment_id | user_unique_id | text | like_count |
|---|---|---|---|---|
| 1001 | sample_customer | Is this available in blue? | 12 | |
| 1002 | 1001 | sample_creator | Yes, blue is available. | 3 |
Import into Google Sheets or a CRM
In Google Sheets, use File → Import → Upload and select the downloaded Excel workbook. Open the imported comments sheet. The file is a snapshot; importing it does not connect Sheets to the original post.
For a CRM that accepts CSV, use the comments section of the CSV and remove the preceding post-metadata section. Match text, user_unique_id and create_time_iso to the destination fields. Keep comment_id and parent_comment_id if you need reply relationships.
What is free, and what costs money?
Checking a post's author, description and metrics is free. After registration and email verification, the account receives 50 shared credits for comments, profiles, videos and AI.
For larger collections, packs start at $5 for 2,000 comments; a 10,000-comment pack costs $7. Collection uses your comment balance. Downloading an already collected result does not start another collection.
The comment balance is shared across supported platforms and lasts until the end of the month. AI analysis is optional and uses additional credits; it is not required to export comments. See all packs and conditions.
Which TikTok comments can be collected?
The TikTok comment scraper runs on our servers. You do not need to install an extension, write a script or configure proxies.
Only comments available to the collector are returned. Private or deleted content, platform restrictions, your balance and collection limits can reduce the result. The count shown on TikTok is not a guarantee that every comment is accessible.
An export is a snapshot of the collection. Later comments are not added to a downloaded file automatically.
Frequently asked questions
Do I need Python, Power Query or an API token?
No. The Export menu downloads CSV, Excel and JSON files directly. Automation through the API is optional.
Where are the comments in the Excel file?
Open the comments sheet. The post sheet contains post metadata. If there is no comments sheet, you may have exported only the metadata preview or a result without collected comments.
Does exporting the file collect new comments?
No. It downloads the result already available in your workspace. New comments require a separate collection; a downloaded file is not a live feed.