You may export a list of all tenants and prospects on the system in CSV format from the Tenants > List Tenants menu. On this page, select Options > Export (CSV).
The exported result set will reflect those returned by the status filter, e.g. if the status filter is set to Current and Future it will only return those current and future tenants, so it may be necessary to set the filter to show All Tenants and Prospects before exporting.
This CSV file may then be processed as you wish using Microsoft Excel.