CommentsToSheets

=IMPORTDATA("…")

Pull comments into Google Sheets with one formula

No download, no upload. Make a live link on the export page, paste the formula into cell A1, and Google Sheets fetches every comment and reply itself.

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

Set it up

  1. Export the post here and open its export page.
  2. Press Make a live link, then Copy formula. It looks like this:
=IMPORTDATA("https://commentstosheets.com/s/7Gk2…csv")
  1. Click A1 in a Google Sheet and paste. Row 1 is the header, every comment and reply is a row below it.

Google Sheets refreshes IMPORTDATA on its own schedule, roughly every hour while the sheet is open. Very large exports can be more than IMPORTDATA will load; for those, upload the Excel workbook instead.

Build on it in another tab

Keep the imported tab untouched and do the work in a second tab, so a refresh never overwrites your formulas:

=SORT(UNIQUE(Import!C2:C))
=COUNTIF(Import!C:C, A2)
=QUERY(Import!A:M, "select C, count(A) where A is not null group by C order by count(A) desc", 1)

The first lists every commenter once, the second counts their comments, the third does both in one go. The workbook's Commenters sheet has the same answer ready if you would rather download.

Who can open the link

  • Anyone with the address can read the rows, the same as anyone with the export page link. It needs no login so that Google's servers can fetch it.
  • It serves exactly what the export holds. A preview of a big post stays a preview until the post is unlocked.
  • Press New link and the old address stops working at once. Sheets using it stop updating.
  • It ends when the export is deleted, after 30 days (30 for YouTube). It is never listed or indexed.

Questions

Does the live link show new comments posted later?

No. It serves the export as it was read. To pick up newer comments, export the post again and use the new link.

Why does Google Sheets show #N/A or "Could not fetch url"?

Usually the link was replaced with a new one or the export has expired. Make a new link on the export page and paste the new formula.

Do long ids stay exact?

IMPORTDATA may turn very long ids into rounded numbers. If you need comment_id or user_id exactly, use Copy for Sheets or the Excel workbook, which keep them as text.