Important Notice: We're experiencing email notification issues. If you've posted a question in the community forums recently, please check your profile manually for responses while we're working to fix this.

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

Thread ini telah diarkib. Sila tanya soalan baru jika anda perlu bantuan.

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

  • 1 balasan
  • 5 ada masalah ini
  • 4 paparan
  • Balasan terakhir oleh 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.