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

This thread was archived. Please ask a new question if you need help.

Import address book from csv file

  • 1 jibu
  • 2 wana tatizo hili
  • 1 view
  • Last reply by Matt

adrian_y
adrian_y
more options

Converted my outlook address book to a csv file, but when I import it into firefox the entries are not the same as the file. names and email addresses are no longer matched. I have about 1800 addresses and do not want to manually enter these again.

Converted my outlook address book to a csv file, but when I import it into firefox the entries are not the same as the file. names and email addresses are no longer matched. I have about 1800 addresses and do not want to manually enter these again.

All Replies (1)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

I suggest you examine the CSV for poorly encoded strings like Mike,McEvoy which can turn nicely formatted CSV files into a mess because if the stay commas.

You might try opening the file in LibreOffice's calc and seeing it there are stray commas in what imports. I do not recommend using Excel as it makes a total hash of Unicode text. Requiring extra steps to import the data and export it again in a format other unicode programs can read. Sad really. But the demise of excel may be in it's inability to cope with unicode.