Skip to main content
✨ Any public account

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.

ColumnWhat it holds
post_idTikTok's id for the video (Excel rounds 19-digit numbers; the url column keeps it exact)
urlLink to the post
captionThe caption, complete, with hashtags and emoji (one starting with @, =, + or - gets a leading ' so Excel keeps it as text)
published_localDate and time posted, in the time zone you chose
time_zoneThat time zone, named on every row
published_utcThe same moment in UTC (ISO 8601)
viewsPlay count at the last check
likesHearts at the last check
commentsComment count at the last check
sharesShare count at the last check
savesSaves (bookmarks) at the last check
duration_secVideo length in seconds
typevideo or photo post
usual_views_at_the_timeWhat the account typically got: the median of the four posts before
vs_usualViews divided by that usual (1.00 = typical)
under_usualtrue when the post landed under half its usual
still_countingtrue 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