Outlook | Windows | Classic Outlook for Windows | For business
Using classic Outlook for Windows in business environments
See the tested attachement procedure for Outlook 2007 contacts import to Outlook 365.
Encoding issues when importing a csv file in Outlook Office Professional Plus 2021
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 63%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPY%3C/text%3E%3C/svg%3E)
Pierre-YvesL
0
Reputation points
Hello
A strange behavior on Outlook Office Professional Plus 2021 :
As I am French, my contacts contains prominent characters,as é, à,... The header of the fields contain also such characters as Prénom ( = First name)
I export my contacts in a csv file separated by commas. The mapping is correct :
Then without opening and modifying this csv file, I just reimport it in Outlook.
I view the proposed mapping : Outlook does even not recognise the header of the columns :
the first field Titre appears as "Titre" , the second one Prénom as Prénom, and so on.
And the contacts fields are inconsistent :
If I reimport the file, all the contacts are then duplicated whatever the mapping I try and whatever the option I choose about the duplicated items.
I can't understand why there is such a behavior. I am really puzzled by the first field "Titre", because at least this word Titre doesn't contain any special character and should appears without any encoding problem.
Thank you !
Pierre-Yves
Outlook | Windows | Classic Outlook for Windows | For business
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Yuki Sun-MSFT 41,456 Reputation points Moderator2023-01-25T08:47:11.3366667+00:00 Hi @Pierre-Yves，
Regarding to your concern about the first field "Titre", I checked it in my English version of Outlook desktop client and also noticed a similar situation. Not sure why it displays like this but per my test, seems like it doesn't have any impact.
As for the issue when importing the CSV file, please try importing the CSV file via Outlook online instead and check how it goes. You may refer to reply under this thread for steps to import csv via Outlook online.
-
Yuki Sun-MSFT 41,456 Reputation points Moderator
2023-01-31T01:27:44.86+00:00 Hi @Pierre-Yves，
Just following up regarding my previous post. Do you perhaps have any questions regarding the information provided?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 95%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
Ty Watkins 20 Reputation points2023-10-26T17:50:03.52+00:00 I've found that the issue is the encoding of the .csv file. When you export it from Outlook, for whatever reason, it creates it as a UTF-8 BOM. This format has the 3 additional bytes at the beginning of the file which are the odd characters preceding "Title".
The workaround I've found is to open the CSV file in Excel and using Save As and choosing the standard "CSV (Comma delimited) (.csv)" and NOT "CSV UTF-8 (Comma delimited) (.csv)". Then it should import into Outlook correctly.
Sign in to comment
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 10%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
MARCEL LAPIERRE 0 Reputation points2026-01-02T16:34:49.62+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 49%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Arno64 0 Reputation points2024-04-18T16:19:44.8866667+00:00 Kudos to the folks above. Had the same issue and fixed it this way:
Issue : Import of contacts into Outlook from a CSV file create in Excel is not working and characters that are not from the English alphabet (eg é è à ç in French) are converted to codes during the import.
Reasons :
- MS support pages indicate to save the file in CVS with UTF-8 format but Excel will then encodes it as UTF-8 BOM which Outlook does not recognize during import. Standard UTF-8 encoding is recognized but it will not reason those characters from other languages.
- If Windows is not in English, the standard separator in the CSV created can be the semicolon ; in lieu of the colon. Outlook can only recognize CSV with a colon as separator.
Solution
- Save the file with contacts in Excel as plain CSV format, not UTF-8. !
- Open the CSV file with Notepad to verify which separator is used, and if need be replace separating semicolons by colons. In that case, in order to save and keep as CSV file, you may have to disable ‘Hide extensions for known file types’ in the folder options of File Explorer and then back in Notepad do Save As and replace the .txt extension by .csv. (The file will show as format ANSI in Notepad bottom right corner, which is fine). !
- Do the import in Outlook as described : File > Open & Export > Import/Export > Import from another program or file > etc.