IGComments

Guides

Find your most loyal commenters across several Instagram posts

Who comments on one post is a snapshot. Who comments on five posts is your community. Here is how to combine exports and rank people by how many different posts they showed up on.

Updated Nov 17, 2026 · 7 min read

Why one post is not enough

The most active commenters on a post tells you who wrote the most on that post. Loyalty is different: it is about showing up again. Someone who left forty comments on one giveaway may never be seen again, and someone who left one comment on each of your last six posts is the person you would want to thank. Only a combined file shows that.

IGComments works one post at a time, and the combining is done in a spreadsheet. That is a few minutes of work, and it keeps you in control of which posts count.

Step 1: export each post and label it

Get each post’s comments from the home page tool. Each post up to the free limit of 200 comments is free; larger posts need a one-time pass. Download as Excel or CSV. Pick posts that make sense to compare: the same account, a similar period, and ideally not all giveaways, because giveaway entrants are a different crowd from regular fans.

Open a blank sheet. Paste the first export with its header row. Then paste each next export below it without the header. In a new column M, label every row with its post, such as post1, post2. Make sure all files are from the same version of the tool so the columns line up (they are: #, comment_id, username, user_id, comment, posted_at_utc, likes, is_reply, reply_to_comment_id, reply_to_username, mentions, hashtags).

Step 2: decide what counts, then filter

  • Exclude the account owner. The account replies to everyone, so it will top every list. Delete its rows or filter them out.
  • Top-level or replies? For loyalty, a reply is real engagement. If you only want people who start comments, filter is_reply to no. Decide first, so the result is not shaped by the answer you want.
  • Use user_id, not the username. People rename their accounts. The user_id (column D) stays the same when a name changes, so counting on it keeps one person as one person. Keep a name next to it for reading.

Step 3: count distinct posts per person

Pivot table (Excel and Google Sheets). Insert a pivot table from all the data. Put user_id in Rows, username in Rows below it so you can read it, and post (column M) in Values, summarised as a distinct count. In Excel, tick Add this data to the Data Model when you create the pivot table to unlock Distinct Count. In Google Sheets, add post to Values and choose COUNTUNIQUE. Sort by that value, descending.

Formula route (Excel 365 and Google Sheets). Put each person once in a new sheet with =UNIQUE(Data!D2:D20000), and next to each one:

=COUNTA(UNIQUE(FILTER(Data!M2:M20000, Data!D2:D20000=A2)))

A2 is the user_id in that row. The result is how many different posts that person commented on. Use =COUNTIFS(Data!D2:D20000, A2) beside it for the total number of comments, which also works in older versions of Excel.

Step 4: read the result

A person present on most of your posts is a regular. Three more columns help:

  • Likes received. =SUMIFS(Data!G2:G20000, Data!D2:D20000, A2) adds the likes on that person’s comments, a rough measure of whether others value what they write.
  • First and last seen. =MINIFS(Data!F2:F20000, Data!D2:D20000, A2) and MAXIFS show the span, if the timestamps are real dates (use VALUE() if they came in as text, see timestamps).
  • Typical comment. Filter the data to that user_id and read the comments. Ten identical comments across posts is a different story from ten thoughtful ones; see checks for repeated and generic comments.

What to do with the list, and what to leave out

Thank them in a reply, feature them in a post, send an early look at something, or invite a few into a conversation about what to make next. Treat the list as a prompt to talk to people publicly on Instagram, not as a contact list: the export contains usernames and comment text, not emails or profile details. For a short note on handling commenter data responsibly, see is it legal to export Instagram comments.

Two limits: comments Instagram hides or filters do not appear for anyone, so a loyal fan whose comments are always filtered will look absent, and a person who changes their account to a new one has a new user_id too.

FAQ

Can IGComments combine several posts for me?

It exports one post at a time. You paste the exports into one sheet and count there, which this guide shows step by step.

Why count by user_id instead of username?

Usernames can be changed. The user_id stays the same, so one person remains one person across posts and over time.

How many posts should I compare?

Enough to see repetition: five or more recent posts is a reasonable start. With two posts you mostly learn who overlaps.

Should giveaway posts be included?

Usually not. Entrants come for the prize. Compare regular posts if you want to find fans.

Does the export include emails or follower counts?

No. The export has usernames, user IDs and comment data only.