How do I import a CSV file into the Address Book?
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?
Alla svar (1)
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.