Excel XLSX · every comment and reply
Export Instagram comments to Excel
Paste a post or Reel link and download an .xlsx file with one comment per row, replies included. Free for posts with up to 1,000 comments, and the page tells you how many comments were read before you open Excel.
What the workbook looks like
One sheet, one header row, one comment per row. Replies are rows too, so nothing is hidden inside a cell. The columns are:
| Column | What it holds | Excel type |
|---|---|---|
A # | Position in the thread, starting at 1 | Number |
B comment_id | Instagram's ID for the comment | Text (so it is never rounded) |
C username | Who wrote it | Text |
D user_id | The account's numeric ID, stable even if the username changes | Text |
E comment | The full text, emoji included | Text |
F posted_at_utc | Date and time in UTC, YYYY-MM-DD HH:MM:SS | Text |
G likes | Likes on the comment | Number |
H is_reply | yes or no | Text |
I, J reply_to_comment_id, reply_to_username | For replies: the comment and person being answered | Text |
K mentions | Every @handle in the comment, space separated | Text |
L hashtags | Every #tag in the comment | Text |
Because the IDs are stored as text, Excel will not turn 17984512345678901 into 1.79845E+16, which is what happens when a CSV with long numbers is double-clicked.
First five minutes in Excel
- Make it a table. Click any cell and press
Ctrl+T(Cmd+Ton a Mac). Filter arrows appear on every column and formulas fill down by themselves. - Read long comments. Set column E to a width of about 60 and turn on Wrap Text.
- Hide replies when you only want entries. Filter
is_replytono. - Turn the timestamp into a real date. In a new column, formatted as date and time:
For your own time zone add or subtract hours, for example=DATEVALUE(LEFT(F2,10))+TIMEVALUE(MID(F2,12,8))-TIME(5,0,0)for UTC minus 5. - Count the rows.
=COUNTA(B:B)-1gives the number of comments in the file. It should equal the comments read shown on the export page.
Formulas people actually use on comment exports
How many times does each person appear? In a new column next to the data: =COUNTIF(C:C,C2). Sort that column largest to smallest.
How many different people commented? In Excel 365: =ROWS(UNIQUE(C2:C5000)) (set the range to your last row). In older Excel, copy column C to a new sheet and use Data, Remove Duplicates.
How many comments tag at least two friends? Add a helper column with =IF(K2="",0,LEN(K2)-LEN(SUBSTITUTE(K2,"@",""))), which counts the @ signs in mentions, then =COUNTIF(M:M,">=2").
Which comments mention a word? =COUNTIF(E:E,"*price*") counts them; a Text Filter on column E set to Contains shows them.
The comments per person and duplicate commenters pages go further with pivot tables and conditional formatting.
A pivot table of comments per day
- Add a column
daywith=DATEVALUE(LEFT(F2,10)), formatted as a date. - Select the table and choose Insert, PivotTable, New Worksheet.
- Drag
dayto Rows andcomment_idto Values (it shows as Count of comment_id). - Insert a line chart from the pivot to see when the conversation peaked.
Put is_reply in Columns to split top-level comments from replies on each day.
Free, and complete
Any public post with up to 1,000 comments exports to Excel for free, every comment and reply included. On a bigger post you see the first 1,000 as a preview, and the file name says preview, so it is never mistaken for the whole thread. A one-time pass reads everything: $4.99 up to 15,000, $9.99 up to 50,000, $14.99 up to 200,000 comments. See pricing.
Questions
Do I need an Excel add-in?
No. The .xlsx file is built for you and opens like any workbook in Excel for Windows, Mac and the web, and in Numbers and LibreOffice.
Are replies in a separate sheet?
No, everything is on one sheet. Replies have is_reply set to yes and show the comment and username they answer, so a filter shows or hides them.
Will Excel round the comment IDs?
Not in the XLSX file: the IDs are stored as text. If you use the CSV instead, import it with Data, From Text/CSV and set the ID columns to Text.
Is there a row limit?
An Excel sheet holds 1,048,576 rows, more than the largest export, so every comment fits on one sheet.
Can I get one row per person?
Yes. Tick one comment per person on the export page before pressing Excel, and the file holds each commenter once.