# How to get comments into Google Sheets

https://aicommentexporter.com/comments-to-google-sheets/

Paste the post link below, download the comments as CSV (the first 500 free with "Download these (CSV)", or all of them with "Export all comments"), then in Google Sheets choose File → Import → Upload and pick the file. Emoji and accents come through, each comment is a row, and replies carry the id of the comment they answer.

Tool on the page: [TikTok Comment Exporter](https://aicommentexporter.com/tiktok-comment-exporter/)

## Step by step

1. **Get the file**: Paste the link, then "Download these (CSV)" for the loaded comments or "Export all comments" for every comment and reply (Excel, CSV or JSON).
2. **Import it**: In Google Sheets: File → Import → Upload, choose the file, then "Insert new sheet" or "Replace spreadsheet". Excel files import the same way.
3. **Work with it**: Freeze the header row, filter by likes or date, or add a column to tag each comment.

## Things that are already handled

- The CSV is UTF-8 with a byte-order mark, so emoji and non-English letters show correctly.
- A comment that starts with =, +, - or @ gets a ' in front, so Sheets shows it as text and never runs it as a formula.
- Google Sheets holds up to 20 million cells (Google's help page, read November 14, 2026). With the 15 columns of an export, that's over 1,300,000 rows in one sheet.

## Columns in the file

- platform: youtube, tiktok, instagram, twitter or reddit
- post_url: The video or post the comment is on
- comment_id: The platform's id for the comment
- parent_id: For a reply: the id of the comment it answers. Empty for a top-level comment
- type: comment or reply
- author: The commenter's handle or name (@name, or u/name on Reddit)
- author_url: Link to the commenter's channel or profile
- text: The comment as plain text, emoji included
- likes: Likes at the time of the export (score on Reddit)
- reply_count: Replies under a top-level comment, as the platform counts them
- published_at: When it was posted (UTC, ISO 8601)
- edited_at: When it was last edited, if it was (YouTube, Reddit)
- language: The comment's language as the platform tags it (TikTok, X)
- buying_intent: yes when TikTok flags the comment as purchase intent (TikTok)
- comment_url: A link that opens this comment (its video on TikTok)

## Questions

**Can it go straight into Sheets without a file?** Not directly. Download, then import; it takes a few seconds.

**Which is better, CSV or Excel?** Same columns. CSV is the safest for Sheets and other tools; Excel opens with a double click on a computer.

Updated 2026-11-14.

---

AI Comment Exporter (https://aicommentexporter.com/). Prices: https://aicommentexporter.com/pricing/. Every page: https://aicommentexporter.com/llms.txt. Not affiliated with YouTube, Google, TikTok, Instagram, Meta, X or Reddit.