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

Ova tema je arhivirana. Pitajte drugo pitanje ako vam je potrebna pomoć.

How do I import a CSV file into the Address Book?

  • 1 odgovor
  • 5 ima ovaj problem
  • 1 view
  • Posljednji odgovor poslao Matt

Rick Mild
Rick Mild
more options

I've created an Excel 2013 worksheet with 3 columns (FirstName, LastName, and EmailAddress), and 1 row for each addressee. The first row contains the field names. I saved the worksheet as a CSV file. But when I import the CSV file into Thunderbird TB ignores the FirstName and LastName and parses the characters to the left of the "@" in the EmailAddress as the "Name" and the domain name (after the "@") as the email address. What am I doing wrong?

I've created an Excel 2013 worksheet with 3 columns (FirstName, LastName, and EmailAddress), and 1 row for each addressee. The first row contains the field names. I saved the worksheet as a CSV file. But when I import the CSV file into Thunderbird TB ignores the FirstName and LastName and parses the characters to the left of the "@" in the EmailAddress as the "Name" and the domain name (after the "@") as the email address. What am I doing wrong?

All Replies (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

Excel appears incapable of creating a Unicode text file. Open your CSV in notepad and using save as explicitly select a Unicode/UTF encoding format.