TikTok search & hashtag export
Turn a hashtag into a clean spreadsheet.
Search any keyword or hashtag and export the matching videos with their stats. Built for trend research, competitive scans, and campaign reporting, ready for CSV or JSON.
Keyword or #hashtag
One query in, a sortable result set out.
Stats on every row
Views, likes, comments, author, and date for each result.
See the real trend
Enough results per query to read the actual shape of a topic.
Export or collect
Download CSV, Excel, and JSON, or save standouts to a collection.
What you actually get
Every row is one public video. These are the exact column headers, in the exact order they appear in the file — no hidden fields, no “upgrade to see the data” columns left blank.
| Column | Type | What it holds | Example |
|---|---|---|---|
| url | url | Canonical link to the video on TikTok. | https://www.tiktok.com/@examplecreator/video/7300000000000000000 |
| awemeId | string | TikTok's own video id. Stable, and what the API takes as input. | 7300000000000000000 |
| author | string | Creator handle, without the @. | examplecreator |
| title | string | Full caption text, including hashtags. | three ways to reuse a hook #marketing |
| plays | number | View count at the moment the job ran. | 184200 |
| likes | number | Like count. | 12400 |
| comments | number | Comment count. | 318 |
| shares | number | Share count. | 902 |
| saves | number | Save / favourite count. | 1560 |
| durationMs | number | Video length in milliseconds. | 27000 |
| createTime | number | Publish time as a Unix timestamp in seconds. | 1730380000 |
And it opens properly
Most exporters get at least one of these wrong. These are properties of the file we write, not promises.
- Opens clean in Excel
- UTF-8 with a byte-order mark, so emoji and non-Latin handles survive a double-click on Windows instead of turning into mojibake.
- RFC 4180 quoting
- Commas, quotes and newlines inside a caption or comment are escaped properly, so a multi-line comment never splits into two rows.
- Formula-injection safe
- A comment starting with =, +, - or @ is prefixed with an apostrophe so Excel and Sheets treat it as text instead of executing it (CWE-1236).
- CRLF line endings
- The line terminator the CSV spec actually calls for, which is what keeps older Excel builds from collapsing rows.
How it works
- 01
Enter a keyword or hashtag
Search the way you would in the app, minus the endless feed.
- 02
Set result depth
Choose how many results to pull.
- 03
Export the sortable set
Rank by views or likes, then download.
Questions
- Can I export TikTok search results?
- Yes. Enter a keyword or hashtag and tikklip returns matching public videos with stats you can sort and export to CSV or JSON.
- How is this different from TikTok's own search?
- You get a structured, sortable, exportable dataset instead of an endless feed, so you can rank by views or likes and hand it straight to a spreadsheet.
- How many results can I export per query?
- Hundreds of results per query, depending on availability for the term.
- Is hashtag scraping allowed?
- Use it for public data you have the rights to analyze. tikklip keeps metadata and links, not videos. See our Terms.
Get the whole toolkit
Downloads, profile scraping, search and comment exports, and saved collections, in one place. Start free, no card required.
More tools
Comment exporter
Every comment off any video, exported to CSV, Excel, or JSON with handles, likes, and replies.
Profile scraper
Every public video from a handle, exported to CSV with views, likes, and captions.
Video downloader
Any link, turned into a watermark-free MP4, an HD copy, and an MP3. Free, no app.