Outlook 2016 CSV Translator Import Error

Status
Not open for further replies.

tmc

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
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
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
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
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.
 

stgmike

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
I am having the exact same issue. Attached is my CSV file. It came from the new Google Contacts, exported as Outlook CSV file, as opposed to Google CSV file. Same error and same prob as TMC. Help!!!

I have tried on Win 10, OL 2016 (64-bit) and Mac Outlook 2016.

It open as many columns in excel, but saving is bak as a CSV in Excel did not help.

Saving in Notepad as ANSI encoding did not help!

What is the next step?
How will I know when this thread is updated?

stgmike 07-11-2019
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You should get an email when there is a reply. I'm going to remove the attachment since it appears to have your valid contacts in it. I have a copy for testing with here.
 

Kinsch

New Member
Outlook version
Outlook 2016 32 bit
Email Account
Exchange Server
I had the same problem. I had saved my gmail contacts to a .csv file. Tried to save these contacts to Outlook for my new company. Same error message. Help at Microsoft was a dead end. I then opened the same .csv and saved it as a CSV UTF-8 (comma delimited) .csv. It worked! I am not smarter.....just lucky on this one.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
S Outlook (2016 32bit; Gmail IMAP) - Save sent message to Outllook Folder Outlook VBA and Custom Forms 0
A Backup Email Accounts On OutLook For Mac 2016 (Microsoft 365 subscription version) Using Outlook 0
M Office 2016 Outlook is forgetting passwords Using Outlook 15
E Can one still buy Outlook (or Office) 2016? Using Outlook 6
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
R seperate read layout to design in outlook 2016..Help!! Outlook VBA and Custom Forms 3
GregS Why is Outlook 2016 mail in Outlook.com? Using Outlook 1
G Recurring tasks break links Outlook 2016 Using Outlook 5
A How to get body of all emails in outlook 2016 to view in blue color Using Outlook 1
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
D iCloud Add-in not working in Outlook 2013 and Outlook 2016 After Windows Upgrade & iCloud Upgrade Using Outlook 2
GregS Outlook 2016 iPhone won't download Outlook 2016 Mail. Using Outlook 0
E How to display "Change Folder" in Change Default Email Delivery Location in Exchange Outlook 2016 Using Outlook 1
A How to open a specific link automatically with outlook 2016 Outlook VBA and Custom Forms 5
V Outlook 2016 will not move emails in search results Using Outlook 4
K Using Outlook 2016 to draw Using Outlook 1
M Outlook 2016 Free/Busy settings ignored Using Outlook 0
K Outlook 2016 - controlling IMAP OST size with Group Policy not working Using Outlook 1
C Outlook 2016/2019 hangs after being open for an extended period Using Outlook 4
GregS 2016 Contact List being managed by Outlook.com? Using Outlook 1
A Outlook 2016 in Cached Mode Using Outlook 1
G Outlook 2016 sync contacts directly between phone and computer using outlook 2016 Using Outlook 0
N Outlook 2016 Folder Icons Look Using Outlook 0
Marc2019 Outlook 2016 Font Problem Using Outlook 5
B Outlook 2016 Does not Shutdown Correctly Using Outlook 3
GregS Outlook 2016 Outlook 2016 stalls Using Outlook 3
H Outlook 2016 sent over 30 copies of an e-mail with attachments Using Outlook 1
Q Problems with Autodiscover Outlook 2016 Using Outlook 0
D Importing Outlook Categories from another domain (Exchange 2016/Outlook 2016) Using Outlook 4
Q Unable to Sync Quicken reminder with Outlook 2016 64Bit Using Outlook 1
J How to open OST file in Outlook 2019 & 2016 Using Outlook 1
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
K Outlook 2016 Using Outlook 0
L What are the risks of opening an Outlook 2016 .pst file in Outlook 2010? Using Outlook 4
David Langer Outlook 2016 (365) How to restore the ability to Re-Map iCloud IMAP Folders Using Outlook 5
W Search Incomplete Outlook 2016 Using Outlook 5
A Outlook 2016 not synching Using Outlook 4
B The Outlook 2016 Profile that isn't always there Using Outlook 2
D Outlook 2016 customization of incoming messages Using Outlook 1
J Command Button to stamp a date and time in a textbox in Outlook 2016 Outlook VBA and Custom Forms 3
J Checkboxes when selected will appear in a textbox in Outlook 2016 Outlook VBA and Custom Forms 1
N Outlook 2016 Address Book lookup Using Outlook 9
D Outlook 2016 automatically increment anniversaries Using Outlook 1
D Sharing outlook.com calendars in Outlook 2016 Using Outlook 1
S Adding new Exchange (2016) rule very slow down Microsoft Outlook Exchange Server Administration 0
M Outlook 2016 Requesting data from server Using Outlook 0
P Outlook 2016 Client and 365 - Groups Folder Using Outlook 3
P Add a contact to the New Task in Outlook 2016 Using Outlook 2
T Outlook 2016 is not receiving emails until I restart it Using Outlook 1
O Outlook 2016 has "Outlook 2015" files Using Outlook 2
Similar threads


















































Top