How to Export TikTok Comments to Excel, CSV, or JSON

To export TikTok comments, copy the URL of a public TikTok video, paste it into a TikTok comment exporter, review the available comments, and download an Excel-ready CSV or JSON file.

CommentGrid's free TikTok Comment Exporter works in your browser without a TikTok login, API key, or extension. It turns available public comments into structured rows that you can filter, save, and reuse.

Export TikTok comments in 5 steps

1. Open the public TikTok video whose comments you want to export.
2. Use Share > Copy link, or copy the video URL from your browser.
3. Paste the URL into the TikTok Comment Exporter.
4. Start the export and review the available comment rows.
5. Download CSV for Excel or Google Sheets, or JSON for a structured workflow.

If you need a native Excel workbook, open the CSV in Microsoft Excel and save it as an .xlsx file. CSV is a spreadsheet-ready format rather than an Excel workbook format.

How to export comments from a TikTok video

1. Copy the TikTok video URL

Open the video in the TikTok app and tap Share, then choose Copy link. On a computer, open the video on TikTok.com and copy its URL from the address bar.

A standard video link usually looks like this:

https://www.tiktok.com/@username/video/1234567890123456789

The exporter is designed for public TikTok videos that are accessible through a valid URL. Private, deleted, restricted, region-limited, age-limited, or otherwise unavailable videos may not be retrievable.

2. Paste the URL into CommentGrid

Open the free TikTok Comment Exporter, paste the video link into the input field, and start the export.

The web tool does not require your TikTok password or a TikTok developer account. Keep the page open while the comments are being processed. A larger or fast-changing comment section may take longer than a small one.

3. Review the exported comments

Before downloading, confirm that the results belong to the correct video. Scan the table, check the fields you need, and compare a small sample with the comments visible on TikTok.

Depending on what is available for the video, the export can include:

Field	What it is useful for
Comment text	Feedback analysis, topic research, moderation, or giveaway review
Comment time	Chronological sorting and campaign-period checks when available
Author username	Grouping comments by participant or public account
User profile URL	Returning to the public profile when available
Like count	Finding comments with visible engagement
Reply count	Identifying discussions that generated responses
Comment ID	Referencing or deduplicating a specific comment

The available fields and number of returned comments can vary with the video, comment visibility, TikTok's current behavior, and processing conditions.

4. Download CSV for Excel or Google Sheets

CSV is the easiest format for most research, reporting, moderation, and campaign workflows. Each available comment appears as a row, while fields such as comment text, username, time, likes, and replies appear in separate columns.

To open the export in Microsoft Excel:

1. Download the CSV file.
2. In Excel, choose File > Open or Data > From Text/CSV.
3. Select the file.
4. Confirm that the delimiter is a comma.
5. Choose UTF-8 encoding if emoji or international characters do not display correctly.
6. Save the file as an Excel Workbook (.xlsx) if required.

To use Google Sheets:

1. Create or open a spreadsheet.
2. Choose File > Import > Upload.
3. Select the downloaded CSV.
4. Import it into a new sheet or replace the current sheet.

5. Download JSON for code or automation

JSON stores each comment as structured fields and values. Choose it when you plan to use the data in a script, database, automation, archive, or developer workflow.

Use CSV when people will sort and review the comments in a spreadsheet. Use JSON when software will process the records.

Can you export every comment from a TikTok video?

An export is a record of the comments available to the tool during that run. It should not be described as a guaranteed copy of every comment ever posted.

A comment may be absent because it is:

• Deleted by the author or video owner
• Hidden, filtered, or held by moderation
• Part of a reply thread that is not currently available
• Attached to private, restricted, or unavailable content
• Added or removed after the export began
• Unavailable because of platform behavior or processing limits

TikTok's displayed comment total and the number of rows in a file can also differ because replies may be counted or returned differently. If completeness matters, compare a sample with the source video and record the export date.

Even TikTok's official Research API notes that a comment request may return fewer records than requested, including when comments have been deleted. Treat any exported dataset as a timestamped capture, not a permanent mirror of the comment section.

How to clean a TikTok comment CSV

Keep an untouched copy of the original export. Perform cleanup in a duplicate sheet so you can check any decision against the source file later.

Freeze the header and enable filters

Freeze the first row and turn on spreadsheet filters. You can then search or sort by username, comment text, date, likes, or replies without losing track of the column names.

Remove empty or irrelevant rows carefully

What counts as irrelevant depends on your goal. For audience research, you might remove empty rows or comments unrelated to the topic. For a giveaway, remove an entry only when it fails the rules published before the campaign began.

Decide how repeated comments should count

Repeated authors are not automatically duplicate data. Choose a rule that matches the analysis:

• For unique-participant analysis, keep one row per username.
• For comment-volume analysis, keep every available comment.
• For topic or sentiment analysis, retain meaningful repeated comments but consider separating obvious copy-paste spam.
• For giveaways, follow the duplicate policy in the official entry rules.

Do not silently reduce multiple qualifying giveaway comments to one entry when the rules promised a chance for each valid comment.

Add analysis columns

Useful spreadsheet columns include:

• Theme for recurring questions, requests, or discussion topics
• Sentiment for positive, neutral, negative, or mixed reactions
• Needs reply for community-management follow-up
• Spam or duplicate for review rather than automatic deletion
• Valid entry for giveaway eligibility
• Review note for exclusions or unusual cases

Define each label before tagging a large file. If an automated tool assigns themes or sentiment, manually check a sample—TikTok slang, emoji, sarcasm, and mixed-language comments can be easy to misclassify.

What can you do with exported TikTok comments?

Find audience questions and content ideas

