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.

Can't import address-book .csv exported from GoDaddy email

  • 8 majibu
  • 6 wana tatizo hili
  • 6 views
  • Last reply by Snowbound1

DBHa
DBHa
more options

I export my address book from godaddy hosted e-mail to a csv file. The csv file opens correction in excel. I go to TB, open the address book - tools - import, choose addresses, choose csv file In the pop-up window, I switch to search for csv and find my file and select it. I set up the correct column names (or as close as I can) and uncheck the unused ones. I try to import - it says there's an error and not all contacts have been imported. In actuality, NONE have been imported - I have a new empty address book. NB: Some of the addresses are in Russian, they're actually incorrectly rendered in excel. I might try changing the encoding in excel and re-saving ...but why would that stop TB from importing them as-is? Or from importing ANY of them, for that matter, including those in English?

I export my address book from godaddy hosted e-mail to a csv file. The csv file opens correction in excel. I go to TB, open the address book - tools - import, choose addresses, choose csv file In the pop-up window, I switch to search for csv and find my file and select it. I set up the correct column names (or as close as I can) and uncheck the unused ones. I try to import - it says there's an error and not all contacts have been imported. In actuality, NONE have been imported - I have a new empty address book. NB: Some of the addresses are in Russian, they're actually incorrectly rendered in excel. I might try changing the encoding in excel and re-saving ...but why would that stop TB from importing them as-is? Or from importing ANY of them, for that matter, including those in English?

All Replies (8)

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

I has someone report, today actually, that they had needed to set the encoding to UTF-8 to get the import to work. Their spreadsheet apparently used something else. Once that was done, no issues.

As an aside, Do an address book export from Thunderbird as CSV format.

Using that as a guide change the column titles in the spreadsheet to match, both in names and order. It is much easier than poking around in that horrible little selector the import offers. I discuss using libre office spread sheet on CSV files here. If it is any help.

DBHa
DBHa Mwenye swali
more options

Thanks much! Unfortunately, not solved quite yet. I figured out how to change encoding, but it's one of those situations where I can see that NO available encoding properly displays the original cyrillic , it's always gobbledygook. I reordered the columns in excel, used UTF-8 and exported it as .csv, but it still doesn't import. What do you think?

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

I think that unless it is a national secret or all your mistresses email addresses you might send me the file and I can have a look at it.

Email address unicorn dot consulting at gmail dot com.

Snowbound1
Snowbound1
more options

I have this same problem. I just posted a question. How do I change the encoding to UTF - 8?

Snowbound1
Snowbound1
more options

Hi again,

Have find out how to save as UTF 8 but like DBHa I still cannot import the file!

Would it be possible to e-mail you my file as well?

Thanks! Roxanne

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

Sure, I do not recall the OP actually sent me anything. If they are still waiting for a reply I think they need to speak up.

Snowbound1
Snowbound1
more options

HI,

Thanks very much! I hope it's safe to send to you???!!

I know you provided an e-mail address but can I just attach it on here? And is excel file o.k.

I am working on cleaning it up and found it easier in excel than CSV.

Roxanne

Snowbound1
Snowbound1
more options

Hi,

Can't load it up on here so I've tried to e-mail you the report. Please let me know if you have received it.

I am so behind on sending out the newsletter..................

Thanks! Roxanne