How to Export Social Media Comments to CSV, Excel, or JSON

You can export comments from TikTok, Instagram, YouTube, Reddit, Facebook, Threads, Lemon8, and Google Reviews by pasting a post URL into a comment exporter and downloading the results as CSV, Excel, or JSON — no signup or API keys required. This works for marketers, agencies, and researchers who need comment data in a spreadsheet or data pipeline. The main conditions: the post must be publicly accessible, and very large exports (the site notes support up to 100,000 comments per export) may take longer to process.

Step-by-step: exporting comments from a post URL

1. Copy the post URL. Open the post on its native platform (for example, a TikTok video or an Instagram reel) and copy the link.
2. Paste the URL into the exporter. The tool accepts URLs from TikTok, Instagram, YouTube, Reddit, Facebook, Threads, Lemon8, and Google Reviews.
3. Choose your output format. Select CSV for spreadsheet tools, Excel for direct report use, or JSON if you're feeding a data pipeline or sentiment analysis script.
4. Download the file. The export runs and delivers a file containing the comments.

The expected result is a clean file you can open in Excel, Google Sheets, or a script. According to the site, the CSV export is "clean and ready for our reporting tools," which matters if you're piping data into a BI tool rather than reading it by hand.

Clean mode vs. Raw mode

The exporter offers two output modes, and picking the right one depends on your goal:

A social media manager quoted on the site uses Clean for client reports and Raw when running sentiment analysis — a reasonable split if you're doing both.

Exporting directly from the post page (Chrome extension)

If you'd rather not copy URLs one at a time, the Chrome extension lets you export from the post itself. Sign in once, then export any TikTok, Instagram, YouTube, Reddit, or Facebook post to CSV or JSON without leaving the page. This is the faster route when you're working through many posts in a browsing session.

Analyzing comments with AI (Claude & ChatGPT via MCP)

The exporter can connect to Claude or ChatGPT through MCP (Model Context Protocol). After a one-time setup, you can ask the assistant to export comments from a URL and analyze them in the same conversation — for example, "export the comments from this TikTok and tell me what people are asking." This works on exports up to 100,000 comments and removes the copy-paste step between downloading a CSV and analyzing it.

Common export issues and how to handle them

• Missing comments. If a post's comments aren't all appearing, check whether the post is public and whether comments are enabled. Private or restricted posts won't export fully.
• Format errors when opening CSV in Excel. CSV files with commas inside comment text can shift columns. Import the file through Excel's "From Text/CSV" option and set the delimiter explicitly rather than double-clicking the file.
• Large exports timing out. Exports near the 100,000-comment ceiling take longer. If you're working with many posts, batch them rather than running one massive job.
• Wrong mode for your task. If your sentiment tool expects raw fields, Clean mode will strip what you need. Switch to Raw before re-exporting.

What it costs and who it's for

The site references a free tier for testing and a $14 pass mentioned by one user, who exported 12,000 comments from campaign videos. Pricing details are listed on the site's pricing page, so check there for current tiers rather than assuming the $14 figure still applies. The tool is positioned for marketers, agencies, and researchers — one user cited bulk export and JSON format for a thesis on online discourse across 200+ TikTok videos, which is the kind of workload where a URL-paste exporter beats manual copying.