# Can I do an Export via CSV where the Owner is attached as well

**URL:** <https://forum.mautic.org/t/can-i-do-an-export-via-csv-where-the-owner-is-attached-as-well/26012>\
**Category:** Product Support\
**Created:** [November 10, 2022, 11:03am UTC](https://forum.mautic.org/t/can-i-do-an-export-via-csv-where-the-owner-is-attached-as-well/26012 "2022-11-10T11:03:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fabienne](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/fabienne/32/6256_2.png) [@fabienne](https://forum.mautic.org/u/fabienne)\
**Post date:** [November 10, 2022, 11:03am UTC](https://forum.mautic.org/t/can-i-do-an-export-via-csv-where-the-owner-is-attached-as-well/26012/1 "2022-11-10T11:03:12Z")

</div>

Can I make an export via CSV from Mautic where the owner also comes along?

Thanks for your help.

---

<div class="post-metadata">

**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\
**Post date:** [November 10, 2022, 6:18pm UTC](https://forum.mautic.org/t/can-i-do-an-export-via-csv-where-the-owner-is-attached-as-well/26012/2 "2022-11-10T18:18:23Z")

</div>

By default it appears it does not include the owner.

You can easily export it with SQL:

```auto
 SELECT l.id, l.email, l.firstname, l.lastname, l.owner_id, CONCAT(u.first_name, ' ', u.last_name) AS ownerName 
FROM leads l LEFT JOIN users u ON (l.owner_id = u.id);

```

You can use tool like phpmyadmin to export query result (or use the command line to export ).

Regards, M.