How can I export thousands of events?

Hi Elise S., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋

To export thousands (or more) events from Mixpanel, use one of the high‑volume export options rather than UI CSV export:

1. Raw Event Export API (all plans, no extra cost) Use the Raw Event Export API, which returns events as JSONL (one JSON object per line) and is designed for large volumes. [Export methods; Export API spec]

Basic example:

Key points: - from_date / to_date are required (YYYY-MM-DD). - Optional filters: event (JSON array of event names), where (expression), limit (max 100,000). [Export API spec] - Response is JSONL, suitable for streaming/processing large files. [Export methods] - Rate limits: 60 queries/hour, 3 queries/second, max 100 concurrent queries. [Export API spec]

2. Mixpanel-utils helper (Python) The open-source mixpanel-utils module wraps the Export API and can write large exports directly to a file. [mixpanel-utils README]

Example:

This uses the raw export endpoint and handles writing to disk, gzip options, etc. [mixpanel-utils README]

3. Data Pipelines (Growth/Enterprise add‑on) If you need continuous, automated export of all events (not just a one‑off), enable Data Pipelines to send data to cloud storage (S3, GCS, Azure Blob) or a warehouse (BigQuery, Snowflake, Redshift). [Data Pipelines overview] - JSON Pipelines export events as JSON files to storage, partitioned by date. [Data Pipelines overview] - Best if you want ongoing sync rather than manual pulls.

4. UI CSV export (for smaller slices)

From the Events tab you can export visible events as CSV, but this is intended for smaller batches and is limited by what’s loaded in the table, not ideal for “thousands+” across long ranges. [Export methods]

If you describe your volume (e.g., date range and approximate event count) and destination (file vs warehouse), I can suggest the most appropriate of these and a more specific call.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

To export ~10k events into a file, the most straightforward options are:

This API is designed for high‑volume exports and returns JSONL (one JSON object per line). [Export methods; Raw export spec]

Basic cURL example (writes to a file):

```

curl --request GET --url 'https://data.mixpanel.com/api/2.0/export?from_date=2024-01-01&to_date=2024-01-02&limit=10000' --header 'accept: text/plain' --header 'authorization: Basic YOUR_AUTH' -o events.jsonl

---

If you prefer Python, mixpanel-utils can call the Export API and write directly to a file. [mixpanel-utils README]

```

from mixpanel_utils import MixpanelUtils

mputils = MixpanelUtils( 'ServiceAccountSecretHere', token='ProjectTokenHere', service_account_username='my-user.12345.mp-service-account', project_id=123456, )

mputils.export_events( 'events_10k.json', {'from_date': '2024-01-01', 'to_date': '2024-01-02', 'limit': 10000} )

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.