Skip to content
Pickerify

How to Analyse Instagram Comments in a Spreadsheet

By the Pickerify team · Last updated 28 October 2026 · 8 min read

To analyse Instagram comments in a spreadsheet, export the post’s comments to CSV or Excel, then use a handful of formulas to count, filter and group them. You don’t need any special software: everything in this guide works in Microsoft Excel and Google Sheets.

Step 1: Export the comments and set up the sheet

  1. Export the post’s comments. Paste the post link into the Instagram comment export and download an Excel or CSV file. Posts with up to 1,000 comments are free.
  2. Open it in Excel or Google Sheets. In Google Sheets, use File → Import and choose the file.
  3. Turn on filters. Select the header row and turn on filters, so you can sort and narrow the list without formulas.

The formulas below assume this column layout, which matches the Pickerify export:

ColumnContains
Acomment_id
Bparent_id (empty for top-level comments)
Cusername
Dtext
Ecreated_at, for example 2026-10-21T18:04:11.000Z
Flike_count
Gmentions
Hhashtags
Iis_reply

If your file has a different layout, change the column letters in each formula. The examples use rows 2 to 1000; extend the range if your post has more comments. To measure your audience rather than conversations, filter column I to show only top-level comments (is_reply = FALSE) first.

Six analyses with formulas

1. How many different people commented?

The comment count includes people who commented several times. To count each person once:

=SUMPRODUCT((C2:C1000<>"")/COUNTIF(C2:C1000,C2:C1000&""))

2. Who commented the most?

In an empty column next to the data (for example J), count each person’s comments, fill it down, then sort that column from largest to smallest. A pivot table with username as rows and a count of comment_id as values gives the same result in one step.

=COUNTIF(C$2:C$1000,C2)

3. Which comments ask a question?

Mark every comment that contains a question mark with a 1, then filter or add up the column. Use FIND rather than SEARCH: in Excel, SEARCH treats “?” as a wildcard and would mark every comment.

=IF(ISNUMBER(FIND("?",D2)),1,0)

4. How many people tagged friends?

Count the @ signs in each comment, then filter for 1 or more.

=LEN(D2)-LEN(SUBSTITUTE(D2,"@",""))

5. When do people comment?

Pull out the day and the hour (in UTC) from the date column, then count comments per day or per hour with COUNTIF or a pivot table. Add or subtract your time-zone offset to see local hours.

Day:  =LEFT(E2,10)
Hour: =VALUE(MID(E2,12,2))

6. Which words come up most?

Count how many comments mention a word, in any letter case, and repeat for the words that matter to you, such as “shipping”, “size” or a product name.

=COUNTIF(D2:D1000,"*price*")

Turning the numbers into a report

A one-page summary is usually enough for a client or your own records:

MetricWhere it comes from
Total comments and repliesNumber of rows
Different people who commentedAnalysis 1
Most active commentersAnalysis 2, top 5
Questions askedAnalysis 3, total
Comments tagging friendsAnalysis 4, count of 1 or more
Busiest day and hourAnalysis 5
Most common topicsAnalysis 6, top 3 words

Then add two or three sentences on what the numbers mean, and quote two or three real comments that show the mood; they often say more than a chart.

Handle the data with care. Comments are public, but usernames are still personal data. Use the file for your report, don’t add commenters to mailing lists without their consent, and delete old exports when you no longer need them.

FAQ

Can I analyse Instagram comments without exporting them?

For a quick look, yes: the Instagram comment viewer lets you search and filter comments in your browser. For counting and grouping, a spreadsheet is easier.

Do these formulas work in Google Sheets?

Yes. The formulas in this guide work in both Google Sheets and Microsoft Excel.

Can I see the sentiment of comments?

Not with a single formula. A simple approach is to count words that signal mood, such as “love” or “disappointed”, with analysis 6, then read a sample of comments to check the result.

Can I compare several posts?

Yes. Export each post, add a column with the post's name, and paste the files into one sheet. Then use a pivot table with the post name as columns.

Why does the export have fewer comments than Instagram shows?

Instagram's count includes deleted, hidden and spam-filtered comments, which aren't public and can't be exported.

Get your comments into a spreadsheet

Paste an Instagram post link and download the public comments and replies as CSV, Excel or JSON. Free for posts with up to 1,000 comments.

Export comments