Can Instagram count comment votes for me?

No. Instagram shows a total comment count and lets you scroll, but it has no way to group or count comments by what they say. To tally votes you need the comments in a spreadsheet, which is what the export gives you.

How do I count votes in Instagram comments?

Download the post's comments as CSV or Excel, add a column with the cleaned-up vote (for example 'A3' or '27'), remove repeat votes from the same username, then use COUNTIF or a pivot table to count each entry.

The first 100 comments of any public Instagram post are free with no signup. Contest posts with more comments need a one-time payment, never a subscription, so the whole vote is counted rather than a sample.

Is it allowed to run a vote in Instagram comments?

Yes, comment-based contests are common. Instagram's promotion guidelines put the responsibility for lawful rules on the person running it, and say you must not ask people to tag themselves in content they are not in. Publish your rules, including how votes are counted, before voting opens.

Will the voters or the post owner be notified that I downloaded the comments?

No. The export reads the public comments the same way a visitor's browser does. Nobody receives a notification, and it works on your own posts and on any other public post.

Should one person be allowed to vote more than once?

That is your rule to set, but say it up front. Most hosts count one vote per account, the first one posted. The export includes the username and created_at for every comment, so either rule is easy to apply.

Do votes in replies count?

Decide before you count. Replies are often conversations ('good luck!') rather than votes. Rows with an empty reply_to_id are top-level comments; filter to those if your rules say only top-level comments count.

Why is my total lower than the comment count on the post?

Instagram's badge includes comments that are hidden by its filters, restricted accounts and deleted comments. The export holds the comments that are actually publicly visible, which is the right set to count votes from.

Can I count votes across several posts?

Yes. Download each post, stack the files into one sheet with a column for the post link, and count on the combined sheet. A pass lets you paste several links at once.

How do I prove the result is fair?

Keep the original downloaded file unchanged, do your cleaning in a copy, and publish the per-entry counts with the time you downloaded. Anyone can then check that the numbers match the comments.

Instagram Comment Vote Count — Tally Contest Votes From Comments (Free CSV, Excel & JSON Download, 2026)

An Instagram comment vote count sounds like something the app should do for you: you post the shortlist, ask followers to comment the number of their favourite, and wait for the totals. Instagram never gives you totals. It gives you a scroll. This guide shows how to download every comment on the contest post free, turn messy comments like "Vote for #7!!! 😍" into clean votes, keep one vote per account, and publish a count that holds up when the runner-up asks how you got it.

Why Instagram can't tell you who's winning

The comment panel is built for reading, not counting. There is no search inside a post's comments, no filter by text, and no sort beyond what Instagram decides to show first. On a post with a few dozen comments you can count by hand. Past a couple of hundred, people start losing their place, double-counting, and missing votes that load late because Instagram only fetches comments in small batches as you scroll.

The comment badge doesn't help either. It counts comments that are hidden by Instagram's filters and by your own hidden-words settings, so it is usually higher than the number of comments you can actually see. We explain that gap in detail in why the comment badge is higher than the exported row count. For a vote, the set that matters is the visible public comments, and that is exactly what a download gives you: one row per comment, with the username, the text and the time it was posted.

What a vote looks like in the wild

Before you count anything, look at how people actually vote. On contest posts we see the same patterns again and again:

Clean codes: "A3", "27", "B".
Codes inside words: "Photo 27 for sure", "vote no.4", "#12 ❤️".
Names instead of codes: "Maria's cake!" when entry 5 is Maria's cake.
Several votes in one comment: "3 and 9", "A1 A1 A1".
Non-votes: tags of friends, "when are results?", emoji-only comments, and the entrants campaigning for themselves.

Your rules should say what counts. "Comment the number of your favourite. One vote per account; your first comment counts; comments that name more than one entry are void" covers almost every dispute we have seen. Write it in the caption before voting opens, not after the count, and you will rarely have to defend a decision.

Choose codes that are easy to count

If you are still planning the contest, give entries short, distinct codes. Numbers work well; letter-number codes like A1–A9 and B1–B9 work for categories. Avoid codes that are also common words ("I", "A" on its own) or that appear inside other codes (1 inside 12, 13, 14). Plain numbers are fine as long as you extract them carefully, which the next section handles.

The tally, step by step

Once the voting deadline has passed, paste the post link into the Instagram comment exporter and download CSV or Excel. Open it in Excel or Google Sheets. The columns you need are username, text, created_at and reply_to_id; the rest (author, likes, replies, language, is_pinned, id, avatar_url) can be hidden while you count.

1. Duplicate the sheet

Keep the original tab untouched. Do every edit on a copy called "count". If anyone challenges the result, the untouched tab is your record of exactly what was on the post when you downloaded it.

2. Keep top-level comments only (if your rules say so)

Filter reply_to_id to blanks. Replies are mostly conversation, and counting them invites the "my friend replied to my vote, does that count twice?" argument.

3. Extract the vote

Add a column called vote. In Google Sheets, a formula like =UPPER(REGEXEXTRACT(B2, "[A-Za-z]?[0-9]+")) pulls the first code such as "A3" or "27" out of the comment text. Google documents the pattern syntax in its REGEXEXTRACT help page. In Excel, newer versions have REGEXEXTRACT too; otherwise use a helper column and Find & Replace to strip words like "vote", "photo", "no." and "#". Wrap the formula in IFERROR so comments without a code show blank instead of an error.

