Join the AMA (Ask Me Anything) with the Firefox leadership team to celebrate Firefox 20th anniversary and discuss Firefox’s future on Mozilla Connect. Mark your calendar on Thursday, November 14, 18:00 - 20:00 UTC!

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.

Importing cvs file errors

  • 3 replies
  • 1 has this problem
  • 7 views
  • Last reply by Matt

Pete
Pete
more options

Trying to import an AT&T/yahoo address book file into Thunderbird. I cleaned it up in Excel 2010, and saved the file in .csv format.

I aligned the fields correctly in T'Bird.

When I import, the first and last name fields are dropped and the first part of the email address appears as the Name. Appreciate any help - I have done this before with no problems, now ??? I tried tab delimited files with the same errror.

Trying to import an AT&T/yahoo address book file into Thunderbird. I cleaned it up in Excel 2010, and saved the file in .csv format. I aligned the fields correctly in T'Bird. '''When I import, the first and last name fields are dropped and the first part of the email address appears as the Name. ''' Appreciate any help - I have done this before with no problems, now ??? I tried tab delimited files with the same errror.

All Replies (3)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

It might be excel is the problem. It was for me so I switched to libreoffice.

https://thunderbirdtweaks.blogspot.com/2013/03/importing-csv-files.html

It might be that yahoo like Microsoft livemail has more fields than Thunderbird can cope with. (56 IIRC)

Pete
Pete Question owner
more options

Thanks.

After spending a lot more time on this, I found that Thunderbird does import correctly, as determined by going to the individual person's record, however the display that appears when you look at the address book list in Thunderbird shows the first part of the email address (before the @) under name! It doesn't show the other relevant fields so I didn't catch the error. <:(

See image attached, if anyone is interested.

If you add a name manually, it does the same thing.

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

The field displayed in the display name. While someone at some time has placed the list label of name on it, it is display name.