Export Instagram comments to Excel

From Instagram post to Excel workbook

1. Copy the link to the post or Reel (Share → Copy link in the app, or the browser address bar on a computer).
2. Paste it above and press Get comments. No Instagram login, no extension, no add-in for Excel.
3. Press Excel. You get an .xlsx file named after the account and post, with a header row and one comment per row. Double-click it and you are working.

Prefer to narrow things down first? Search or filter on the results page — only questions, only replies, one comment per person, a date range — and the Excel file will contain exactly those rows.

XLSX or CSV: which should you pick?

	XLSX (Excel)	CSV
Opens with a double-click in Excel	Yes	Yes
Emoji and accents	Always correct	Correct — the file has a UTF-8 byte-order mark
Long comment and user IDs	Kept as text, never rounded	Excel may turn them into 1.8E+16 unless imported as text
Numbers (likes, row #)	Real numbers you can sum and sort	Converted by Excel on open
Works in other tools and scripts	Spreadsheet apps	Almost everything

If the file is going straight into Excel, choose XLSX. If it is going into another system — a CRM, a database, a Python script — the CSV export is the more universal format. Both have the same columns.

Excel tips once the comments are in

Turn it into a table. Click any cell and press Ctrl+T (Cmd+T on Mac). You get filter arrows on every column, banded rows, and formulas that extend automatically.

Sort and filter. Sort likes largest to smallest to find the comments people agreed with most. Filter is_reply to no to see only top-level comments, or use a Text Filter on comment with “Contains” to find a product name or keyword.

Wrap long comments. Select the comment column, set a width of about 60, and turn on Wrap Text so multi-line comments are readable without widening the sheet.

Count comments per person. Add a column with =COUNTIF([username],[@username]) in a table, or =COUNTIF(C:C,C2) on a plain range, to see how many times each commenter appears.

Local time. posted_at_utc is in UTC. To shift it, add a column such as =VALUE(F2)-TIME(5,0,0) for UTC−5 and format it as date and time.

Build a pivot table of top commenters

A pivot table answers “who comments the most?” in about thirty seconds:

1. Click inside the data and choose Insert → PivotTable, then New Worksheet.
2. Drag username into Rows.
3. Drag comment_id into Values; Excel will show “Count of comment_id”.
4. Sort the count column largest to smallest.

Add likes to Values as a Sum to see whose comments earned the most likes in total, or put is_reply in Columns to split each person’s top-level comments from their replies. Group posted_at_utc by day for a simple comments-per-day chart.

If you only need the answer and not the workbook, the free comment analyzer already shows the most active commenters, repeat commenters, top hashtags and comments per day — no spreadsheet required. There is also a step-by-step guide to finding who commented most.

When a CSV opens garbled in Excel

If you have exported comments to Excel with another tool and seen emoji replaced by strings like ðŸ˜, the file was UTF-8 without a byte-order mark and Excel guessed a legacy encoding. Our CSV includes the mark, so it opens correctly. If you ever need to open a CSV from elsewhere, use Data → From Text/CSV and pick 65001: Unicode (UTF-8) as the file origin. Or skip the issue and download XLSX, which has no encoding to guess.

For more detail, read the guide to exporting Instagram comments to Excel.

Free for most posts, one-time pass for big ones

Any post with up to 200 comments exports to Excel for free. On bigger posts the first 200 comments are a free preview, and a one-time Export Pass unlocks the full workbook — $4.99 up to 10,000 comments, $9.99 up to 30,000, $14.99 up to 100,000. No account, no subscription. See pricing.

Frequently asked questions

Do I need an Excel add-in or plugin?

No. The XLSX file is generated for you; Excel opens it like any other workbook. Nothing is installed in Excel or in your browser.

Does it work with Excel for Mac and Excel Online?

Yes. The XLSX and CSV files open in Excel for Windows, Excel for Mac, Excel on the web, and also in Numbers, LibreOffice and Google Sheets.

Why do emoji look broken when I open some CSV files in Excel?

Excel needs a byte-order mark to recognise UTF-8. Our CSV has one, so emoji display correctly. The XLSX download avoids encoding issues entirely.

Is there a row limit in Excel I should worry about?

Excel holds just over one million rows per sheet, far more than the largest export we offer, so every comment fits on a single sheet.

Are replies in a separate sheet?

No, everything is on one sheet. Replies have is_reply set to yes and show the username and comment ID they answer, so you can filter them in or out.

Can I get only unique commenters in the Excel file?

Yes. Turn on the one-comment-per-person filter on the results page before pressing Excel, and the file will contain one row per commenter.