SocialHolmes

TikTok comment exporter

Paste a JSON response and get a CSV back. It never leaves the page — there is no upload here and nothing posts.

Free, no account, and nothing you type here leaves your browser.

Paste a response to begin.

Everything happens in this page. There is no form and no request — you can turn off your network connection and it still works.

Getting TikTok comments into a spreadsheet

Comment data arrives as JSON, and JSON is not what anybody wants to read it in. This takes a response, finds the array of rows in it whatever the collection is called, works out every column any row has, and writes a CSV.

Two details that break most conversions are handled here. The file is written with a byte-order mark, so a spreadsheet opening it by double-click reads it as UTF-8 rather than as the local codepage — on TikTok, where most comments are not in Latin script, without that mark you get mojibake. And columns are the union of every row's keys rather than the first row's, so a thread where only some comments carry a reply count keeps that column.

If you do not have a response to paste yet, the comments endpoint is what produces one. It returns a page of comments for any public video, with the author, the text, the timestamp and the like count already pulled out.

Does anything I paste get uploaded?
No. The conversion runs entirely in your browser — there is no form on the page and no request is made. You can disconnect from the network and it will still work.
What responses does it accept?
Any JSON with an array of objects in it. It looks for the first array of objects in the document, so a response wrapped in a `comments` or `videos` key works without you unwrapping it first.
Why does my spreadsheet show strange characters?
It should not — the file is written with a UTF-8 byte-order mark precisely to stop that. If it still happens, your spreadsheet has an import encoding set explicitly; choose UTF-8 in its import dialog.

Doing this at volume?

These are calculators. The API behind them returns TikTok profiles, videos, comments, followers, sounds and hashtags as typed JSON — billed per result delivered, from $0.50 per thousand, with no subscription. New accounts get free credits to try it.