CommentsToSheets

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.

Free per post: Instagram and YouTube up to 1,000; TikTok and Facebook up to 300 comments · replies included · no login

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:

ColumnWhat it holdsExcel type
A #Position in the thread, starting at 1Number
B comment_idInstagram's ID for the commentText (so it is never rounded)
C usernameWho wrote itText
D user_idThe account's numeric ID, stable even if the username changesText
E commentThe full text, emoji includedText
F posted_at_utcDate and time in UTC, YYYY-MM-DD HH:MM:SSText
G likesLikes on the commentNumber
H is_replyyes or noText
I, J reply_to_comment_id, reply_to_usernameFor replies: the comment and person being answeredText
K mentionsEvery @handle in the comment, space separatedText
L hashtagsEvery #tag in the commentText

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

  1. Make it a table. Click any cell and press Ctrl+T (Cmd+T on a Mac). Filter arrows appear on every column and formulas fill down by themselves.
  2. Read long comments. Set column E to a width of about 60 and turn on Wrap Text.
  3. Hide replies when you only want entries. Filter is_reply to no.
  4. Turn the timestamp into a real date. In a new column, formatted as date and time:
    =DATEVALUE(LEFT(F2,10))+TIMEVALUE(MID(F2,12,8))
    For your own time zone add or subtract hours, for example -TIME(5,0,0) for UTC minus 5.
  5. Count the rows. =COUNTA(B:B)-1 gives 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

  1. Add a column day with =DATEVALUE(LEFT(F2,10)), formatted as a date.
  2. Select the table and choose Insert, PivotTable, New Worksheet.
  3. Drag day to Rows and comment_id to Values (it shows as Count of comment_id).
  4. 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.