The columns
- created_at — full ISO timestamp, so sorting works properly.
- text — the post as written, with links expanded to their real URLs instead of the shortened display text.
- uri and rkey — stable identifiers if you need to join this against anything else.
- is_reply and reply_parent — filter out conversation noise in one click.
- quoted — the post you were quoting, if any.
- media_count and media_urls — direct, public links to each image and video.
- langs and labels — declared language and any self-applied content labels.
Quoting done properly
Every field is quoted and internal quotes are doubled, which is the only thing that keeps a CSV intact when your posts contain commas, line breaks and quotation marks — and yours do. Files open cleanly in Excel, Numbers, Google Sheets and LibreOffice without a mangled row.
Turning it into a Notion database
Notion imports CSV as a database rather than a page, so this file becomes a sortable, filterable table of your posting history. The dedicated Notion export takes it further: monthly pages to read plus the database to query.
Questions
- Do the media URLs expire?
- They point at your own server's public blob endpoint and keep working as long as your account exists. If you are about to delete your account, download the media pack rather than relying on the links.