TikTok Posts Exporter
Export any creator’s posts — captions, views, likes, comments, and dates — to CSV, Excel, or JSON. Exports the post list & metadata, not the video files (for those use the Video Downloader).
Free exports cover the latest 5 posts. to unlock full history and any date range.
CSV, Excel & JSON
Every post as one row — caption, URL, views, likes, comments, shares, saves, duration, date, music, hashtags. Opens cleanly in Excel and Sheets.
Date-range export
With a pass, export a creator’s full history or any from–to window — perfect for campaign windows and month-over-month reporting.
No login, no password
Paste a public profile and export. The latest 5 posts of any creator are free, no TikTok password ever needed.
Free vs. Pass
Everyone can export for free. A pass lifts the limits and unlocks the richer metadata fields.
Free
no login
- Latest 5 posts of any creator
- Post URL, thumbnail & caption
- Views, likes, comments, shares, saves
- Post date, hashtags, mentions, language
- CSV, Excel & JSON download
- 3 exports per day, no login
With a Pass
from $14
- Unlimited posts + full history
- Date-range (from–to) export
- Duration & music / original-sound
- Ad, branded-content & shop-link flags
- Product name, link & price (TikTok Shop)
- Location: name, address & type
- Transcript (auto-caption) URL
- Export via MCP (ChatGPT, Claude, Gemini, Grok)
What you can do with it
Monitor a creator
Track any creator’s output over time — how often they post, what’s taking off, and which videos carry their best views and engagement.
Monitor competitor campaigns
Export a rival brand or creator’s posts, filter by date range, and see exactly what they shipped during a launch — cadence, hooks, hashtags and results.
Find sponsored & branded posts
The export flags ads, branded content, and shop links, so you can isolate a creator’s paid collaborations and study what sponsored content actually performs.
TikTok Shop research
Spot posts carrying product/shop links and sort by views to find which shoppable videos drive the most attention for a seller or category.
Build a KOL shortlist
Export several creators, compare median views and engagement side by side in a spreadsheet, and shortlist the ones worth a partnership.
Content audit & reporting
Pull a brand account’s full history into Excel for a monthly report — posting frequency, top posts, hashtag and music trends over any window.
What the export looks like
Every export is one row per post with 25 columns. Columns marked are pass-only — blank on free exports. Here’s what a CSV/Excel file looks like:
| Post URL | Thumbnail | Description | Views | Likes | Comments | Shares | Saves | Duration (s) | Posted At (UTC) | Music | Original Music | Hashtags | Mentions | Language | Is Ad | Branded Content | Has Shop Link | Product Name | Product Link | Product Price | Location | Location Address | Location Type | Transcript URL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| https://www.tiktok.com/@creator/video/7401234567890 | https://p16.tiktokcdn.com/…/cover1.jpg | Summer skincare haul ☀️ which one is your fave? #skincare #haul | 1,204,553 | 188,204 | 4,921 | 12,043 | 30,118 | 27 | 2026-06-14T09:22:00Z | original sound - creator | TRUE | #skincare #haul | — | en | FALSE | TRUE | TRUE | Aloe Vera Hydrating Serum 30ml | https://www.tiktok.com/shop/pdp/1736460194617525993 | $12.90 | — | — | — | https://v16-webapp.tiktok.com/…/subtitle-en.vtt |
| https://www.tiktok.com/@creator/video/7399887766554 | https://p16.tiktokcdn.com/…/cover2.jpg | GRWM before the event 💄 #makeup #grwm | 842,010 | 96,330 | 1,204 | 3,880 | 11,540 | 41 | 2026-06-09T18:03:00Z | aesthetic - lofi beats | FALSE | #makeup #grwm | @brandpartner | en | TRUE | TRUE | FALSE | — | — | — | — | — | — | https://v16-webapp.tiktok.com/…/subtitle-en.vtt |
| https://www.tiktok.com/@creator/video/7395551122334 | https://p16.tiktokcdn.com/…/cover3.jpg | Best pour-over in the city ☕ #coffee #coffeetok | 312,774 | 40,118 | 2,650 | 901 | 4,220 | 58 | 2026-06-02T12:47:00Z | original sound - creator | TRUE | #coffee #coffeetok | — | en | FALSE | FALSE | FALSE | — | — | — | Blue Bottle Coffee | Williamsburg, Brooklyn, NY, USA | Coffee Shop | https://v16-webapp.tiktok.com/…/subtitle-en.vtt |
JSON export returns the same fields as an array of objects, ready for data pipelines and BI tools.
How to export TikTok posts
- 1
Paste the profile
Copy a TikTok profile link (tiktok.com/@username) or just type @username into the box.
- 2
Choose a range (optional)
Free exports return the latest 5 posts. With a pass, pick a from–to date range or export the full history.
- 3
Export the posts
Click Export posts — the creator’s videos are pulled with captions, views, likes, comments, dates, music, and hashtags.
- 4
Download CSV, Excel or JSON
Preview the results, then download one row per post in the format you need for analysis or reporting.
Export TikTok posts & videos to a spreadsheet
The TikTok Posts Exporter pulls a creator’s posts — the whole video list with captions, view/like/comment/share/save counts, durations, post dates, music, and hashtags — into a clean CSV, Excel, or JSON file. It’s the fast way to turn a public TikTok profile into analyzable data.
Who uses it: marketers benchmarking competitors’ content, agencies building creator shortlists, analysts tracking a brand account’s output month over month, and researchers studying hashtags and posting cadence. Because every post lands in its own row, you can sort by views to find a creator’s best-performing videos, filter by date to isolate a campaign window, or pivot on hashtags and music to see what’s driving reach.
Free exports cover the latest 5 posts of any public creator with no login. Need the full back-catalogue or a specific date range? A 3-Day Unlimited Pass unlocks unlimited posts and the from–to date picker. To pull the comments under a video instead, use the TikTok Comment Exporter; to download the video files, use the Video Downloader.
Frequently asked questions
What is the TikTok Posts Exporter? +
It exports a TikTok creator’s posts — their whole video list with captions, view/like/comment/share/save counts, durations, post dates, music, and hashtags — into a CSV, Excel, or JSON file. It exports the post metadata, not the video files.
Is it free to export TikTok posts? +
Yes. You can export the latest 5 posts of any public creator for free with no login, up to 3 exports per day. A one-time $14 3-Day Unlimited Pass unlocks the full post history and date-range exports.
Can I export TikTok videos by date range? +
Yes, with a pass. Free exports cover the latest 5 posts; a pass lets you set a from–to date range or pull a creator’s entire back-catalogue — ideal for campaign windows and monthly reporting.
Does this download the actual TikTok videos? +
No — this tool exports the post list and metadata to a spreadsheet. To download the video files themselves (watermark-free MP4/MP3), use the separate Video Downloader tool.
Do I need the creator’s login or password? +
No. It works on any public TikTok profile using just the profile URL or @username. You never need a TikTok password or the creator’s permission for public data.
What columns are in the export? +
One row per post with: Post URL, Thumbnail, Description, Views, Likes, Comments, Shares, Saves, Duration, Posted At (UTC), Music, Original Music, Hashtags, Mentions, and Language.