TikTok profile scraper
Scrape a whole TikTok profile into a spreadsheet.
Enter a handle and pull every public video with views, likes, comments, and captions. Sort by any metric, stop and resume anytime, and export the whole set to CSV or JSON.
Whole profile in one job
Up to ~2,000 of the newest public videos with full stats.
Sortable by any metric
Order by views, likes, comments, or date to find the winners fast.
Stop and resume
Pause a long scrape and pick it up later. Partial results are always kept.
Export or collect
Download CSV, Excel, and JSON, or save standout videos into named collections.
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 the handle
An @username or a full profile link.
- 02
Set how many videos
50, 100, 500, or every public post.
- 03
Fill, then export
Results stream in live. Download when it finishes.
Questions
- How do I scrape a TikTok profile?
- Enter the @handle or profile URL, choose how many videos to pull, and tikklip streams the public post list with stats. Export to CSV or JSON when it finishes.
- How many videos can I scrape per profile?
- Up to roughly 2,000 of the newest public videos, each with views, likes, comments, and captions.
- What data comes back for each video?
- Title and caption, play count, likes, comments, shares, saves, post date, and a link to the original.
- Can I pause a large scrape?
- Yes. Stop anytime and resume later. Partial results are kept and a resumed job is never charged twice.
- Is scraping TikTok profiles allowed?
- Only scrape public data you have the rights to use. tikklip stores metadata and links, not video files. 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.
Search & hashtag export
Any keyword or hashtag, turned into a sortable spreadsheet of videos and stats.
Video downloader
Any link, turned into a watermark-free MP4, an HD copy, and an MP3. Free, no app.