How to Export Tweets to CSV
Choose the source
Pick an account (with an optional date range), a search (words, hashtags, operators) or a list of post links.
Preview the posts
The latest 20 posts appear instantly, with views, likes, reposts, replies, quotes, bookmarks, media and labels. Sort by any column.
Download
Save as CSV for any tool, Excel for spreadsheets, or JSON for code. To export every post, use a free API key; the estimate shows the exact cost first.
What’s in the Export: Every Column Explained
Post
tweet_idurlcreated_atUTClangtypepost, reply, quote or repostin_reply_to_usernameconversation_id
Engagement
viewslikesrepostsrepliesquotesbookmarks
As of the moment you export.
Author
author_usernameauthor_nameauthor_followersat the time of export
Content and labels
texthashtagsmentionslinksmedia_typesmedia_urlsmade_with_aipaid_partnershipis_replies_limited
Views and bookmarks are the two columns most exporters skip, and they are often the most useful: views show reach, and bookmarks show what people found worth keeping. The label columns show X’s own disclosures for AI content and sponsored posts, which no other exporter includes.
Files That Open Correctly in Excel and Google Sheets
Most tweet exports break the moment you open them in a spreadsheet. This one is built to avoid the three classic problems:
Long IDs stay exact.
Post IDs have 19 digits. Excel rounds numbers that long, so IDs are stored as text and never turn into 1.23457E+18.
Emoji and other alphabets survive.
CSV files are UTF-8 with a byte-order mark, so Excel reads emoji, Cyrillic, Arabic or Japanese text correctly.
No formula surprises.
Cells that start with =, +, − or @ are escaped, so a post’s text can never run as a spreadsheet formula.
Export an Account, a Search or a List of Posts
Account
- The latest 20 posts from one profile, newest first.
- Add a date range to export a specific period: it switches to X’s search with
from:andsince:oruntil:, which also reaches further back than the profile timeline. - Toggle replies, reposts and media-only posts to shape the dataset.
Search
- The latest 20 matching posts, newest first.
- Anything X search can find: keywords, hashtags, mentions, phrases, languages and engagement filters such as
min_faves. - Build complex queries with the Search Builder, then paste them here.
Post links
- Paste up to 20 links or IDs, for example from a report, a campaign tracker or a spreadsheet, and get one row per post with current stats.
- Links that no longer load are flagged.
How Far Back Can You Export?
An account’s profile timeline on X goes back only so far, roughly the latest few thousand posts. For older posts, use a date range: the export then runs through X search, one period at a time, and can reach much further back. Two limits apply to every tool:
- Deleted posts are gone, and posts from protected accounts are not public.
- Search is not an archive of everything. X search returns what it indexes, so a very old or low-engagement post may not appear. The exact count for a period can differ from the account’s total.
If you want your own complete history, including posts from years ago, download your X archive and open it in the Archive Viewer. That covers your account only; this tool covers public posts of any account.
Export Tweets Without a Scraper, Extension or Login
There are three common ways to get tweets into a spreadsheet. Each has a catch:
| Browser extensions | Scraper platforms | This exporter | |
|---|---|---|---|
| Needs your X login | Yes, runs in your logged-in browser | Sometimes | No |
| Install anything | Yes | Account and setup | No |
| Instant preview | Varies | No, run then download | Yes, 20 rows |
| Views and bookmarks | Some | Some | Yes |
| AI and sponsorship labels | No | Rarely | Yes |
| Full-export cost shown upfront | No | Per-run pricing | Yes, per request |
The free Google Sheets add-on many researchers relied on, TAGS, stopped working in 2023 when X ended free API access. This page is a direct, no-setup alternative for small exports, and the Sorsa API covers large ones.
Export Thousands of Tweets With the API
The preview stops at 20 rows. The Sorsa API returns the same rows without a cap:
- /user-tweets and /search-tweets at 20 posts per request, with a cursor for the next page;
- /tweet-info-bulk at 100 posts per request.
| Export size | Requests | Cost on Pro |
|---|---|---|
| 1,000 posts | 50 | about $0.10 |
| 3,200 posts | 160 | about $0.32 |
| 20,000 posts | 1,000 | about $2 |
- One API key, no app approval, setup in about 3 minutes
- The same columns as this page, as JSON
- Flat 20 requests per second on every plan
- 100 free requests to start: up to 2,000 posts, no card
import csv, requests H = {"ApiKey": "YOUR_API_KEY"} body, rows = {"username": "nasa", "with_replies": False}, [] while True: page = requests.post("https://api.sorsa.io/v3/user-tweets", headers=H, json=body).json() rows += page.get("tweets", []) if not page.get("next_cursor") or len(rows) >= 1000: break body["next_cursor"] = page["next_cursor"] with open("tweets.csv", "w", newline="", encoding="utf-8-sig") as f: w = csv.writer(f) w.writerow(["id", "created_at", "text", "views", "likes"]) for t in rows: w.writerow([t["id"], t["created_at"], t["full_text"], t.get("view_count"), t.get("likes_count")])
Related Tools
How to download all tweets from a userFrequently Asked Questions
How do I export tweets to CSV?
Enter an account, a search or a list of post links above, preview the posts, and press CSV. The file includes text, date, author, views, likes, reposts, replies, quotes, bookmarks, media links and labels for each post.
Can I export tweets from any account, not just mine?
Yes. Any public X account works, with no login. Protected accounts can’t be exported, because their posts are private.
Is it free?
Yes, for the latest 20 posts per export, from an account, a search or a list of up to 20 links, with 5 free exports a day. Larger exports run on a free API key: the first 100 requests cover up to 2,000 posts.
Can I download all tweets from a user?
Here you get an account’s latest 20 posts, or the latest 20 of any older period you pick with a date range, through X search. Deleted posts and posts X no longer indexes can’t be recovered. For your own complete history, download your X archive and open it in the Archive Viewer.
Can I export tweets from a hashtag or a search?
Yes. Use the Search tab: keywords, hashtags, phrases and X search operators all work, with an optional date range.
Does the export include views and bookmarks?
Yes. Views, likes, reposts, replies, quotes and bookmarks are included, as of the moment you export.
Can I open the file in Excel or Google Sheets?
Yes. Download .xlsx for Excel, or CSV for any spreadsheet. IDs are stored as text so they aren’t rounded, and the CSV is UTF-8 with BOM so emoji and non-Latin text display correctly.
Can I export an account’s likes or bookmarks?
No. On X, the list of posts an account liked and its bookmarks are private, so no public-data tool can export them.
Is this a Twitter scraper?
It is an export tool built on the Sorsa API. You don’t run a scraper, a browser extension or automation on your side, and your X account is never involved.
Is this a TAGS alternative?
Yes, for small exports without setup. TAGS stopped working in 2023 when X ended free API access. For ongoing collection into spreadsheets, the Sorsa API returns the same data at 20 posts per request.