Avatar for Username

搜尋 Mozilla 技術支援網站

防止技術支援詐騙。我們絕對不會要求您撥打電話或發送簡訊，或是提供個人資訊。請用「回報濫用」功能回報可疑的行為。

Learn More

此討論串已被封存。 如果您有需要幫助，請新增一個新問題

Importing contacts gone wrong !

  • 1 回覆
  • 1 有這個問題
  • 27 次檢視
  • 最近回覆由 Matt

John
John
more options

I tried to import contacts from a .csv file asking for First name, Last name and email. Only the email addresses imported, no names, and addresses have gone in the name field ! And it has created a new address book with the name of the .csv file which I didn't ask for. What am I doing wrong please? I noticed when converting my Excel list to .csv that there are several versions of .csv file. So which is the correct one to use for this purpose? Thanks for any advice.

I tried to import contacts from a .csv file asking for First name, Last name and email. Only the email addresses imported, no names, and addresses have gone in the name field ! And it has created a new address book with the name of the .csv file which I didn't ask for. What am I doing wrong please? I noticed when converting my Excel list to .csv that there are several versions of .csv file. So which is the correct one to use for this purpose? Thanks for any advice.

所有回覆 (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

The issue will probably be Excel. It still to the best of my knowledge uses ANSI text and balks at unicode offering to "import" it.

Open your CSV in windows notepad and use file save as to set the text to unicode in the file save as dialog. Also be sure the headings align in the import. Some years ago I wrote a blog post in importing CSV files. While much has changes in the intervening years, things like matching headings in the CSV to the import fields in Thunderbird are still relevant. https://thunderbirdtweaks.blogspot.com/2013/03/importing-csv-files.html