Export Contact Lists from Thunderbird


  1. Open Thunderbird and choose Address Book.
  2. In the Address Book window, select Tools, then Export.
  3. Enter a file name and select Comma Separated (UTF-8) from the Save as type and then click Save. Do the same for all the address books you have (if you have multiple address books).
  4. Open Excel, go to Open Other Workbooks, and double-click this PC.
  5. In the Open window, change All Excel Files to All Files. Select the file you previous exported in step 3.
  6. The file should open as a spreadsheet. Look for the following column headers in the first row of the spreadsheet and change the respective column headers to:
    • Change Display Name to Display As
    • Change Primary Email to Email
    • Change Secondary Email to Email 2
    • Change Work Phone to Business Phone
    • Change Work Address to Business Street
    • Change Work City to Business City
    • Change Work State to Business State/Province
    • Change Work Zipcode to  Business ZIP/Postal Code
    • Change Work Country to  Business Country/Region
    • Change Home Address to Home Street
    • Change Home State to Home State/Province
    • Change Home Zipcode to Home ZIP/Postal Code
    • Change Home Country to Home Country/Region
  7. In Excel go to File > Save As. Click Save. You will be asked to Confirm Save As. Click Yes.
  8. You will get a pop-up stating that some features in your workbook might be lost if you save it as CSV (Comma delimited) and asking if you want to keep using that format. Click Yes.
  9. Follow steps 4 - 8 for any other address books you have.
Last update:
2019-02-12 10:24
Author:
Amanda Wagner
Revision:
1.1
Average rating:0 (0 Votes)

You can comment this FAQ

Most popular FAQs RSS

  1. Configure Mac Mail 10 for UTORexchange (393527 views)
  2. Wireless Access (247419 views)
  3. UTmail+ (194485 views)
  4. Student Advantage and Office 365 ProPlus (167641 views)
  5. UTORmail: Webmail (130009 views)
  6. UTORexchange (122471 views)
  7. Avoiding Email Fraud (118548 views)
  8. UTORmail (115875 views)
  9. Overview of Email Services (115034 views)
  10. Accounts and Passwords (102214 views)

Latest FAQs RSS

  1. Moving data off UTORmail or UTORexchange (2019-08-22 10:47)
  2. Reducing the amount of SPAM you receive (2019-08-21 10:09)
  3. SPAM and Junk Email Blocking (2019-08-21 10:06)
  4. Using Message Reporting and Safe Senders List to ensure ... (2019-08-21 09:49)
  5. UTORprotect (2019-08-21 09:43)