[Home](/) / [How To](/how-to/) / TikTok

How to

# How to export TikTok comments to Excel

Comments are where viewers ask questions, complain and say what they want. Here is how to get all of them in a spreadsheet.

**Short answer**

Paste the video URLs into the **TikTok Comments Scraper** and set a maximum. You get one row per comment or reply with the text, author, likes and reply count. Download as Excel or CSV.

## A real use case

A brand ran a giveaway asking people to comment. They need every entry to pick a winner. They paste the video link, export 4,000 comments, remove duplicates by username and draw a winner from the sheet.

## Step by step

1. **Copy the video links** from TikTok (Share, then Copy link).
2. **Paste them** into TikTok video URLs, one per line.
3. **Set Maximum results** high enough for every comment you need.
4. **Run**, then export to Excel. Filter `isReply` to separate replies.

### Input (paste into the JSON tab)

```
{
  "videoUrls": [
    "https://www.tiktok.com/@yourbrand/video/7391234567890123456"
  ],
  "maxResults": 5000
}
```

### What you get back

```
{
  "resultType": "comment",
  "text": "do you ship to Canada?",
  "username": "maple.mia",
  "likes": 902,
  "replyCount": 6,
  "isReply": false,
  "postedAt": "2026-10-12T18:04:11Z"
}
```

Trimmed example. Names and numbers are illustrative; your run returns real data with more fields.

## Tips

- Sort by `likes` to see the questions most people share.
- For giveaways, dedupe by `username` before you draw.
- `likedByAuthor` and `pinned` show what the creator engaged with.

## What it costs

$1 per 1,000 comments. 4,000 comments cost about **$4**.

Plus a small per-run start fee. Apify's free plan includes monthly credit, enough to test. Check the listing for current pricing.

## FAQ

**Does it include replies?**

Yes. Replies come as their own rows with isReply set to true.

**Can I scrape comments from many videos at once?**

Yes. Paste as many video URLs as you like; the maximum applies to the whole run.

## Related

- [**TikTok Comments Scraper**](https://apify.com/scrape-lads/tiktok-comments-scraper?utm_source=scrapelads&utm_medium=site&utm_campaign=how-to-export-tiktok-comments&utm_content=tiktok-comments-scraper) Comments and replies from TikTok video URLs. $1 / 1,000 comments.
- [How to find TikTok influencer emails](/how-to/find-tiktok-influencer-emails/)
- [How to find micro influencers on TikTok](/how-to/find-tiktok-micro-influencers/)
- [How to find TikTok Shop affiliate creators](/how-to/find-tiktok-shop-creators/)
- [How to export TikTok followers to CSV](/how-to/export-tiktok-followers/)
- [How to calculate TikTok engagement rate](/how-to/calculate-tiktok-engagement-rate/)
- [All How To guides](/how-to/)

## Try it on your own data

Paste the input above, run it, and see your results in a couple of minutes.
[Open TikTok Comments Scraper](https://apify.com/scrape-lads/tiktok-comments-scraper?utm_source=scrapelads&utm_medium=site&utm_campaign=how-to-export-tiktok-comments&utm_content=tiktok-comments-scraper)