# Export leads and leads data **URL:** \ **Category:** General Discussion\ **Created:** [May 18, 2016, 9:32pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813 "2016-05-18T21:32:41Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\ **Post date:** [May 18, 2016, 9:32pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/1 "2016-05-18T21:32:41Z")
We are trying to figure out how to export leads and ALL data from the leads fields. We have crated many custom fields and cannot figure out how to export a Leads List and all of the leads data… How can we export a specific leads list to CSV and to include all fields that have data including the custom fields we have created? ---
**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\ **Post date:** [May 18, 2016, 9:32pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/2 "2016-05-18T21:32:41Z")
We are trying to figure out how to export leads and ALL data from the leads fields. We have crated many custom fields and cannot figure out how to export a Leads List and all of the leads data… How can we export a specific leads list to CSV and to include all fields that have data including the custom fields we have created? ---
**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\ **Post date:** [May 19, 2016, 7:18am UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/3 "2016-05-19T07:18:33Z")
Try the export in the Report section ---
**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\ **Post date:** [May 19, 2016, 4:43pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/4 "2016-05-19T16:43:17Z")
I viewed the reports section. However that does not seem to help… We want to export the leads that filled out “form A” and we want to export ALL fields that have data for each lead… I do not see how this is achievable in the reports section… Can you please offer further advice? ---
**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\ **Post date:** [May 19, 2016, 9:51pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/5 "2016-05-19T21:51:38Z")
Additional question related to this: How do we export a lead including all of their data? We would like to export and print a “lead profile” that includes ALL data fields for the lead including the fields in the personal, professional, core, and social tabs. ---
**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\ **Post date:** [May 21, 2016, 6:54pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/6 "2016-05-21T18:54:48Z")
@kuzmany Maybe I am overlooking how to do this within Report section… Could you please provide any more detail on how to create such a report? ---
**Author:** ![marzio](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@marzio](https://forum.mautic.org/u/marzio)\ **Post date:** [May 23, 2016, 7:04am UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/7 "2016-05-23T07:04:13Z")
Thanks, very useful. There should be more videos like this to truly unlock the mautic full potential. ---
**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\ **Post date:** [June 1, 2016, 2:40pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/8 "2016-06-01T14:40:03Z")
This does not accomplish what I have asked… 1. How can we export a “leads list” into CSV including every single data field from their profile including the Core, Professional, Social, and other custom fields we created? 2. How can export one specific leads profile including Core, Professional, Social, and other custom fields we created? ---
**Author:** ![jwldub](https://avatars.discourse-cdn.com/v4/letter/j/5fc32e/32.png) [@jwldub](https://forum.mautic.org/u/jwldub)\ **Post date:** [June 3, 2016, 1:07am UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/9 "2016-06-03T01:07:05Z")
Any advise here? ---
**Author:** ![levor](https://avatars.discourse-cdn.com/v4/letter/l/dfb087/32.png) [@levor](https://forum.mautic.org/u/levor)\ **Post date:** [September 29, 2016, 10:10pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/10 "2016-09-29T22:10:41Z")
You can use phpMyAdmin in your cPanel to manage all your databases. Search for the leads table. You can export from there in several formats. ---
**Author:** ![lwdeddie](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/lwdeddie/32/755_2.png) [@lwdeddie](https://forum.mautic.org/u/lwdeddie)\ **Post date:** [October 5, 2016, 2:29pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/11 "2016-10-05T14:29:29Z")
@jwldub , @levor is correct. Use a tool (phpMyAdmin, Sequel Pro, etc) to export directly from the proper table in the DB. ---
**Author:** ![chinonet](https://avatars.discourse-cdn.com/v4/letter/c/cdc98d/32.png) [@chinonet](https://forum.mautic.org/u/chinonet)\ **Post date:** [October 23, 2016, 8:01am UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/12 "2016-10-23T08:01:11Z")
why no one give a real answers?? Everyday i regrets more for using mautic. No help, and basic features dont work. I not a programer but i need to export the lead because mautic not working. So many problem i need to use other app Here, u can export the lead SELECT leads.id , leads.date\_added, leads.firstname, leads.email, lead\_lists\_leads.leadlist\_id, leads.last\_active, leads.city, leads.country, leads.state FROM leads, lead\_lists\_leads WHERE leads.id = lead\_lists\_leads.lead\_id AND lead\_lists\_leads.leadlist\_id =1 LIMIT 0 , 10000 Use that query and select export in the botton of the page or copy the table, change the list in leads.leadlist\_id =1 ---
**Author:** ![gigcity](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gigcity/32/104_2.png) [@gigcity](https://forum.mautic.org/u/gigcity)\ **Post date:** [April 20, 2017, 3:45am UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/13 "2017-04-20T03:45:05Z")
As already mentioned, the report export doesn’t really address the needs of the OP. For example, that report export doesn’t include ‘Do Not Contact’ information. Here’s another user scenario – why this is important. For those of us with ‘hosed’ Mautic instances (related to recent challenges around upgrades), we need a method of exporting all leads (and need as much information as possible) via the GUI - and this should spit out a csv. This is the only way that we can cleanly export data and cleanly reimport into a new instance. For myself, I’m fairly positive that my database schema is not correct and was broken during my 7-month journey from version 2.1.1 to 2.7.1. The ONLY way that I can be confident of a clean stable 2.7.1 version is to completely avoid a sql dump using phpmyadmin. Any reimport using that method assumes that my existing db and the a clean db actually match. Bottomline: We need a method to easily export all data related to a lead using the GUI. Ideally, we should be able to similarly export Component, Campaign, and Channel data. ---
**Author:** ![theatereleven](https://avatars.discourse-cdn.com/v4/letter/t/85e7bf/32.png) [@theatereleven](https://forum.mautic.org/u/theatereleven)\ **Post date:** [August 16, 2017, 12:50am UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/14 "2017-08-16T00:50:17Z")
Chiming in on this: I’m in a situation where the Mautic upgrade even from command line fails. So I’m screwed - just had to restore my entire web server to dial things back. I need a way to export the user data out of Mautic, and use it to then import into a clean install. Even MailChimp can export to CSV. Surely there’s a way? ---
**Author:** ![tuiuiu\_dev](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/tuiuiu_dev/32/225_2.png) [@tuiuiu\_dev](https://forum.mautic.org/u/tuiuiu_dev)\ **Post date:** [September 28, 2017, 8:26pm UTC](https://forum.mautic.org/t/export-leads-and-leads-data/3813/15 "2017-09-28T20:26:05Z")
Hi there everyone. How are you? I am sorry about my english. I have found a big trouble and time consuming to Export leads and all leads data asked on a form. I have tried many methods, and even: [https://www.mautic.org/community/index.php/member/3082-chinonet](https://www.mautic.org/community/index.php/member/3082-chinonet) But, what finally worked for me was accessing DataBase by MySQL and exporting the whole “table=form\_results” There will be for each FORM one table=form\_result Just pick one you need to export and be happy! Best regards.