Avatar for Username

Søg i 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.

Læs mere

Denne tråd blev arkiveret. Stil et nyt spørgsmål, hvis du har brug for hjælp.

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

  • 1 svar
  • 5 har dette problem
  • 4 visninger
  • Seneste svar af 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?

Alle svar (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.