CommentCrateHow to analyze Instagram comments in a spreadsheet
A few formulas and one pivot table are enough to see who comments, what gets liked and when people write.
Start with the export
Export the post with CommentCrate as XLSX or CSV (see the export guide) and open it in Excel or Google Sheets. Each row is one comment with the columns id, parentId, author, text, likeCount, createdAt, hidden and postUrl. Keep in mind that the file holds what Instagram showed the page: hidden or filtered comments can be missing, so treat the numbers as a sample of the visible discussion.
Who comments the most
Select the data and insert a pivot table: put author in Rows and the count of id in Values, then sort the counts from largest to smallest. For one name, =COUNTIF(C:C, "username") gives the number of comments.
Which comments get the most likes
Sort the sheet by likeCount, largest first. The likes column is filled when Instagram provides it; empty cells mean the page did not show a number.
When people comment
The createdAt column is text in the form 2026-10-12T18:40:00.000Z (UTC), when Instagram provides it. In a spare column, =LEFT(F2, 10) returns the day and =MID(F2, 12, 2) the hour. Use either column as the Rows field of a pivot table to see the comment volume by day or by hour.
Common words and emoji
To count comments that mention a word, use a wildcard: =COUNTIF(D:D, "*love*"). The same works for an emoji, for example =COUNTIF(D:D, "*🔥*").
Replies and top-level comments
Rows with an empty parentId are top-level comments; the others are replies (replies are included with Pro). Filter on that column to look at them separately.
Use the results responsibly
Work with totals and patterns, not with people. The comments are other people's content and can contain personal data; do not use them to profile, harass or target individuals, and delete the file when you are done.