How to Export TikTok Comments to CSV, Excel, or JSON

You can export TikTok comments by pasting a post URL into a comment exporter such as ZocialComment and downloading the results as CSV, Excel, or JSON — no signup or API keys required, according to the site. This works for anyone who needs comment data for reporting, research, or sentiment analysis, and the same tool also covers Instagram, YouTube, Reddit, Facebook, Threads, Lemon8, and Google Reviews if you later need other platforms.

What you need before you start

• A public TikTok post URL (the video whose comments you want).
• A browser to open the exporter.
• A destination for the file: a spreadsheet app for CSV/Excel, or a data pipeline/script for JSON.

The site states there is no signup and no API keys for the core export flow. A Chrome extension option does require signing in once, per the page.

Step-by-step: export TikTok comments

1. Copy the TikTok post URL. Open the video on TikTok and copy its link.
2. Paste the URL into the exporter. The tool accepts a post URL as the input.
3. Run the export. The tool collects the comments and prepares a download.
4. Choose your format. Pick CSV, Excel, or JSON depending on what you'll do next.
5. Download and open the file. Load it into your spreadsheet or analysis tool.

Expected result: a file containing the post's comments that you can open, sort, or feed into analysis software.

Choosing the right format

A reviewer quoted on the site (Jake Morrison, UGC Researcher) said the bulk export and JSON format made a data pipeline easier for a thesis involving 200+ TikTok videos — useful if you're handling many posts rather than one.

Clean mode vs Raw mode

The site highlights two output modes:

• Clean mode — trimmed output suited to client reports and readability.
• Raw mode — the fuller API payload, useful when you need every field for sentiment analysis or custom processing.

A quoted user (Chloe Nguyen, influencer marketing lead) described using Clean for client reports and Raw for sentiment analysis. Pick Clean when a human will read the file; pick Raw when a machine will parse it.

Exporting directly from the post (Chrome extension)

If you'd rather not leave the page, the site offers a Chrome extension: sign in once, then export any TikTok, Instagram, YouTube, Reddit, or Facebook post to CSV/JSON without switching tabs. This is the faster route if you export frequently; the paste-a-URL flow is better if you don't want to install anything.

Exporting inside Claude or ChatGPT (MCP)

The site also describes an MCP integration that connects the exporter to Claude or ChatGPT, so you can ask the assistant to export comments and summarize them. The page states this works on exports up to 100,000 comments. Use this if your goal is analysis, not just a file — for example, asking what people are repeatedly asking in the comments.

Common issues and how to handle them

• Missing comments. Very large threads or private/restricted posts may not return everything. If a post is not public, the exporter can't reach it.
• Format errors on open. If a CSV looks garbled in a spreadsheet, check the delimiter/encoding settings on import rather than assuming the file is broken.
• Too much data to read. For big exports, use Raw mode plus a script or the MCP/AI route instead of scrolling a spreadsheet.
• Repeated manual work. If you export often, the extension removes the copy-paste step.

Cost and access

The site references a free tier and a paid pass (a quoted user mentions a $14 pass for 12,000 comments), plus a separate pricing page. Treat these as reported figures from the page rather than fixed current prices — check the pricing page for what applies now. The core flow is described as no-signup and no-API-key, but the extension and MCP options involve signing in or connecting an account.