Export Mixpanel people properties to an Excel Compatible CSV
A bookmarklet that exports an Excel compatible CSV of the first 1000 people (with all their properties) from Mixpanel > People > Explore
.
- Create a favorite
- Change the favorite URL with
bookmarklet.js
content - Save it
- Open Mixpanel
- Click on Explore
- Click on the favorite
- Enjoy
Tested in Chrome 31+.
Bookmarklet.js content
javascript:!{var a=/report\/\//1{return-1===a}{return"https://mixpanel.com/report/"+a+"/explore/#user?distinct_id="+b}{var a=mpreportexploremodelsrecords;return _}{return b=b||DATAa=a||{return!0}b}{return a}{return"number"==typeof a?a:'"'++'"'}{b=b||DATA;var c=b;returna}{return b=b||ga}{return a}k=l=;window};
Options
- Change the
filterCol
function body to filter columns based on their names.
Troubleshooting
- Check you allowed popup in Mixpanel.
- Open the JavaScript console to investigate where the issue could be.