Then scan the blanks. That is where the name-votes ("Maria's cake!") live; type the matching code in by hand. On most contests it is a few minutes of work.

4. Apply one vote per account

Sort the sheet by created_at, oldest first, then remove duplicates on the username column (Data → Data cleanup → Remove duplicates in Sheets, Data → Remove Duplicates in Excel). Because the sheet is sorted oldest first, the tool keeps each account's first comment, which is the rule most hosts use. If your rule is "last vote counts", sort newest first instead.

5. Count

A pivot table on the vote column with COUNTA gives the total per entry in one step. If you prefer formulas, list the entry codes in a column and use =COUNTIF(count!E:E, H2) next to each; Microsoft's COUNTIF reference covers the details. Sort descending and you have a leaderboard.

6. Check the top two by hand

Filter the sheet to the winner's code and the runner-up's code and read every comment. This is where you catch the edge cases: a vote that was actually "not 7, vote 4", a bot-like run of identical comments, an entrant voting for themselves from five fresh accounts. It takes ten minutes and saves the week-long argument.

Rules that make the count defensible

Most contest disputes are not about arithmetic. They are about rules nobody wrote down. These are the ones worth deciding before you post:

Deadline in a time zone. "Voting closes Sunday 20:00 GMT+7". The created_at column is in UTC, so convert before you cut off late votes.
One vote per account, first comment counts. Easy to explain and easy to apply with the steps above.
Multiple codes in one comment are void. Otherwise "1 2 3 4 5" quietly votes for everyone.
Private and brand-new accounts. If you want to exclude accounts created for the vote, say so, and say how you will judge it. Our guide to spotting fake Instagram comments lists the signals worth checking.
Likes don't count. If you mean comments, say comments. A heart on someone else's vote comment is not a vote.

Instagram's own promotion guidelines place responsibility for the rules and for compliance with local law on the person running the promotion, and require a release of Instagram from liability. If there is a prize, check your country's rules on prize promotions too; the UK's ASA guidance on prize promotions is a clear example of what regulators expect: published closing dates, transparent selection, and prizes awarded as described.

When the badge and your total disagree

Expect your count to be lower than the number on the comment badge. Three reasons, in the order we see them:

Hidden comments. Instagram's "Hide offensive comments" and "hidden words" filters, plus the post owner's own filters, keep comments off the public list while still counting them in the badge. These were never visible votes.
Replies. If you filtered to top-level comments, the replies are excluded on purpose.
Duplicates removed. One vote per account removes every repeat, and on a heated contest that can be a third of the rows.

Write the funnel down when you publish: "1,240 comments downloaded, 1,102 top-level, 811 contained a valid code, 640 after one vote per account." A funnel like that answers the "but the post says 1,400 comments" question before anyone asks it.

Free sample vs the full vote

The first 100 comments are free on any public post, which is plenty for a small contest and a good way to test your formulas on a big one. Don't announce a winner from a 100-row sample on a contest with 2,000 comments: early comments skew toward the entrants' own friends, who vote first. Download the full section for the final count.

Contests spread across several posts

Some hosts post each entry separately and count comments as votes ("comment on your favourite"), or run a carousel per category. The method is the same with one extra column: download each post, paste the files into one sheet, and add a post column with the link or entry name. Count rows per post instead of per code. Exporting many links at once is covered in exporting comments from multiple posts at once.

Watch for one trap: in per-post voting, the same account can comment on several entries. If your rule is one vote in total, remove duplicates on username across the combined sheet, not per post.

Publishing the result without a fight

Announce three things: the winner, the per-entry counts, and the time you downloaded the comments. A screenshot of the pivot table is enough for most audiences. For a contest with a real prize, keep the original file for a few weeks in case anyone asks, and be ready to share the count for their entry.

If the vote decides a shortlist and a random draw picks the final winner among voters, keep the steps separate: count first, then draw. A free Instagram giveaway picker handles the random part, and our guide to verifying giveaway entries in a spreadsheet shows how to check tags and follows before drawing.

What we've learned counting votes for contest hosts

Giveaway and contest hosts are the largest group of people who pay for Instagram exports on ZocialComment. We know this because we read the comment files people download when we investigate support requests: photo contests where comments say "Foto 27", school competitions voting "A1" to "C4", bakery contests where people vote by name. A few things we have learned from operating the exporter:

The badge-versus-rows gap is the most common support question on contest posts. It is almost always hidden comments, not missing data, and we keep created_at and username in every file so hosts can show their working.
Entrants campaign for themselves, and their friends vote in the first hour. That is why we tell hosts never to call a result from the free sample of a large post.
Most disputes we hear about come from rules written after the count. Hosts who publish the counting rule in the caption almost never write to us about a challenge.

The column names, the free first 100 comments and the one-time payment for longer comment sections are the live product values; see pricing for the current options. For anything about what Instagram allows, Instagram's own help centre linked above is the authority, not us.

Download Instagram comments free and count your votes →