IGComments

Google Sheets · no add-on

Get Instagram comments into Google Sheets

Export the comments from a public Instagram post or Reel, import the file into Google Sheets, and share one link with your team. No add-on, no Apps Script, no Instagram login. Below: the import steps that keep IDs and emoji intact, and the formulas worth knowing. Free up to 200 comments.

Free up to 200 comments · no Instagram login · replies included · CSV, Excel & JSON

Step by step: from Instagram post to Sheet

  1. Fetch the comments. Copy the post or Reel link, paste it above and press Get comments.
  2. Download the CSV. (Filter first if you only want some rows — the download matches what’s on screen.)
  3. Open Google Sheets and create a blank spreadsheet, or open the one you want to add to.
  4. Choose File → Import → Upload and select the file you downloaded.
  5. Pick an import location — Insert new sheet(s) is the safest — and leave the separator on Detect automatically.
  6. Untick “Convert text to numbers, dates, and formulas”. This one matters; see below.
  7. Press Import data. Freeze the header row with View → Freeze → 1 row.

Alternative: download the Excel (XLSX) file, upload it to Google Drive and open it with Google Sheets. The IDs are already stored as text in the XLSX, so there is nothing to untick.

Why to untick “convert text to numbers”

Instagram’s comment_id and user_id values are up to 17–19 digits long. Google Sheets stores numbers with about 15 digits of precision, so if it converts them, the last digits silently turn into zeros and two different comments can end up with the same ID. Leaving the conversion off keeps every column as the exact text in the file.

The trade-off is that likes also comes in as text. If you want to sum or sort it numerically, select column G and choose Format → Number → Number, or wrap it in VALUE() in formulas. Emoji and accented characters are fine either way: the CSV is UTF-8 and Sheets reads it correctly.

Formulas that answer real questions

With the default column order (A #, B comment_id, C username, E comment, F posted_at_utc, G likes, H is_reply), these work as written:

How many times did each person comment? Add a column next to the data:

=COUNTIF(C:C, C2)

How many different people commented?

=COUNTUNIQUE(C2:C)

A list of everyone who commented, once each:

=UNIQUE(FILTER(C2:C, C2:C<>""))

Top ten commenters, in a new tab:

=QUERY(Comments!A:L, "select C, count(B) where C is not null group by C order by count(B) desc limit 10", 1)

Every comment mentioning price, shipping or a discount:

=FILTER(C2:E, REGEXMATCH(LOWER(E2:E), "price|how much|shipping|discount|code"))

Flag comments that contain a keyword (handy for “comment YES to enter” posts):

=REGEXMATCH(LOWER(E2), "\byes\b")

Count replies:

=COUNTIF(H:H, "yes")

Replace Comments with whatever your imported sheet tab is called.

Working as a team in Sheets

The main reason to use Google Sheets over a local file is collaboration. A few patterns that work well with comment exports:

  • Triage columns. Add status and owner columns with data validation dropdowns (Data → Data validation) — “to answer”, “answered”, “ignore” — so a support or community team can split up the questions.
  • Filter views. Data → Create filter view lets each person filter the sheet without changing what everyone else sees.
  • Conditional formatting. Highlight rows where COUNTIF is above 1 to spot repeat commenters, or where REGEXMATCH finds a complaint keyword.
  • One tab per post. Import each post’s export into its own tab and build a summary tab with QUERY or COUNTUNIQUE across them.

Skip the spreadsheet for quick answers

If all you need is a number or a short list, you may not need Sheets at all. The results page shows free stats — total comments, unique and repeat commenters, replies, questions, the most active commenters, most-mentioned accounts, top hashtags, words and emoji, the most-liked comments and comments per day — on the comment analyzer. And comment search filters by word or @username before you export.

Cost

Free for posts with up to 200 comments. On bigger posts the first 200 are a free preview, and a one-time Export Pass unlocks the full file for Sheets: $4.99 up to 10,000 comments, $9.99 up to 30,000, $14.99 up to 100,000. No account, nothing renews. Pricing.

Frequently asked questions

Is there a Google Sheets add-on that pulls comments directly?

IGComments doesn’t offer an add-on. You export a CSV or XLSX and import it, which takes under a minute and needs no permissions on your Google account.

Will the sheet update when new comments are posted?

No. The import is a snapshot. To include newer comments, fetch the post again and import the new file into a fresh tab.

Why did my comment IDs end in 000 after importing?

Google Sheets converted them to numbers and lost precision. Re-import with “Convert text to numbers, dates, and formulas” unticked, or use the XLSX file.

Do emoji show correctly in Google Sheets?

Yes. The CSV is UTF-8 and the XLSX stores text natively, so emoji and non-Latin scripts display correctly.

Is there a size limit in Google Sheets?

Google Sheets allows about 10 million cells per spreadsheet. A comment export has 12 columns, so even the largest export fits.

Can I paste the comments instead of importing a file?

You can open the CSV, copy and paste, but importing is more reliable: it handles multi-line comments and quoting correctly.