Giveaways · entry list · fair pick
Export giveaway entries to a spreadsheet
Every comment on the giveaway post in a spreadsheet, so you can apply the rules you announced, see who qualifies, and keep a record. Free for posts with up to 1,000 comments, every entry read.
Build the entry list
- Export after the deadline. Comments that arrive later are not in the file, which is what you want.
- Drop replies. Filter
is_replytono. Replies are usually conversations, not entries. - Drop your own account and any staff accounts: filter
username. - Apply the tag rule. Helper column:
=IF(K2="",0,LEN(K2)-LEN(SUBSTITUTE(K2,"@","")))counts the @ tags. Keep rows where it is at least the number you announced. - One entry per person. Data, Remove Duplicates on
username(sort byposted_at_utcfirst to keep each person's first comment). - Freeze the list. Copy the remaining usernames to a new sheet called
Entries. Count them with=COUNTA(A2:A)and write that number down, with the date and time.
Picking a winner with a formula
With the entries in Entries!A2:A, this returns one random username:
=INDEX(Entries!A2:A, RANDBETWEEN(1, COUNTA(Entries!A2:A)))
It works, with three weaknesses worth knowing:
- It changes every time the sheet recalculates. Any edit, or reopening the file, picks someone else. Copy the result and Paste values immediately.
- Nobody else can repeat it. There is no record of the random number, so an entrant who asks "was this fair?" gets your word and nothing else.
- Rerolls are invisible. Nothing stops a second or third try, and nothing shows that it happened.
For several winners without repeats: add =RAND() next to every entry, Paste values over that column, sort by it, and take the top rows. Same caveats.
Why a seeded draw is easier to defend
A draw tool that publishes its random seed and a fingerprint (a hash) of the entry list solves all three problems: the list is locked before the draw, anyone can rerun the shuffle with the published seed and get the same winner, and a redraw shows up as a new seed. If your giveaway is big enough that people will ask questions, use a draw that leaves that kind of proof, and keep this spreadsheet as your own record of who entered.
A list with gaps is not a fair list
If the export missed entries, the draw was unfair before it started. A free export here is limited by post size (up to 1,000 comments), not by a reading timer, so every entry on a post that size is in the file. The export page shows comments read next to Instagram's count; Instagram's number can be a little higher because it counts comments it hides from everyone, which no tool can read.
Questions
Can I check that entrants follow my account?
Not from a comment export: the file holds comments, not followers. Check the winner by hand, or use a draw tool that checks the drawn winners.
What if someone commented after the deadline?
Filter posted_at_utc to before your deadline, remembering the times are UTC.
How do I prove the list I drew from?
Keep the downloaded file, unedited, alongside your filtered Entries sheet. The file name carries the account and post code, and the JSON download records when the comments were read.