# Create customer list

**URL:** <https://forum.manager.io/t/create-customer-list/44003>\
**Category:** Uncategorized\
**Created:** [November 11, 2022, 2:15pm UTC](https://forum.manager.io/t/create-customer-list/44003 "2022-11-11T14:15:03Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mutt8449](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@Mutt8449](https://forum.manager.io/u/Mutt8449)\
**Post date:** [November 11, 2022, 2:15pm UTC](https://forum.manager.io/t/create-customer-list/44003/1 "2022-11-11T14:15:03Z")

</div>

I’d like to create a customer list with names, invoice address, e-mail and telephone (a custom field). But when I create a custom report (settings see attached), I get a report with many blank lines first, and then many lines per customer but many times repeated. Obviously I want unique lines per customer.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/2/a2c114208eece371c1053dd6714b00bf1230dbc6.png)

Alternatively, an Excel export would also work but I don’t see how.

Can someone help me out?

Many thanks, Jan

---

<div class="post-metadata">

**Author:** ![GrahamvdR](https://avatars.discourse-cdn.com/v4/letter/g/51bf81/32.png) [@GrahamvdR](https://forum.manager.io/u/GrahamvdR)\
**Post date:** [November 11, 2022, 2:32pm UTC](https://forum.manager.io/t/create-customer-list/44003/2 "2022-11-11T14:32:36Z")

</div>

1. Make sure that any custom fields that you want to include are set to `Show custom field as a column`:  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/e/beee6ad3020ec5b16d4e52b8efe6bd1abcf9228d.png)

2. Go to the `Customers` tab. Scroll down to the bottom and select the option to show all the records:  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/b/5b23c6140390212b6d95051f3a7b263e0761f8b3.png)

3. From the bottom of the customer listing, click `Copy to clipboard`.

4. Paste the data in your application of choice and delete any columns that you don’t need.

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [November 11, 2022, 3:16pm UTC](https://forum.manager.io/t/create-customer-list/44003/3 "2022-11-11T15:16:58Z")

</div>

Only customers who have had a transaction will appear in a custom report - custom reports use the transaction data

Exporting the customer information using batch update might be a better option

---

<div class="post-metadata">

**Author:** ![Mutt8449](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@Mutt8449](https://forum.manager.io/u/Mutt8449)\
**Post date:** [November 11, 2022, 4:21pm UTC](https://forum.manager.io/t/create-customer-list/44003/4 "2022-11-11T16:21:53Z")

</div>

Thanks Joe and Graham,  
Copy from the customer list to excel is then the best option. But how can I have the invoice address show in the customer list view? It only shows Name, E-mail address and some custom fields I created.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [November 11, 2022, 6:05pm UTC](https://forum.manager.io/t/create-customer-list/44003/5 "2022-11-11T18:05:15Z")

</div>

The Batch Update file you copy will show the entire record.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [July 5, 2026, 8:09pm UTC](https://forum.manager.io/t/create-customer-list/44003/6 "2026-07-05T20:09:38Z")

</div>

Uncategorized topics older than 3 years with no recent activity