Export People Profiles to CSV

People profiles can be exported through the Mixpanel UI or alternatively by either a JQL Query or a Python script.

The ability to export to CSV is available on paid plans - visit the pricing page for more information or to upgrade.

Export People Profiles in Mixpanel

To export your people profiles from Explore, simply click the export icon at the top of the list. This will export all of your people profiles. You can choose to filter the list or select individual profiles to export instead of exporting the full list. A link to download the file will be emailed to the email associated with the project. To access this file, enter your API Secret as the password.


Export People Profiles with JQL

Note that exports using JQL are limited to 2GB, so if you run into issues exporting, try the steps below for the Python script instead, which can handle any size export.

In your Mixpanel project, click on Applications > JQL > Build your own, and remove any pre-populated code that appears.

Then, enter the following query > RUN QUERY, then Export to CSV*:

function main() {
  return People()

Learn more about the power of JQL.

Export People Profiles with a Python Script

People profiles can be exported through the Mixpanel API. One way to request and execute the export is through a simple Python script. Use the Mixpanel_api repository and reference the export section to find the necessary functions. In order to obtain all of the necessary components of the script:

1. Collect your API credentials by clicking on your initials in the top right of Mixpanel and selecting Profile & Preferences under ACCOUNT SETTINGS.


Under the Projects tab you can view your API credentials for each project.

2. If you are exporting all of your users, you can ignore cohort parameters. However, if you want to export a subset of users, you'll want grab these two parameters. In order to do this:

  • Go to the "Explore" tab and select the subset of users you would like to export using people properties and/or events.
  • Open Developer Tools and bring focus to the console (On Chrome for Mac: command + option + "J" & on Chrome Windows: control + shift + "J").
  • Refresh the page.
  • From the console, select the Network tab, select XHR, find the "engage" request in the "Name" column, and then select Headers.


  • Find the 'filter_by_cohort' value.
  • Copy and paste the 'filter_by_cohort' value into the script to target only users in the Explore report.
  • Save the document.

The following code sample is from mixpanel_api import Mixpanel:

filter_by_cohort = ''
{'filter_by_cohort' : filter_by_cohort})

3. Execute the script to pull these people profiles into a new JSON file. If you would like this in CSV format, you will want to add the parameter "format = 'CSV'". On a PC, simply open up the script with Python 2.7 to execute it. On a Mac, open up your Terminal and follow the steps below:



The exported file will now be in the same location as the python script, and will include the epoch time stamp for when the export was performed.

Is this article helpful?
6 out of 26 found this helpful



Article is closed for comments.