How to Export TikTok Comments to Excel (Free & Fast)

TikTok has no built-in button to export comments. If you have ever tried to save a video's comments into a spreadsheet, you already know the app gives you nothing beyond scrolling and copying by hand. Yet there are plenty of good reasons to want those comments in Excel: analyzing feedback, tracking brand mentions, researching a trend, keeping a record, or running a giveaway.

This guide covers how to export TikTok comments to Excel or CSV quickly and for free, what data you actually get, how to open the file without the formatting breaking, and, importantly, a faster route if your real goal is picking a giveaway winner rather than crunching data.

Why there is no native export, and what you actually get

TikTok does not offer comment export because it is a content app, not a data tool. To get comments into a spreadsheet, you use a third-party comment export tool that reads the public comments on a video and writes them into a file. These tools only see what any viewer could see: the public comments on a public video with commenting enabled.

A typical export gives you a row per comment with columns like the username, the comment text, the date it was posted, how many likes the comment got, the number of replies, and often the user's profile link and whether the comment is a reply to another. That structured format is what makes a spreadsheet useful. Instead of a wall of comments you can only scroll, you get sortable, filterable data you can actually work with.

Method 1: use a free comment export tool

For anything beyond a handful of comments, a dedicated export tool is the practical route, and several are free to start. The process is broadly the same whichever you use.

First, copy the link to your TikTok video. On mobile, open the video, tap the Share arrow, and choose Copy Link. On desktop, open the video at tiktok.com and copy the URL from the address bar. Next, paste that link into the export tool. Then choose your options: which fields to include, such as username, comment text, date, and likes, and your file format, usually CSV or XLSX. Finally, run the export and download the file when it is ready.

A few things to know going in. Most export tools work from a public video URL without any login, though some let you log in via TikTok's official flow to pull comment replies or raise limits. Free tiers almost always cap how many comments you can export per video or per month, so a viral video with tens of thousands of comments may need a paid plan or may only partially export on the free tier. And most exporters handle TikTok photo posts as well as videos, since photo posts have comment sections too. Deleted or hidden comments will not appear, because the tool only sees what is publicly live.

Method 2: copy and paste for small comment counts

If you only need a small number of comments, say a couple of dozen, you do not need a tool at all. Open the video, select the comment text, copy it, and paste it into a spreadsheet. It is crude, it loses the structured fields, and it becomes miserable past a few dozen comments, but for a quick, tiny job it is genuinely the fastest free option.

For anything larger, the manual method falls apart quickly, both because of the volume and because TikTok loads comments as you scroll, so you can never be sure you captured them all. Once you are past a page or two of comments, a proper export tool saves far more time than it costs.

Opening the file cleanly in Excel

One common frustration deserves a heads-up, because it trips people up and looks like a broken export when it is not. If you open a CSV and see strange characters where emojis or accented letters should be, that is an encoding mismatch, not lost data. TikTok comments are full of emojis, and Excel sometimes misreads the character encoding.

The fix is to import rather than double-click. In Excel, go to the Data tab, choose From Text or CSV, select your file, and when prompted, set the file origin or character set to Unicode UTF-8, often listed as 65001. Then load the data. The emojis and special characters render correctly, and your columns line up properly. XLSX files usually avoid this issue entirely, so if a tool offers Excel format directly, that is the simpler choice.

What people actually export comments for

It is worth being clear about the different jobs people use exports for, because the right approach depends on the goal.

For genuine data work, exporting makes complete sense. Analyzing audience sentiment across thousands of comments, monitoring how people talk about your brand under a viral video, counting engaged commenters for an influencer report, or researching the language around a trending sound all benefit from having the data in a spreadsheet where you can sort, filter, and run analysis. For these, a full export to Excel or CSV is exactly the right tool.

But there is one very common reason people search for comment exports that has a much faster solution, and it is worth knowing about before you wrestle with a spreadsheet at all.

If your goal is a giveaway, you may not need to export

A large share of people exporting TikTok comments are not doing data analysis. They are trying to run a giveaway: pull the comments, remove duplicate entries, maybe filter for a keyword, and pick a winner. If that describes you, exporting to Excel is the slow way around.

Instead of downloading a spreadsheet, manually deleting duplicate rows, and using a spreadsheet formula to select a random row, a comment picker does the whole thing directly from the video. A tool like TT Picker reads the comments, filters out duplicate entries so each person gets one fair chance, lets you require a keyword so only valid entries count, and draws a winner at random, all without a file ever touching your desktop. It also handles the parts a spreadsheet cannot, like recording a transparent draw for your audience.

So if you were about to export comments purely to pick a winner, skip the spreadsheet. Removing repeat entries is built in, as shown in the guide to a comment picker without duplicates, and if you are giving away several prizes, drawing them in one pass is covered in the walkthrough on multiple winner selection. The full flow from video link to chosen winner is laid out in the guide to picking a winner from TikTok comments online. You get a fair, recorded result in seconds rather than building and cleaning a spreadsheet by hand.

For pure analysis, export away. For picking a winner, a picker is simply the faster, purpose-built path.

Tips for a clean, complete export

Whichever route you take, a few habits prevent the most common problems.

Make sure the video and account are public, and that comments are enabled, since export and picker tools can only read public comments, exactly like the tools that fail to load comments on private posts. Use the full video link from the address bar rather than a shortened share link, which some tools will not accept. If you are exporting a large video, expect it to take longer and possibly to hit a free-tier cap, so check the limit before you rely on a full export. And remember that a comment count shown in the app can lag reality, so small discrepancies between the displayed number and the exported number are normal, especially right after posting.

What to look for in an export tool

If you do need a full export for analysis, a few features separate a smooth experience from a frustrating one, and they are worth checking before you commit to a tool.

Look at the free tier size first, since that is where most tools quietly stop being free. A cap of a few hundred comments is fine for a small video but useless for a viral one, so match the limit to the size of the video you are exporting. Check that it works from a public URL without forcing a login, which is both faster and safer than handing over account access. Confirm it offers the format you want, XLSX if you want to open straight in Excel without encoding headaches, or CSV if you are feeding the data into another system. Make sure it captures the fields you care about, since some tools export only username and text while others include dates, like counts, replies, and profile links. And confirm it supports photo posts if your giveaway or content runs on carousels rather than videos.

Avoid anything that asks you to install software or a browser extension you do not trust, or that wants payment before showing you anything works. A reputable export tool reads public data and lets you try it before you pay.

Turning an export into insight

Once the comments are in a spreadsheet, the value comes from what you do with the columns. A few quick moves cover most needs.

Sort by like count to surface the comments your audience most agreed with, which is a fast way to find your most resonant feedback. Filter by keyword or hashtag to isolate comments about a specific product, feature, or complaint. Use a pivot table or a simple count to see how many unique commenters you had versus total comments, which tells you how much of your engagement came from a passionate few. And for sentiment, you can paste a column of comments into an AI assistant and ask for a positive, negative, and neutral breakdown, which turns thousands of raw reactions into a readable summary in minutes. These are the jobs a spreadsheet does well, and they are exactly the cases where exporting earns its keep over any other approach.