CommentsToSheets

=STACK(instagram, tiktok, youtube, facebook)

Export comments from any platform to a spreadsheet

Paste a public post link from any of the four networks. The comments and replies come out with the same columns plus a platform column, so a campaign that ran everywhere ends up in one sheet.

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

Free limits per network

NetworkWhat it readsFree up toWorth knowing
InstagramPosts, Reels, carousels1,000Replies included
YouTubeVideos and Shorts1,000Deleted after 30 days (YouTube's terms)
TikTokPublic videos300Free reads take reply threads up to a limit
FacebookPublic Page posts300Commenters are names, not handles

The free limit differs because reading TikTok and Facebook costs about three times as much per comment. Above it, the passes are the same everywhere: $4.99 up to 15,000, $9.99 up to 50,000, $14.99 up to 200,000 comments, one payment per post.

One set of columns for every network

#, comment_id, username, user_id, comment, posted_at_utc, likes, is_reply, reply_to_comment_id, reply_to_username, mentions, hashtags, platform

Put several exports in one sheet and filter or pivot on platform. To count comments per network in Google Sheets:

=QUERY(A:M, "select M, count(A) where A is not null group by M label count(A) 'comments'", 1)

To find people who commented on more than one network under the same handle, put =COUNTIFS(C:C, C2) beside each row and sort by it. On Facebook the username is a name plus four characters, so it will not match a handle on another network.

What is the same everywhere

  • No login to any network, no account here, no extension.
  • The export page shows the comments read next to the count the network itself shows, before you download.
  • The Excel download is a six-sheet workbook; Copy for Sheets and the live =IMPORTDATA link work on every network.
  • Follows cannot be checked from comments on any network, and the files never pretend otherwise.

Questions

Which links work?

Public Instagram posts and Reels, TikTok videos (short links too), YouTube videos and Shorts, and public Facebook Page posts.

Can I combine exports from different networks?

Yes. Every file has the same columns and a platform column, so paste or import them one under another.

Is there a subscription?

No. Free up to the limit for each network, then one payment for one post.