CommentsToSheets

Sheet1 … Sheet6

An Excel workbook, with the analysis already laid out

Most comment exports give you one long list. This one opens with the questions already answered: who commented most, who got tagged, when people commented, which hashtags they used.

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

Excel workbook

A workbook, not a list

The Excel download opens with six sheets already laid out, so the questions people ask about a post are answered before you write a formula.

  • Comments: every comment and reply, with real date cells
  • Commenters: one row per person with comments, replies, likes received, first and last time
  • Mentions: who was tagged, how often and by how many people
  • Per day and Hashtags, plus a Read me sheet with the counts and what every column means
  • Header rows frozen and filterable, columns sized to fit
What is in the workbook

Sheet views

Tabs for the questions you were going to ask

On the export page the table switches between Comments, Commenters, Mentions, Per day and Hashtags, each one ready to copy or download as its own CSV.

  • Commenters sorted by how much they said
  • Mentions with how many different people tagged each account
  • Per day for a quick chart of when people commented
Count comments per person

The six sheets

SheetOne row perColumns
Commentscomment or reply#, comment_id, username, user_id, comment, posted_at_utc, likes, is_reply, reply_to_comment_id, reply_to_username, mentions, hashtags, platform
Commenterspersonusername, total, comments, replies, likes_received, first_comment_utc, last_comment_utc
Mentionstagged accounttagged_account, times_tagged, tagged_by_people
Per dayUTC dayday_utc, comments_and_replies, replies, people
Hashtagshashtaghashtag, uses, used_by_people
Read mefactpost 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.