CommentsToSheets

Duplicates · conditional formatting · COUNTIFS

Find duplicate commenters on an Instagram post

People who commented twice, the same text pasted ten times, accounts that tag the same friends over and over. Export the comments and a spreadsheet finds all of them in a minute.

Free per post: Instagram and YouTube up to 1,000; TikTok and Facebook up to 300 comments · replies included · no login

Highlight everyone who commented more than once

Excel: select column C (username), then Home, Conditional Formatting, Highlight Cells Rules, Duplicate Values. Every repeated username turns red.

Google Sheets: select C2:C, then Format, Conditional formatting, choose Custom formula is and enter:

=COUNTIF($C$2:$C, $C2)>1

Filter by colour (Excel) or sort by username (both) to see each person's comments together.

Find the same comment posted more than once

Same person, same text, is usually a copy-paste or a bot. In a helper column:

=COUNTIFS($C$2:$C$5000, C2, $E$2:$E$5000, E2)>1

TRUE marks every comment its author posted more than once word for word. For the same text from different people (a template someone shared), drop the username condition: =COUNTIF($E$2:$E$5000, E2)>1. COUNTIF treats * and ? in the text as wildcards; for comments full of those, use =SUMPRODUCT(--($E$2:$E$5000=E2))>1 instead.

Keep one row per person

  • Before downloading: tick one comment per person on the export page. The file holds each person's first comment only.
  • Excel: Data, Remove Duplicates, untick every column except username. Excel keeps the first row it meets, so sort by posted_at_utc first if you want each person's earliest comment.
  • Sheets: Data, Data cleanup, Remove duplicates, with only the username column ticked, or =UNIQUE(C2:C) for just the names.

Duplicates across two posts

Ran the same campaign on a post and a Reel? Export both, stack them on one sheet (paste the second file under the first, without its header), add a column saying which post each row came from, then use the duplicate rule on user_id. People who entered on both show up immediately; a pivot with user_id in Rows and the post column in Columns shows who entered where.

Why completeness matters here

Duplicate checks on a partial list miss duplicates: if the second comment of a repeat entrant was never read, the person looks clean. A free export here reads every comment and reply on posts up to 1,000 comments, and shows comments read next to Instagram's count so you know the list is whole before you judge anyone.

Questions

Are two accounts with similar names the same person?

Not necessarily, and the export cannot tell. It shows usernames and user IDs; two IDs are two accounts.

Do replies count as duplicates?

They are rows like any other. Filter is_reply to no first if only top-level comments matter.

Can I remove duplicates before downloading?

Yes, with the one comment per person option on the export page.