Frequently asked questions
What 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.
How 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.
Why 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.
Does 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.
How 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.
Do 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.
Why 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.
What 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.
Which columns are in the file?
#, comment_id, username, user_id, comment, posted_at_utc, likes, is_reply, reply_to_comment_id, reply_to_username, mentions, hashtags, platform. Replies sit on their own rows with is_reply set to yes and the comment they answer.
What is different on Facebook?
Facebook shows names, not handles. The username column holds the name plus four characters that tell two people with the same name apart. Only public Page posts work.
What is different on YouTube?
YouTube's terms allow stored comments for 30 days, so a YouTube export is deleted after 30 days. Download the file within that time.
How long is my export kept?
30 days at the same link (YouTube: 30), then it is deleted. Download it as often as you like until then.
Can someone ask to have their comments removed?
Yes. Email [email protected] with the username and we delete those comments from stored exports.
Refunds?
If an export fails or comes back clearly incomplete because of us, email [email protected] with the export link and we fix it or refund you.