← Back to Blog

How to Export TikTok Comments to Excel (2026 Guide)

ExportComments Team·March 1, 2026·3 min read

Why Export TikTok Comments?

TikTok comments are a goldmine of audience insights. Whether you're a brand monitoring sentiment, a creator tracking engagement, or a researcher studying trends, having comments in a spreadsheet unlocks powerful analysis.

Common use cases include:

  • Brand monitoring — Track what people say about your product launches
  • Competitor analysis — See how audiences react to competitor content
  • Content strategy — Find common questions to create follow-up videos
  • Giveaway management — Collect and filter entries from comment-based giveaways
  • Sentiment tracking — Understand if your audience response is positive or negative

Step-by-Step: Export TikTok Comments with ExportComments

Step 1: Copy the TikTok Video URL

Open the TikTok video in your browser or app. Copy the URL from the address bar. It should look like:

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

Step 2: Paste into ExportComments

Go to your ExportComments dashboard and click New Export. Paste the TikTok URL into the input field. The platform will automatically detect it as a TikTok video.

Step 3: Choose Your Format

Select your preferred export format:

  • CSV — Opens in any spreadsheet app (free on all plans)
  • Excel (.xlsx) — Native Excel format with formatting (Creator+)
  • JSON — For developers and data pipelines (Creator+)
  • Google Sheets — Direct push to your Google account (Pro+)

Step 4: Download Your Export

Click Export Comments and wait for the scraping to complete. Depending on the number of comments, this usually takes 10-60 seconds. Once done, download your file.

What Data Do You Get?

Each exported comment includes:

| Field | Description | |-------|-------------| | Author | Username of the commenter | | Text | Full comment text | | Likes | Number of likes on the comment | | Replies | Number of replies | | Date | When the comment was posted | | Verified | Whether the author is verified |

Bonus: AI-Powered Analysis

After exporting, click Analyze to run AI sentiment analysis on all comments. You'll get:

  • Sentiment breakdown (positive, negative, neutral percentages)
  • Top discussion topics automatically extracted
  • Spam and bot detection
  • An executive summary of the conversation

Using the Chrome Extension

Install the ExportComments Chrome extension to export comments without leaving TikTok. Just browse to any video, click the floating export button, and choose your format. The export runs in the background and you'll get a notification when it's ready.

Tips for Large Videos

Videos with 10,000+ comments may take a few minutes to export. Here are some tips:

  1. Start the export and move on — You'll get an email when it's complete
  2. Use the monitoring feature — Set up a monitor to automatically export new comments daily
  3. Filter in Excel — Use Excel's built-in filter to focus on specific keywords or date ranges

Frequently Asked Questions

Is it free to export TikTok comments?

Yes! The free plan includes 25 exports per month in CSV format. Upgrade to Creator ($9/mo) for Excel and JSON formats with unlimited exports.

How many comments can I export?

There's no limit on the number of comments per export. We'll scrape every comment on the video.

Does it work with TikTok ads?

Yes, as long as the video URL is publicly accessible, you can export its comments.