Avatar for Username

Cari Bantuan

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.

Pelajari Lebih Lanjut

Utas ini telah diarsipkan. Silakan membuat pertanyaan baru jika Anda membutuhkan bantuan.

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

  • 1 balas
  • 5 memiliki masalah ini
  • 1 kunjungan
  • 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?

Semua Balasan (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.