• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Outlook 2016 CSV Translator Import Error

tmc

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
#1
While trying to import a .csv contact list into an outlook contact folder, I receive the following error message:

outlook error.PNG


I have already reviewed the online Microsoft help files, no joy. The .csv is in the correct format, was created with Excel, is not in use by another application and I have all the applicable permissions. I am scratching my head as to where the problem might be. I have also gone to another system and have attempted the import from there, same error message. Has there been a significant change to file mapping?

I am stumped! Any help would be greatly appreciated. - Terri
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#2
Try this from an old article I recently deleted as obsolete. Might need to restore it.. :)

>>>
This is the result of the exported file's Unicode encoding. When the CSV is opened in Excel, all of the comma-separated fields are shown in one cell, not one cell per field. Excel can’t detect the field separators and neither can Outlook.

If you open the file in Excel to look at it, close it without saving.

Solution: Save the CSV with ANSI format selected. Open the CSV file in Notepad and use File, Save as then select ANSI from the Encoding dropdown and Save using the existing file name.
>>>
 

tmc

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
#3
Try this from an old article I recently deleted as obsolete. Might need to restore it.. :)

>>>
This is the result of the exported file's Unicode encoding. When the CSV is opened in Excel, all of the comma-separated fields are shown in one cell, not one cell per field. Excel can’t detect the field separators and neither can Outlook.

If you open the file in Excel to look at it, close it without saving.

Solution: Save the CSV with ANSI format selected. Open the CSV file in Notepad and use File, Save as then select ANSI from the Encoding dropdown and Save using the existing file name.
>>>
I reviewed and tried this as well, before posting :). This does not appear to be the issue. I am absolutely clueless at this point.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#4
Can you either upload it here as an attachment or email it to me at Diane at slipstick? I’ll take a look at it.
 

Similar threads