ScrapeLads
Run on Apify

Home / 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

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