Export Methods: Export raw data and reports from Mixpanel

Overview

This page provides a high-level overview of your options for exporting event data, profile data, and formatted report data.

You can export data from your project using a variety of methods, including lightweight CSVs generated from the UI, large volume raw data export from our APIs, and data syncs to external destinations through Cohort Syncs and Data Pipelines.

For GDPR/CCPA-compliant exports, please see the End User Data Management page.

Exporting Events

Event Export via API

The from_date and to_date params are interpreted using UTC timezones. For projects created before 1 January 2023, the from_date and to_date params are interpreted using your current project timezone.

To export raw event data, use the Raw Event Export API. The events payload is returned as JSONL, where each line is a valid JSON object. This method is recommended for high volume exports.

Example request:

# Returning "sample_event" from 2024-07-23 to 2024-07-24
curl --request GET \
     --url 'https://data.mixpanel.com/api/2.0/export?from_date=2024-07-23&to_date=2024-07-24&limit=100&event=sample_event' \
     --header 'accept: text/plain' \
     --header 'authorization: Basic YOUR_TOKEN’

Example payload:

# The entire payload is a JSONL
# Each line of event is a JSON object
{"event":"Signed up","properties":{"time":1602611311,"$insert_id":"ABCDE","mp_processing_time_ms":1602625711874}}
{"event":"Signed up","properties":{"time":1602787121,"$insert_id":"ABCDE","mp_processing_time_ms":1602801521561}}

The exported payloads are raw events, containing timestamps as they are stored in your project. For projects created before 1 Jan 2023, your event timestamp is stored in your local project timezone at the time of ingestion. For projects created after 1 Jan 2023, your event timestamp is stored in UTC timezone. Learn more about managing your project timezone here.

CSV Events Export

Only the events visible in the Events table at the time of your export will be included in the CSV. Scroll down and click “Load More” to make more events visible.

You may export small batches of events as a CSV for use in quick analysis by navigating to the Events tab, querying the events that you are interested in seeing, then clicking the “Export” button in the top right corner.

By default, only the columns that are shown in the UI will be exported. You can click the “Edit Columns” button to modify the properties columns shown in the Events table.

Select the option to include “All event properties” if you are interested in all of the event properties.