CommentsToSheets

=COMMENTS(link)

From a post link to a working sheet.

Paste a link from Instagram, TikTok, YouTube or Facebook. Get every comment and reply as an Excel workbook with the commenters, mentions and days already counted, or send it straight into Google Sheets.

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

From link to sheet in three cells

  1. A1

    Copy the link

    On the post, Reel, video or Short tap Share, then Copy link.

  2. B1

    Paste it in the fx bar

    The public comments and replies are read. You never log in.

  3. C1

    Open it in your sheet

    Download the workbook, Copy for Sheets, or pull it in with =IMPORTDATA.

Four networks, one sheet

Every file has the same columns plus a platform column, so exports from different networks stack in one sheet. Free limits are per post.

What only a spreadsheet tool would do

Getting comments out is easy. Getting them into a sheet that already answers your questions is the part this site is for.

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

Copy for Sheets

Copy, paste, done

One button puts the rows you are looking at on the clipboard as tab-separated text with headers. Paste into Google Sheets or Excel and it lands one value per cell, up to 20,000 rows at a time.

  • Respects your filters: only replies, one row per person, a search
  • Multi-line comments stay in one cell
  • Comments that start with = + - or @ stay text, never formulas
  • Long ids stay exact instead of being rounded
How Copy for Sheets works

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 columns you get

The same columns on every network, in every format. Replies are rows of their own.

A #B comment_idC usernameD user_idE commentF posted_at_utcG likesH is_replyI reply_to_comment_idJ reply_to_usernameK mentionsL hashtagsM platform

Pricing

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

ABC
1PlanComments per postPrice
2 Free · Instagram, YouTubeup to 1,000 comments$0.00
3 Free · TikTok, Facebookup to 300 comments$0.00
4Export Passup to 15,000 comments$4.99
5Export Pass 50kup to 50,000 comments$9.99
6Big Export Passup to 200,000 comments$14.99

One payment for one post, on any network. Bigger posts show the free comments as a labelled preview first.

Questions

A1What does CommentsToSheets do?

You paste the link to a public Instagram post or Reel, TikTok video, YouTube video or Short, or Facebook Page post. It reads the public comments and replies and gives you a spreadsheet: an Excel workbook, CSV or JSON, plus Copy for Sheets and a live link for Google Sheets.

A2How much is free?

Per post: Instagram and YouTube up to 1,000 comments, TikTok and Facebook up to 300. The limit is a number of comments, not a number of seconds, so a free file is a whole file.

A3Why is TikTok and Facebook free up to a smaller number?

Reading them costs about three times as much per comment. The passes above the free limit are the same on every network.

A4Does it read replies?

Yes, on every network, each reply on its own row with the comment it answers. On a free TikTok or Facebook export a very long set of reply threads can be cut short; the page says how many replies were not read.

A5How do I get it into Google Sheets?

Three ways: upload the Excel workbook, press Copy for Sheets and paste into A1, or put the live link in =IMPORTDATA() so the sheet fetches it itself.

A6Do I log in to anything?

No. No login to Instagram, TikTok, YouTube or Facebook, no account here and no browser extension. Only public posts work.

A7Why is my row count a little lower than the number on the post?

Each network counts comments it hides from everyone: spam-filtered, hidden words, restricted accounts and deleted comments. Nobody can read those.

A8What does a big post cost?

One payment per post: $4.99 up to 15,000, $9.99 up to 50,000, $14.99 up to 200,000 comments. No subscription.

Spreadsheet guides