Export TikTok Posts to CSV
Export every post on any public TikTok account to CSV: date, views, likes, comments, shares, saves and length. Opens in Excel and Google Sheets. No login.
Every post on any public TikTok account, as a spreadsheet
Enter the handle. We check the account is public and count its posts, then export every one of them for $10 a year, or $5 a month.
What you get
One row per post, newest last, with seventeen columns. Open it in Excel, Numbers or Google Sheets.
| Column | What it holds |
|---|---|
| post_id | TikTok's id for the video (Excel rounds 19-digit numbers; the url column keeps it exact) |
| url | Link to the post |
| caption | The caption, complete, with hashtags and emoji (one starting with @, =, + or - gets a leading ' so Excel keeps it as text) |
| published_local | Date and time posted, in the time zone you chose |
| time_zone | That time zone, named on every row |
| published_utc | The same moment in UTC (ISO 8601) |
| views | Play count at the last check |
| likes | Hearts at the last check |
| comments | Comment count at the last check |
| shares | Share count at the last check |
| saves | Saves (bookmarks) at the last check |
| duration_sec | Video length in seconds |
| type | video or photo post |
| usual_views_at_the_time | What the account typically got: the median of the four posts before |
| vs_usual | Views divided by that usual (1.00 = typical) |
| under_usual | true when the post landed under half its usual |
| still_counting | true when the post is new and its views are still climbing |
Want it as a client-ready PDF instead? See the TikTok analytics report.
See one before you buy
These are the real files for the example account PopTrend tracks in the open. Yours look the same, for your account.
How far back does the export go?
Up to 500 posts, back to the first one we can reach, which for most accounts is everything. TikTok's own analytics stop at 60 days and only cover your own account; this reads any public profile.
What columns are in the CSV?
One row per post with post_id, url, caption, published_local, time_zone, published_utc, views, likes, comments, shares, saves, duration_sec, type, usual_views_at_the_time, vs_usual, under_usual and still_counting. The file is UTF-8 with a byte-order mark, so captions with emoji open correctly in Excel, Numbers and Google Sheets.
What time zone are the dates in?
The one you pick when you download: it defaults to your own and you can choose a client's. Every row also carries the same moment in UTC, so nothing is ambiguous.
Can I export an account I don't own?
Yes. Any public TikTok account: a client, a competitor, your own. Nothing is connected and the account owner is not notified.
What does 'under usual' mean?
A post landed under half of what the account typically got at the time (the median of the four posts before it). In the CSV it is one column you can delete; on the chart it is a marker you can hide.
Does this work on mobile?
Yes. The file downloads to your phone and opens in Google Sheets, Numbers or Excel. The chart image and PDF download the same way.
See what's working. Take it with you.
Every post on any public TikTok account, charted and kept up to date, with the CSV, the chart and the PDF included. $10 a year.
Sign up · $10 a year