Find spam patterns and repeat offenders in your Instagram comments
Moderating in the app means scrolling and tapping one comment at a time. With the comments in a sheet you can see the whole pattern at once: the same message from twenty accounts, one account on every thread. Then you act in the app.
Updated Nov 17, 2026 · 7 min read
What this does and does not do
IGComments reads public comments and does not log in to your account. That means it can find patterns, but it cannot delete, hide, restrict or block anyone. You take the list it helps you build and do those things in Instagram, where you have the controls. It also means you can analyse a post whose account you do not manage, for example a partner’s or a client’s.
Comments that Instagram has already filtered or hidden for everyone are not served and are not in the file. You are looking at what the public can see, which is usually the part that matters for moderation.
Pattern 1: the same text from many accounts
Spam is often a template. Add a helper column with =COUNTIF($E$2:$E$5000, E2), where E is comment, and filter for values of 3 or more. Sort by that count. Read the top results: a repeated “🔥” is normal; a repeated sentence with a link or a promise of money, from different usernames, is a template. Note that COUNTIF is not case-sensitive and treats * and ? as wildcards, so a comment containing those characters may match more than you expect.
The unique commenters and most active commenters in the stats panel give you a first read before you open the file.
Pattern 2: links, handles and keywords
Use the search box to find comments containing a word, then export just those rows. In a spreadsheet, the equivalent flag is:
=IF(OR(ISNUMBER(SEARCH("http", E2)), ISNUMBER(SEARCH(".com", E2)), ISNUMBER(SEARCH("dm me", E2))), "check", "")
Replace the terms with the ones you see in your own spam. Many spam comments contain a handle to message or a pitch such as “earn from home”. The filter for comments with @mentions is also useful, since spam often tags another account to push people to it. See the mentions guide for ranking tagged accounts, and the hashtags guide for unusual strings of tags.
Pattern 3: repeat accounts
Count comments per commenter with =COUNTIF($D$2:$D$5000, D2) using user_id (column D), which stays the same if an account changes its username. Filter for high counts and read what those accounts wrote. A very active account is not automatically a problem: your best fan may sit at the top. What matters is what they say. Ten replies in one argument is a different thing from ten copies of the same ad.
For a quick check on one account, click its name in the results to see all its comments, or use the most active commenters list.
Pattern 4: bursts
Automated posting often arrives in clusters. Sort by posted_at_utc and look for runs of similar comments seconds apart. A helper column that measures the gap to the previous row, once sorted oldest first, is =VALUE(F3)-VALUE(F2), formatted as a time; a run of near-zero gaps is a cluster. Timing alone proves nothing, because a post that gets shared can bring a real burst. Combine it with the text pattern.
Reply threads where it gets heated
Arguments live in reply threads. Group each thread (how to rebuild threads) and count replies per parent comment with =COUNTIF(I:I, B2). The comments with the most replies are where to read first: that is where moderation decisions are usually needed.
A short moderation checklist
- Export the post, with up to 200 comments free.
- Flag repeated text, links and unusual tags with the formulas above.
- Read the flagged rows. Do not act on a flag alone.
- Make a list of usernames and copy them to a note.
- In Instagram, remove comments, restrict or block accounts, or report them. Use the app’s Hidden Words setting for terms you see repeatedly, so future spam is filtered before anyone sees it.
- Export again a few days later to check whether the pattern stopped. The file is a snapshot, so each check is a new export.
FAQ
Can IGComments delete or hide spam comments?
No. It reads public comments without logging in to your account. You find the patterns, then remove or restrict accounts in Instagram.
Why count by user_id?
It stays the same when an account renames itself, so an account that changes its username still counts as one.
Will comments Instagram already filtered show up?
No. Comments that Instagram filters or hides from everyone are not served and cannot be exported.
Can I check a post on an account I do not manage?
Yes, if the post is public. You only need the link.
How do I find the comment someone mentioned in a complaint?
Search for a word or the username in the results, then export only the matching rows if you need a record.