# Export TikTok comments to CSV

CSV is the default for analysts. This how-to is the long-tail version of our TikTok exporter: exact steps, columns you get, and how to open the file in Excel or Sheets without mangling usernames.

## Steps

1. Copy the public TikTok video URL. 2. Open CommentHunter and paste it. 3. Set a comment limit. 4. Toggle include replies if you need threads. 5. Export CSV. 6. Open with UTF-8 so @handles stay intact.

## Columns

Typical fields include name, username, date, likes, comment text, user id, reply-to, and comment URL. Exact columns can expand as providers add metadata.

## FAQ

### Can I open TikTok comment CSV in Excel?

Yes. Use UTF-8. Or export Excel (.xlsx) directly from CommentHunter to skip encoding issues.

## Next step

[Export to CSV](/tiktok-comment-exporter)