The six sheets
| Sheet | One row per | Columns |
| Comments | comment or reply | #, comment_id, username, user_id, comment, posted_at_utc, likes, is_reply, reply_to_comment_id, reply_to_username, mentions, hashtags, platform |
| Commenters | person | username, total, comments, replies, likes_received, first_comment_utc, last_comment_utc |
| Mentions | tagged account | tagged_account, times_tagged, tagged_by_people |
| Per day | UTC day | day_utc, comments_and_replies, replies, people |
| Hashtags | hashtag | hashtag, uses, used_by_people |
| Read me | fact | post link, network, when it was read, comments read, the count the post shows, what every sheet and column means |
Built to be worked on
- Header rows are frozen and have filters on, so sorting by likes or filtering to replies is one click.
posted_at_utc and the first and last comment times are real dates, so they sort and chart correctly.
- Instagram ids are 17 to 19 digits; they are kept as text, so none is rounded.
- Columns are sized to fit and comments stay on one line until you widen them.
Filter on the export page first (only replies, one row per person, a search) and the workbook holds exactly those rows, with the summary sheets counting those rows only. The Read me sheet says which filter was used.
Where the numbers come from
The summary sheets are counted from the same rows as the Comments sheet. A comment that tags someone twice counts once for that person in Mentions; tagged_by_people counts different commenters. The Commenters sheet adds up the likes on each person's comments. Days are UTC calendar days.
Questions
Does it open in Google Sheets and Numbers?
Yes. Upload it to Google Sheets with File, Import, Upload, or open it in Numbers or LibreOffice. All six sheets come along.
Is the workbook free?
Yes, for every free export: Instagram and YouTube up to 1,000; TikTok and Facebook up to 300 comments per post.
Can I get only one of the sheets?
Yes. On the export page each sheet view (Commenters, Mentions, Per day, Hashtags) has its own CSV download and Copy for Sheets.