How to Export Twitter Analytics Data (CSV Guide for X)

How do you export Twitter analytics data?

To export Twitter analytics data, open X's Post Activity Dashboard through ads.x.com (Analytics, then Post activity), choose a date range, and click Export to download a CSV file. Each export covers up to 30 days and 3,000 posts, in UTC time. Third-party guides say X Premium's account analytics page offers a content CSV too.

Here's a moment that catches a lot of people out. You've been posting for a year, you want to see what worked, and the dashboard only lets you look back so far. The history you needed is hard to reach. Exporting your data regularly fixes that for good.

Exporting means downloading your X (formerly Twitter) stats as a CSV file. A CSV is a plain spreadsheet file that opens in Google Sheets, Excel or Numbers. Once your data lives in a sheet, you can sort it, chart it, and keep it as long as you like. This is simpler than it sounds.

How do you export from the Post Activity Dashboard?

The Post Activity Dashboard is X's documented export route. Open ads.x.com, choose Analytics, then Post activity, set your date range, and click Export. You'll get a CSV with one row per post.

Here are the steps from X's Post and Video Activity Dashboards help page, at the time of writing (October 2026):

1. Sign in to ads.x.com. X describes the dashboard as a free feature for anyone with an ads account.
2. Click the Analytics menu and choose Post activity.
3. The dashboard shows the last 28 days by default. Change the date range in the top-right corner.
4. Click Export to receive a .CSV file.

The file includes "all post-level data and permalinks, broken down by organic vs. promoted metrics." A permalink is the direct link to each post, which makes it easy to jump back and look at the post itself.

A fair warning. I couldn't test this route while signed in, and X's help page carries no date. It also still mentions registering at analytics.x.com, which now redirects to the paid account analytics page. If you don't see Post activity under the Analytics menu in ads.x.com, the route may have changed.

What are the export limits?

Each Post Activity Dashboard export covers up to 30 days and up to 3,000 posts. The time zone is fixed to UTC/GMT. For longer history, export one month at a time.

X's help page puts it this way: "You can export up to 30 days of data at a time and there is a 3,000 post cap per .CSV export." If you reply a lot, you might hit the post cap before 30 days. In that case, split the range into two-week or one-week chunks.

The UTC time zone matters if you study posting times. If you're in New York, for example, UTC is four or five hours ahead depending on daylight saving time. Convert the times before you decide your best hour to post.

One more thing: fresh numbers move. X says its systems "take up to 36 hours to stabilize." I'd wait two days after the end of a month before exporting it.

Can you export from X's account analytics page?

Possibly, if you pay for a plan that includes analytics. Third-party guides describe an export control on x.com/i/account_analytics that downloads a content CSV, but X's help center doesn't document it at the time of writing.

OpenTweet, which makes a CSV analysis tool, tells users to open that page, set a date range and download the content CSV. It also notes that X has changed the column names in this export over time, for example "Impressions" in one version and "Views" in another. So if you build formulas on top of an export, check the headers each time.

Not sure how to reach that page? The walkthrough in how to use Twitter analytics in 2026 covers it.

What other ways can you export X data?

You can also export campaign data from X Ads, pull metrics through the X API, or use a third-party tool that offers CSV downloads. Each one suits a different need.

• Ads campaign CSV: for paid campaigns only. X's Export CSV Definitions page says to use the Export button in the upper right of your campaign dashboard, and that the Post Activity Dashboard is for organic post data.
• X API: for developers. The X API metrics docs list public metrics like impression_count and like_count. Private metrics such as link clicks need your account's permission and are "only available for posts created within the last 30 days."
• Third-party tools: as of October 2026, Typefully's help center says any analytics chart has a download button for CSV, Sprout Social offers CSV export of raw data, and Hootsuite exports reports as .csv, .xlsx, .pdf or .ppt. Buffer keeps exports for paid plans.

For a fuller look at these tools, see the best X analytics tools for creators.

How do you open the CSV in Google Sheets?

In Google Sheets, open File, choose Import, upload the CSV, and pick whether to make a new spreadsheet or add a new sheet. That's it. Your data is now sortable.

Google's import help page lists .csv as a supported type and lets you set the separator character. Leave it on automatic detection for X exports.

A tidy setup I'd suggest:

• One tab per month, named like "2026-10".
• One "All posts" tab where you paste every month underneath the last.
• Freeze the header row so column names stay visible as you scroll.

From there, you can sort by impressions to find your best performing tweets, or chart your weekly totals to track Twitter impressions over time. If you want a full dashboard with formulas, follow how to build a Twitter analytics dashboard.

Build a monthly export habit

Exporting Twitter analytics data takes five minutes once you know the route. Use the Post Activity Dashboard, export in 30-day chunks, and keep everything in one sheet. Set a reminder for the second day of each month. In a year, you'll have a complete record of your growth that no dashboard limit can take away.

Frequently Asked Questions

Is exporting X analytics data free?

Exporting from the Post Activity Dashboard is described as free by X's ads help center, and it needs only an ads account at ads.x.com. The newer account analytics page at x.com/i/account_analytics is reported to require a paid X plan, so any export from that page would need one too.

Why does my X analytics export stop at 3,000 posts?

The X analytics export stops at 3,000 posts because the Post Activity Dashboard caps each CSV file at 3,000 posts and 30 days. Accounts that reply a lot can hit the post cap early. Split the date range into smaller pieces, such as one or two weeks, and export each piece separately.

What columns are in the X analytics CSV?

The Post Activity Dashboard CSV includes post-level data with permalinks, split into organic and promoted metrics. X's help page lists metrics such as impressions, engagements, engagement rate, likes, replies, reposts, link clicks and profile clicks. Column names have changed between versions, so check the header row before reusing old formulas.

What time zone does the X analytics export use?

The X analytics export uses UTC/GMT, according to X's Post Activity Dashboard help page. Convert the timestamps to your own time zone before studying posting times. In Google Sheets, subtract the hour difference from each time, for example five hours for New York during standard time.

Can I export X analytics data with the API?

Yes, X analytics data can be pulled with the X API. Public metrics such as impressions, likes, replies and reposts work for any post. Private metrics like link clicks need user authorization and, according to X's API documentation, are only available for posts created within the last 30 days.