TikTok has no built-in export, and most people who want comments in a spreadsheet actually want them in Excel specifically — not a raw CSV that opens as one messy column with broken emojis. This guide gets you from a TikTok URL to a clean, sortable Excel sheet in a few minutes, and fixes the three formatting problems that trip almost everyone up.
This matters because comment data is only useful once you can filter and pivot it. With TikTok reaching nearly 2 billion monthly active users, a single viral video can hold thousands of comments — unusable until they're in rows and columns you can work with.
The fastest path: export to CSV, open correctly in Excel
Almost every comment export tool produces a CSV. CSV opens natively in Excel — the trick is opening it correctly so Thai, Arabic, and emoji characters don't turn into garbage and every field lands in its own column.
- Copy the TikTok video URL (tap Share → Copy link in the app).
- Paste it into ZocialComment's free TikTok export and run the export — no signup, 200 comments per video on the free tier.
- Download the CSV. It contains roughly 45 columns: comment text, username, likes, reply count, timestamp, and more.
- Do not double-click the file. Open Excel first, then use Data → From Text/CSV, and in the import dialog set File Origin to 65001: Unicode (UTF-8) and Delimiter to Comma. Click Load.
- Save as .xlsx (File → Save As → Excel Workbook) so formatting, filters, and formulas persist.
That's it. The whole point of step 4 is the UTF-8 setting — skip it and you get the classic problems below.
Fixing the 3 problems everyone hits
| Problem | Cause | Fix |
|---|---|---|
Emojis and non-Latin text show as é or boxes | Excel opened the file as ANSI, not UTF-8 | Use Data → From Text/CSV and pick 65001: Unicode (UTF-8) — never double-click the CSV |
| Everything lands in column A | Excel used the wrong delimiter (common on non-US locales that default to semicolons) | Set Delimiter → Comma in the import wizard |
Long numeric IDs become 1.23E+17 | Excel auto-converts long numbers to scientific notation | In the import preview, set the user/comment ID column type to Text before loading |
What you can do once it's in Excel
- Sort by likes to surface the most-engaged comments instantly.
- AutoFilter (Ctrl+Shift+L) to isolate comments containing a keyword, hashtag, or @mention.
- PivotTable on the timestamp column to see when your audience comments most.
- COUNTIF / SEARCH formulas to quantify how often a product name or competitor appears.
- Conditional formatting to flag comments with buying-intent phrases ("where to buy", "price", "link").
Tools that export native .xlsx vs CSV
If you'd rather skip the import step entirely, some tools output an Excel file directly. Here's the honest landscape:
| Tool | Native Excel (.xlsx)? | Notes |
|---|---|---|
| ZocialComment | No — CSV & JSON | ~45 data columns; opens cleanly in Excel via the UTF-8 import above. Adds AI sentiment & purchase-intent columns on paid plans. |
| ExportTok | Yes | CSV and XLSX, high-volume focus, no analysis layer. |
| ExportComments | Yes | CSV and XLSX across multiple platforms; not TikTok-optimized. |
| TTCommentExporter | Yes | Browser extension, exports straight to CSV/Excel. |
If you just need raw rows in Excel, a native-XLSX tool saves one step. If you also want sentiment, purchase-intent scoring, and bot detection alongside the export, the extra columns are worth the 30-second import — see our full tool comparison.
Frequently asked questions
Can I export TikTok comments directly to Excel without a tool?
No. TikTok provides no export feature and no public comment API for ordinary accounts, so you need a third-party exporter. The realistic workflow is always export → CSV → open in Excel correctly.
Why are my exported emojis broken in Excel?
Because Excel opened the CSV as ANSI. Close it, open Excel, and re-import via Data → From Text/CSV with file origin 65001: Unicode (UTF-8). The data was never corrupted — only the display encoding was wrong.
Does this work for TikTok photo (slideshow) posts?
Yes. Photo-post comments export the same way as video comments — paste the post URL and run the export.
Is there a free way to do this?
Yes. ZocialComment's free tier gives you 200 comments per video, three videos per day, no account required — enough to test the full Excel workflow before paying for anything.
Get your first sheet
Grab a TikTok URL, run a free export, open the CSV with the UTF-8 import wizard, and you'll have a clean, filterable Excel sheet in under five minutes. Once you're comfortable, the Starter plan raises limits and adds AI analysis columns so the spreadsheet does the thinking for you.