CommentsToSheets

Ctrl+C · Ctrl+V

Copy comments straight into a sheet

For when downloading a file is one step too many. Filter the comments, press Copy for Sheets, click A1, paste.

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

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

What gets copied

  • The view you are on: Comments, Commenters, Mentions, Per day or Hashtags.
  • With the filters you set: only replies, only top-level comments, one row per person, or a search.
  • A header row first, then one row per comment, up to 20,000 rows. For more, download the workbook or CSV.
  • A preview of a big post copies the preview rows only, exactly like the download.

Why the paste lands cleanly

The text is tab-separated, which is what Google Sheets and Excel expect on the clipboard. Three things that usually go wrong are handled:

  • A comment with line breaks is quoted, so it stays in one cell instead of spilling into the rows below.
  • A comment that starts with =, +, - or @ gets a leading apostrophe, so the sheet keeps it as text and never runs it as a formula. The apostrophe does not show in the cell.
  • Ids with 16 or more digits get the same apostrophe, so the sheet does not round them.

Questions

The button did nothing in my browser.

Some browsers block the clipboard for pages that are not in focus. Click the page once and press it again, or download the CSV.

Does it work on a phone?

Yes. Copy on the phone and paste into the Google Sheets app; long-press a cell and choose Paste.