CommentsToSheets

COUNTIF · pivot table · QUERY

Count Instagram comments per person

Who commented the most, who commented once, and who only replied to others. Export the comments, and one formula or one pivot table answers all three.

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

The one-formula answer

In the exported sheet, username is column C. Next to the data, in the first empty column, row 2:

=COUNTIF(C:C, C2)

Fill it down. Every row now shows how many comments its author left on the post. Sort by that column, largest first, and the most active commenters are at the top (each appears once per comment, so filter to unique usernames or use the pivot below for a clean list).

A clean list: pivot table (Excel or Sheets)

  1. Select the data. Excel: Insert, PivotTable. Sheets: Insert, Pivot table.
  2. Rows: username.
  3. Values: comment_id, summarised by Count (Excel) or COUNTA (Sheets).
  4. Sort the count descending.

Add is_reply to Columns and each person's total splits into top-level comments and replies. Someone with ten replies and no comment of their own is a conversation partner, not an entrant.

Google Sheets in one cell

=QUERY(A1:L, "select C, count(B) where C is not null group by C order by count(B) desc label count(B) 'comments'", 1)

Want only top-level comments? Add and H = 'no' after is not null. Want people with three or more? Wrap it: =FILTER(QUERY(...), INDEX(QUERY(...),,2)>=3), or simply sort and read down.

Excel 365: a live table with UNIQUE and COUNTIF

On a new sheet, in A2: =UNIQUE(Comments!C2:C5000). In B2: =COUNTIF(Comments!C:C, A2#). Both spill down automatically. Sort with =SORTBY(A2#, B2#, -1) if you want the list ordered without touching the source.

Make sure the counts are real

A per-person count is only as good as the list underneath it. If an export stopped after a fixed number of seconds, the people who commented later look like they never commented at all, and the people who commented early look more active than they were. Here a free export reads every comment and reply on posts with up to 1,000 comments, and the page shows comments read next to Instagram's count before you download. Check it in the sheet with =COUNTA(B:B)-1.

Go further with the counts

Questions

Should replies count?

Depends on the question. For engagement, yes. For a giveaway that says one comment per entry, usually only top-level comments count: filter is_reply to no first.

Is username or user_id better for counting?

Within one export they give the same answer. Across exports made weeks apart, user_id is safer because usernames can change.

Can the page show this without a spreadsheet?

Yes, the export page lists the most active commenters. The spreadsheet is for when you need the full table or want to combine it with other data.