How to import Instagram comments into Google Sheets
Getting comments into Sheets takes thirty seconds. Getting them in without rounded IDs, broken emoji or dates stuck as text takes knowing two settings. This guide covers both, then the five formulas most people need next.
Updated Nov 17, 2026 · 6 min read
Step 1: download the right file
Paste the post link on the home page. When the export is ready, check that comments read is close to Instagram's count, then press Excel. Posts with up to 1,000 comments are free and complete. Choose XLSX over CSV for Sheets: the IDs inside are stored as text and arrive exactly as they are.
Step 2: import
- Open the spreadsheet you want the comments in (or a blank one at sheets.new).
- File, Import, then the Upload tab, and drop in the file.
- Import location: Insert new sheet(s) keeps whatever is already there.
- Press Import data. Rename the new tab
Comments(double-click the tab). - View, Freeze, 1 row, so the header stays put while you scroll.
Using the CSV instead? On the import screen untick Convert text to numbers, dates, and formulas. With it ticked, Sheets turns 17984512345678901 into 17984512345678900, and you cannot get the real ID back.
Step 3: make the timestamp a date
posted_at_utc (column F) arrives as text like 2026-10-02 14:03:00. In M1 type posted_at, and in M2:
=ARRAYFORMULA(IF(F2:F="", "", DATEVALUE(LEFT(F2:F, 10)) + TIMEVALUE(MID(F2:F, 12, 8))))
Format column M as Format, Number, Date time. For your time zone, subtract hours inside the formula, for example - 5/24 for UTC minus 5.
Step 4: five starter formulas
| Question | Formula |
|---|---|
| How many comments? | =COUNTA(Comments!B2:B) |
| How many people? | =COUNTUNIQUE(Comments!C2:C) |
| Who, once each? | =UNIQUE(FILTER(Comments!C2:C, Comments!C2:C<>"")) |
| How many tag @yourbrand? | =COUNTIF(Comments!K2:K, "*@yourbrand*") |
| How many mention "price"? | =COUNTIF(Comments!E2:E, "*price*") |
Step 5: a pivot table by day
- Add a column
day:=ARRAYFORMULA(IF(F2:F="", "", LEFT(F2:F, 10))). - Insert, Pivot table, data range
Comments!A1:N, new sheet. - Rows:
day. Values:comment_id, summarise by COUNTA. - Select the pivot and Insert, Chart; pick a column chart.
Add is_reply under Columns to stack top-level comments and replies.
Sharing with a team
Share the sheet as Viewer or Commenter unless people need to edit, so nobody re-sorts the original data by accident. Keep an untouched copy of the imported tab; do your filtering on a duplicate. Commenters wrote in public, but a sheet of their names is still personal data: do not post it publicly, and delete it when the work is done.
FAQ
The emoji show as boxes. Why?
That is a font on your device, not the data. The text is intact; it displays correctly on a device with emoji fonts.
Can I refresh the sheet when new comments arrive?
An export is a snapshot. Make a new export and import it as a new tab; compare with =COUNTA to see how many arrived.