Log into QuickBooks Desktop
In QuickBooks Desktop, you will select the drop-down from the top menu that says Customers and then Customer Center.
Select Excel and the Export Customer List.
The pop-up will show modifications that you can select. For this purpose, simply select Export.
Once you have completed these steps, you will have an Excel document you can share that lists all the information you have for the customers/tenants set up in your QuickBooks Desktop account.