TikTok gives you no way to export comments, and Google Sheets can't read a TikTok URL. So the real question isn't "does TikTok connect to Sheets" — it doesn't — it's what's the shortest path from a video URL to a live, filterable spreadsheet. This guide gives you that path, plus the one trick to make the sheet refresh itself, and the fixes for the emoji and single-column problems that trip up almost everyone.
It's worth getting right because comment data is only useful once you can sort, filter, and pivot it. A single viral video can hold thousands of comments — noise until they're in rows and columns you can actually work with.
The fastest path: export to CSV, import to Sheets
Every comment export tool produces a CSV, and Google Sheets imports CSV natively. The trick is importing it correctly so emojis, Thai, and Arabic text survive and every field lands in its own column.
- Copy the TikTok video URL (tap Share → Copy link in the app, or copy from the address bar on desktop).
- Paste it into ZocialComment's free TikTok export and run it — no signup, 100 comments per video on the free tier.
- Open a new Google Sheet and choose File → Import → Upload, then select the CSV.
- In the import dialog set Separator type to Comma and uncheck "Convert text to numbers, dates, and formulas" — this keeps long user/comment IDs from turning into
1.23E+17and stops emojis from being mangled. - Click Import data. You'll have roughly 45 columns: comment text, username, likes, reply count, timestamp, and more.
That's the whole job. Freeze the header row (View → Freeze → 1 row) and turn on filters (Data → Create a filter) and the sheet is ready to work.
Make the sheet refresh itself with IMPORTDATA
If you're tracking an ongoing campaign and don't want to re-import by hand, host the CSV at a public URL and pull it live:
=IMPORTDATA("https://example.com/exports/comments.csv")Google Sheets re-fetches an IMPORTDATA source roughly once an hour, so the sheet stays current without a manual import. Two honest caveats: the CSV has to be publicly reachable (not behind a login), and for a one-off analysis this is overkill — a plain File → Import is simpler and keeps your data private. Reach for IMPORTDATA only when you genuinely need the sheet to update on its own.
Fixing the 2 problems everyone hits
| Problem | Cause | Fix |
|---|---|---|
Emojis or non-Latin text show as boxes or é | File read as ANSI, or Sheets auto-converted the text | Import a UTF-8 CSV and uncheck "Convert text to numbers, dates, and formulas" in the import dialog |
Long numeric IDs become 1.23E+17 | Sheets auto-converted a long number to scientific notation | Same checkbox — leaving conversion off keeps IDs as plain text |
What to do once it's in Sheets
- Sort by likes to surface the most-engaged comments instantly.
- Filter views to isolate comments containing a keyword, hashtag, or @mention without touching the raw data.
- Pivot table on the timestamp column to see when your audience comments most.
- COUNTIF / SEARCH to quantify how often a product name or competitor appears.
- Conditional formatting to flag buying-intent phrases ("where to buy", "price", "link").
For the full workflow — sentiment, themes, purchase intent — see how to analyze TikTok comments. Prefer Microsoft's spreadsheet? The export-to-Excel guide covers the same job with the UTF-8 import wizard.
Skip the spreadsheet math with AI columns
Sorting and COUNTIF get you a long way, but scoring sentiment and purchase intent by hand across thousands of rows is slow. ZocialComment's paid plans add AI columns to the export — sentiment, purchase-intent scoring, and bot detection — that import into your sheet alongside the raw comments, so the filtering and pivots you build run on top of analysis that's already done. The $39 pass removes the free-tier limits and unlocks those columns.
Frequently asked questions
Can I export TikTok comments directly to Google Sheets?
Not from TikTok itself — there's no export feature and no public comment API for ordinary accounts. Export to CSV first, then import that CSV via File → Import. The full flow takes a couple of minutes and needs no code.
How do I keep the sheet updated automatically?
Host the CSV at a public URL and pull it with =IMPORTDATA(...), which Sheets refreshes about hourly. For one-off analysis, a manual import is simpler and keeps the data private.
Why are my emojis broken after import?
Because the text was auto-converted or read as ANSI. Re-import the UTF-8 CSV with "Convert text to numbers, dates, and formulas" unchecked — the data was never corrupted, only the parsing was wrong.
Is there a free way to do this?
Yes. ZocialComment's free tier gives 100 comments per video, three videos a day, no account required.
Get your first sheet
Grab a TikTok URL, run a free export, import the CSV with conversion switched off, and you'll have a clean, filterable Google Sheet in under five minutes. When you're ready to scale, the $39 pass lifts the limits and adds AI columns so the sheet does the thinking for you.