TweetArchive/Guide

Guide · Updated November 13, 2026 · by Cedano Labs LLC

How do I convert my X archive to CSV or JSON?

Open your archive ZIP in TweetArchive and use Export: posts become a CSV (ID, UTC date, type, text with expanded links, reply info, thread root, likes, reposts, media files) or clean JSON, and DMs export the same way. It all runs in your browser, and IDs are kept as text so spreadsheets don’t round them.

Step by step

1. Open the archive ZIP

   TweetArchive parses tweets.js (all parts) and the DM files.

2. Go to Export

   Pick Posts CSV/JSON or Messages CSV/JSON.

3. Open in a spreadsheet

   The CSV is UTF-8 with a BOM, so Excel shows emoji and accents correctly.

4. Unlock Pro for the full file

   The free preview exports a 25-post sample.

Honest limitations

• There is no official public specification of the archive format that we could read; TweetArchive follows what several independent parsers document and discovers file names instead of assuming one layout.
• Some archives omit @usernames for DM partners; those people appear as a numeric user ID.
• TweetArchive is not affiliated with X Corp. and does not log in to X for you.
• Spreadsheets may still convert long IDs to numbers if you re-save; import the ID column as text.

Frequently asked questions

Will t.co links be expanded?

Yes, when the archive includes the expanded URL for the link.

Are threads marked?

Yes, each post has a type (post, reply, repost, thread_start, thread_reply) and a thread root ID.

Can I export DMs too?

Yes, with conversation ID, message ID, sender, UTC time, and text.

Is SQLite export available?

Not yet. CSV and JSON are available today.

Related

• How to download your official X archive
• Privacy: what TweetArchive does and doesn’t see
• How do I open my X (Twitter) archive ZIP?
• Your archive.html is not loading
• How do I view DMs in my X archive?
• How do I search X archive DMs as evidence?
• How do I export X archive photos with the real date?
• How do I export my X archive to PDF?
• My X archive is several GB and won’t open on Windows
• I deleted my X account and only have the archive
• X archive media dates are wrong
• Is it safe to upload my X archive to a website?
• How do I download my official X archive?
• What is tweets.js and why isn’t it JSON?
• How do I view threads in my X archive?

Sources

• The Verge: How to download an archive of your Twitter data (updated Nov 14, 2022)
• Ars Technica: How to download a backup copy of your Twitter data (Oct 28, 2022)
• twitter-archive-parser by Tim Hutton (GitHub)
• alkihis/twitter-archive-reader: file structures

TweetArchive is an independent tool made by Cedano Labs LLC. It is not affiliated with, endorsed by, or sponsored by X Corp. “X” and “Twitter” are trademarks of X Corp., used here only to describe the archive format the tool reads. TweetArchive is not a forensic lab or a legal service, and its exports are not certified evidence. Markdown version: /convert-archive-to-csv.md.