How to check an Instagram comment export is complete
An export that quietly stopped halfway looks exactly like a complete one until you count. These five checks work on a file from any tool, take about a minute, and need nothing but the spreadsheet and the post.
Updated Nov 17, 2026 · 5 min read
1. Rows versus Instagram's count
Excel: =COUNTA(B:B)-1 (minus the header). Google Sheets: =COUNTA(B2:B). Compare with the number on the post.
- 95 to 100 percent: complete. The small gap is comments Instagram hides from everyone.
- 80 to 95 percent: probably complete on a post with a lot of spam or a hidden-words filter; worth the other checks.
- Well under that: partial. Something stopped reading early.
2. Are there replies?
=COUNTIF(H:H,"yes") on the is_reply column. On a post with a few hundred comments, replies are usually a real share of the total. Zero replies on a busy post means the tool did not read them; Instagram's count includes them, so the file is short by that much.
3. Does the date span match the post?
Sort by posted_at_utc. The earliest comment should be within minutes of the post going up, and the latest close to when you exported. A file whose comments all fall in one narrow window of a long-running post was cut off.
4. Run it twice
Export the same post again a few minutes later and count the rows. A complete reader returns the same number (plus any genuinely new comments). A reader limited by time can return a different number each run, because it depends on how fast the source answered.
5. Spot-check the middle
Open the post, scroll to the middle of the comments, and pick three. Search for each username in the file (Ctrl+F). All three should be there. The middle is where partial exports fail, since the first comments are always read.
What this site does for you
The export page shows comments read next to Instagram's count before you download, so check 1 is done for you. Free exports read every comment and reply on posts with up to 1,000 comments, with no timer; on bigger posts the free part is labelled preview on the page and in the file name. If Instagram serves far fewer comments than it reports, the page says so instead of presenting the file as complete. The guide on why the two counts differ covers the normal gap.
FAQ
My file has more rows than Instagram's count. Is that wrong?
No. Instagram's displayed count can lag behind, or leave out some replies. A few extra rows is normal.
What if the tool does not mark replies?
Then check 2 cannot be done from the file. Look for usernames you know replied on the post; if they are missing, replies were not read.