Filter for question marks and phrases such as “how,” “where,” “can you,” “what is,” or “part two.” Repeated questions can become new videos, product FAQs, support articles, or follow-up posts.

Group similar questions rather than counting only exact wording. “Where did you buy this?” and “link?” may represent the same audience need.

Analyze product and campaign feedback

Tag comments as praise, complaint, question, objection, request, or unrelated discussion. This provides more context than the video's total comment count alone.

Keep a link or comment ID when available so you can return to the source before quoting a commenter or acting on a sensitive finding.

Build a reply queue

Add columns such as Needs reply, Priority, Owner, and Status. A team can then separate support questions, sales interest, creator inquiries, and general engagement without repeatedly scrolling through the video.

Prepare TikTok giveaway entries

An export can provide a reviewable list of comment entries. If your goal is to remove invalid entries, handle duplicate users, and run a random draw, use the TikTok Giveaway Picker and follow the guide to picking a winner from TikTok comments.

Comment data alone cannot reliably prove that someone followed an account, liked a video, reposted it, or completed an off-platform action. Verify those conditions separately when your published rules require them.

Create a campaign or research record

Record the video URL, export date, number of returned rows, filters applied, and any rows excluded. This makes the file easier to compare with later exports and easier for a teammate to review.

When sharing results, minimize unnecessary personal information. A public comment can still contain a name, handle, opinion, location, or other information that should not be republished without a clear reason.

Other ways to get TikTok comment data

Manual copy and paste

Copying visible comments can work when you need only one or two examples. It becomes slow and inconsistent when comments load dynamically, replies are collapsed, or you need structured fields such as usernames, timestamps, likes, and comment IDs.

Manual copying is best for a small quote. Exporting is better for a dataset.

TikTok Research API

TikTok provides an official Research API for querying video comments. It can return fields such as comment text, comment ID, creation time, like count, reply count, and parent comment ID through paginated requests.

This is not a general-purpose exporter for every creator or business. TikTok's Research Tools require an application and approval for an eligible research project. The API is appropriate for qualifying researchers who need a repeatable, programmatic workflow; a public-URL exporter is simpler for a one-off spreadsheet.

Browser extensions

Some extensions collect comments while you browse TikTok. This can be convenient for frequent exports, but it requires installing software and reviewing its permissions, privacy practices, maintenance history, and data-handling terms.

If you only need one export, a no-install web workflow reduces setup. If you choose an extension, verify who publishes it and what access it requests before installing it.

Common TikTok comment export problems

The TikTok video cannot be loaded

Open the URL in a private browser window. If the video or comments are not publicly accessible there, a no-login exporter may not be able to process them. Confirm that the link points to the video rather than a profile, search page, or shortened link that no longer resolves.

The exported count differs from TikTok's count

Counts can differ because of replies, moderation, deletions, accessibility, changing comments, platform behavior, or processing limits. Use the export as a timestamped record of what was returned rather than a guarantee of every historical comment.

All CSV data appears in one Excel column

Import the file through Data > From Text/CSV and select a comma as the delimiter. Some regional spreadsheet settings expect a semicolon by default.

Emoji or non-English text is broken

Reimport the CSV using UTF-8 encoding. Avoid opening and resaving the file through older software that changes its character encoding.

A long TikTok comment appears cut off

The full text may still be in the spreadsheet cell. Enable Wrap Text, widen the column, or inspect the formula bar. If the source returned shortened text, return to the original comment through its ID or profile context when available.

The file contains repeated users or comments

First decide whether repeated rows are invalid for your purpose. Keep all valid comments for volume analysis; deduplicate by username only when you need unique participants or when giveaway rules allow one entry per person.

Frequently asked questions

Can I export TikTok comments to Excel?

Yes. Download an Excel-ready CSV, open it in Microsoft Excel, and save it as an .xlsx workbook if you need the native Excel format.

Can I download TikTok comments for free?

CommentGrid provides a free browser-based workflow for public TikTok video URLs. The number of returned comments depends on the video, comment availability, platform behavior, and processing limits.

Do I need to log into TikTok?

No. CommentGrid's public-URL workflow does not require your TikTok password. It cannot bypass privacy, region, age, deletion, or other access restrictions.

Can I export comments from someone else's TikTok video?

The tool is designed to process comments from publicly accessible video URLs. Public availability does not remove your responsibilities: collect only what you need, avoid unnecessary redistribution, and review TikTok's current Terms of Service, privacy requirements, and applicable rules for your use case.

Does the export include TikTok replies?

Reply availability can vary with the video and what TikTok makes accessible during the export. Review the file before assuming that every nested reply is present.

Is CSV or JSON better?

Use CSV for Excel, Google Sheets, sorting, filtering, tagging, and manual review. Use JSON for code, databases, automations, or systems that expect structured fields and values.

Is there a limit on how many TikTok comments I can export?

The practical result depends on the video's available comments and current platform and processing conditions. Avoid treating any exporter as an unlimited or guaranteed copy of every comment. For a large or important dataset, review the returned row count and keep a timestamped original file.

Can I use a TikTok comment export for sentiment analysis?

Yes. Add labels manually or import the CSV into a suitable analysis workflow. Check automated results against a human-reviewed sample because slang, sarcasm, emoji, and context can affect sentiment labels.

Can I use the comments to pick a giveaway winner?

Yes. The export can serve as the entry record. For duplicate filtering, eligibility review, random selection, and downloadable winner records, use the dedicated TikTok Giveaway Picker.

Export TikTok comments to a spreadsheet

Copy the public video URL and open the free TikTok Comment Exporter. Review the available comments, download CSV for Excel or Google Sheets, or choose JSON for a structured workflow.

CommentGrid is an independent tool and is not affiliated with or endorsed by TikTok.