How to Pick a Winner From TikTok Comments
Pick a fair giveaway winner: export the TikTok comments to a spreadsheet, remove duplicates and late entries, then draw at random in Excel or Google Sheets.
By the TokViewr team ·

To pick a winner from TikTok comments fairly, put every comment in a spreadsheet, remove the entries that do not count (late, duplicate or off-rule comments), and let a random formula choose one row. With the TikTok comment exporter on tokviewr.com the export takes a minute: paste the video link, download the TikTok comments as CSV or Excel, then do the draw in Excel or Google Sheets. One file holds up to 5,000 comments, so this method fits giveaways with up to 5,000 entries.
Before you draw: write your TikTok giveaway rules down
A draw is only as fair as its rules, and it is easiest to defend a winner when the rules were public before the first comment. Decide and post:
- The deadline, with a time zone. You will compare it with the comment times later.
- What counts as an entry: any comment, a comment that tags a friend, or a comment with a set word or hashtag.
- One entry per person, or more: whether extra comments earn extra chances.
- Who cannot win: your own account, team members, last month's winner.
TikTok does not run giveaways for you; local promotion laws and TikTok's own policies apply to how you run one, so check them for your country before you announce a prize.
Step 1: Export the TikTok comments
- Copy the video link: in the TikTok app, tap Share → Copy link.
- Open tokviewr.com, paste the link and sign in with Google if asked. This is a TokViewr account, not a TikTok login.
- In the export card, choose the number of rows (100, 500, 1,000, 5,000, or All when the video has fewer than 5,000 comments) and CSV or Excel.
- Leave Include comment replies off unless your rules count replies as entries.
- Press Export comments.
Each row is one TikTok comment with the columns below, always in this order:
| Column | Use in the draw |
|---|---|
text | Check for a required tag (@) or keyword |
created_at | Drop comments after the deadline (time in UTC) |
user_id | Remove duplicate entries from the same person |
user_handle | The winner's @username |
likes, reply_count, pinned | Not needed for a random draw |
Step 2: Remove entries that don't count
Do these in order, on a copy of the file, so you can always show the original.
- Late comments.
created_atis written like2026-11-03T03:09:57.000Z, in UTC. Text in this format sorts in time order, so sort the column A→Z and delete every row after your deadline, converted to UTC. - Your own account and excluded people. Filter
user_handleand delete their rows. - Comments that break the rules. For a tag-a-friend giveaway, use a text filter on
textfor rows that contain@; for a keyword rule, filter for that word. - Duplicates. If the rule is one entry per person, remove duplicates on the
user_idcolumn: in Excel, Data → Remove Duplicates; in Google Sheets, Data → Data cleanup → Remove duplicates. Useuser_id, not the nickname, because nicknames are not unique.
What is left is your list of valid TikTok giveaway entries. Note how many rows it has.
Step 3: Draw a random winner
The simplest draw that anyone can repeat:
- Add a column called
drawand put=RAND()in every row. - Sort the whole sheet by
draw. - The first row is the winner; the next rows are the backups if the winner does not reply.
If you prefer a single formula, with the handles in column I from row 2 to row 501:
=INDEX(I2:I501, RANDBETWEEN(1, ROWS(I2:I501)))Both work in Excel and Google Sheets. RAND and RANDBETWEEN recalculate every time the sheet changes, so as soon as you have a result, copy the cell and paste it as a value, or the winner will change on the next edit. Recording your screen during the draw is the easiest way to show it was not picked by hand.
Step 4: Check the winner and announce
Before you announce, open the winning comment on the TikTok video and make sure it still exists and follows the rules. If your rules say the winner must follow you, check your follower list; the TikTok follower viewer opens it in a browser. Announce the @username in a comment or a new TikTok video, and keep the spreadsheet in case anyone asks how the winner was chosen.
Limits to know before a big TikTok giveaway
- Up to 5,000 comments per file. A video with more TikTok comments exports the first 5,000 in the order TikTok returns them, which is not every entry. For a giveaway with more entries than that, this method would leave people out, so it is not the right tool.
- Public comments only. Comments that were deleted, hidden by you or filtered by TikTok are not exported, so the file can have fewer rows than the comment count under the video.
- One video per export. For a TikTok giveaway across several videos, export each one and paste the files into one sheet before removing duplicates.
What it costs
Each exported row uses one credit. New TokViewr accounts start with 100 credits, valid for 30 days, which covers a small giveaway. Bigger draws need a one-time pack: Starter is 25,000 rows for $19.99, and pack credits never expire. Reading the TikTok comments on the video page is free with 100 views a day; without a pack, the page shows the first 100 comments.
Common questions
Is there a free way to pick a winner from TikTok comments? For up to 100 comments, yes: a new TokViewr account's 100 free rows cover the export, and the draw itself happens in your own spreadsheet.
Can I count extra entries for tagging more friends? Yes. Skip the duplicate step and, if each tag is an entry, count the @ signs in text and copy the row that many times before the draw.
Do replies count as entries? Only if your rules say so. Turn on Include comment replies in the export; each reply is a row and costs one credit, and parent_comment_id shows which comment it answers.
Will the people who commented be notified? No. Exporting reads public comments; TokViewr does not notify anyone.
Ready to run your draw? Paste the video link into the TikTok comment exporter.
More guides
- Can Someone See If You Viewed Their TikTok Profile?
- Can Someone See If You Viewed Their TikTok Video?
- Can Someone See If You Viewed Their TikTok Story?
- Who Can See Your Reposts on TikTok?
- How to Export TikTok Comments to CSV or Excel
- How to See Someone’s TikTok Followers Without an Account
- How to Read TikTok Comments Without Logging In
- How to Download All TikTok Videos From an Account at Once