This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn't solve your issue and you want to ask a question, we have our support community waiting to help you at @FirefoxSupport on Twitter and/r/firefox on Reddit.

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

This thread was archived. Please ask a new question if you need help.

Cant import csv address book correctly

  • 1 reply
  • 1 has this problem
  • 1 view
  • Last reply by sfhowes

CK_Berg
CK_Berg
more options

We are replacing/upgrading from a Windows Vista to Window 10 machine.

I exported the address book in CSV format to an excel file and saved it on a thumb drive.

When I try and import the address book to Thunderbird the names/emails/columns are pretty messed up. Can you explain to me what the "1st record" screen is about. I don't understand the whole move up/move down instructions. If I try and compose an email now the zip code is attached to the email address and the email won't send.

Any explanations would be appreciated. Thanks!

We are replacing/upgrading from a Windows Vista to Window 10 machine. I exported the address book in CSV format to an excel file and saved it on a thumb drive. When I try and import the address book to Thunderbird the names/emails/columns are pretty messed up. Can you explain to me what the "1st record" screen is about. I don't understand the whole move up/move down instructions. If I try and compose an email now the zip code is attached to the email address and the email won't send. Any explanations would be appreciated. Thanks!

All Replies (1)

sfhowes
sfhowes
  • Top 10 Contributor
more options

You need to open the csv file in Excel and organize the columns so they match the structure of the TB address book. The columns should be named as described here:

http://kb.mozillazine.org/Import_address_list_from_text_file

You may only need the first 10 or so columns, and if there are no entries for one, e.g. Nickname, leave the column blank. Then, when you import to TB, it should be easy to line up the imported records with the TB address book fields.

https://support.mozilla.org/en-US/questions/1012084#answer-607601