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.