How to Export TikTok Comments to CSV/Excel

Exporting TikTok comments used to mean manually copying and pasting — hours of work for just a few thousand comments. With the right tool, you can export TikTok comments to CSV or Excel in under a minute, no login required.

Why Export TikTok Comments?

There are many reasons you might need to export TikTok comments:

• Sentiment Analysis: Analyze what your audience really thinks about your content
• Lead Generation: Collect usernames and comments for outreach campaigns
• Giveaways: Fairly select random winners from comment participants
• Market Research: Understand audience preferences and pain points
• Content Inspiration: Find common questions and topics your audience cares about

How to Export TikTok Comments (Step-by-Step)

Step 1: Copy the TikTok Video URL

Open TikTok and find the video you want to export comments from. Tap the share button and select "Copy Link." The URL will look like: https://www.tiktok.com/@username/video/1234567890

Step 2: Paste the URL

Go to ExportTok and paste the TikTok video URL into the export form. You don't need to create an account for a single export — although new users get 1,000 free credits.

Step 3: Choose Export Format

Select CSV or Excel (XLSX) format. CSV works with Google Sheets, Excel, and any data analysis tool. Excel preserves formatting and is best for sharing with teams.

Step 4: Download

Click Export and wait a few seconds. Your file will download automatically with all comments including usernames, timestamps, like counts, and reply counts.

Pro tip: Export comments within 48 hours of posting for the most engagement data. Older videos may have fewer active comments to analyze.

What Data is Included?

The exported file includes these fields for each comment:

• Comment ID (unique identifier)
• Comment text (the actual comment)
• Username and Display Name
• User ID
• Comment timestamp
• Like count (diggs)
• Reply count
• Reply-to information (for nested replies)
• Video ID (for reference)

How Many Comments Can You Export?

The free tier allows you to export up to 1,000 comments. Pro subscribers can export tens of thousands of comments per video, and batch export allows up to 50 videos at once.

Is It Safe? Zero Ban Risk

ExportTok uses TikTok's public API to fetch comments — the same data visible on any public video. No login to TikTok is required, which means zero risk to your account. This is different from browser extensions or unofficial apps that require your TikTok credentials.

Batch Export for Multiple Videos

If you need to export comments from multiple videos at once, use the batch export tool. Paste up to 50 video URLs and get all comments in a single file — perfect for monthly reporting or competitive analysis.