You export from The address book as CSV and import to other applications such as spread sheets.

for mailing lists see http://kb.mozillazine.org/Thunderbird_:_FAQs_:_Create_Mailing_List

This add-on can be helpful. https://nic-nac-project.org/~kaosmos/index-en.html#eac

Install MoreFunctionsForAddressBook, then right-click a recipient in the Header Pane of a sent message and save all the recipients to a mailing list or address book (see picture).

http://chrisramsden.vfast.co.uk/3_How_to_install_Add-ons_in_Thunderbird.html

A Mailing List is a sub list of an address book An address book can have more than one Mailing List..

Any contact in an address book which has a valid email address, can be placed in a Mailing List.

download this addon: https://nic-nac-project.org/~kaosmos/morecols-en.html

install addon info: https://support.mozilla.org/en-US/kb/add-ons-and-extensions-faq?esab=a&s=insyall+addon&r=0&as=s#w_how-do-i-install-an-add-on

Then in the header of an email you sent where it says TO and lists the contacts. click on one of those email address/contact name and from the drop down selection choose: 'SAve recipients addresses' > 'as list(all)'

A pop up appears with all the names listed make sure you have selected the correct address book under which the list will appear. give the list a name click on OK

You should then see a sub list under the selected address book in 'Address Book'.

You can save any address book. Select the address book Tools > Export

choose where to save Give filename Save as type 'comma separated .csv click on Save,

This csv file can be opened by Excel