stillinvestor.blogg.se - How to import csv contacts into outlook 2013

HOW TO IMPORT CSV CONTACTS INTO OUTLOOK 2013 WINDOWS

Selecting the default List Separator in the Region settings of Windows. Now, when you export from WLM, OE or WM, you’ll create a proper csv-file.In the drop down list for List separator you can either select the comma or type it in the box if it is not listed.On the Formats tab click Customize this format… or Additional settings….Start-> Settings-> Time & Language-> Region-> in the “Related settings” sections on the right or bottom click on: Additional date, time, & regional settings-> in the Control Panel section that opens click on Change date, time, or number formats Clock, Language and Region-> Change date, time, or number formats.Open Control Panel from the Start Menu or via a Search and open the Region and Language Options applet.

HOW TO IMPORT CSV CONTACTS INTO OUTLOOK 2013 WINDOWS

To change your list separator value in Windows However, as I said, you can configure the delimiter in your Regional Settings in Windows which would make it a feature again and will enable to WLM, OE and WM to create a proper csv-file again. In this format the choice of the delimiter is not restricted to a comma. Are WLM, OE and WM to blame here for not respecting the meaning of csv? In essence, WLM, OE and WM export to the dsv-format delimiter separated value. Should WLM, OE or WM look at your configured list separator instead and use that? Should Outlook? It would break interoperability between systems if the format of a file is depended on end-user configuration. Outlook however expects a comma as a separator in a csv-file as that is what the file format stands for comma separated value. If this was set to a comma, you probably wouldn’t have been reading this -) The reason why Windows Live Mail (WLM), and also Outlook Express (OE) and Windows Mail (WM), used a semi-colon as a separator instead of a comma is because that is what is specified in your Region Settings in Windows to be used as the list separator. Separated file can be done easily via Notepad. Turning a semi-colon separated file into a proper comma

Go back to Outlook and import the file.

So replace the semi-colons for commas and you’re done. The issue is that instead of commas (, ) being used as a separator, you probably see semi-colons ( ) being used instead. I’m not sure whether I should call this a bug or a feature but luckily the solution is quite easy.įor a change, let’s start with the solution and then I’ll explain my dilemma of whether to call this a bug or a feature.

How can I import my contacts into Outlook? The file is in csv-format but when I try to import it into Outlook, I'm being prompted to Map Custom Fields but everything is just on a single line. I’ve exported my contacts from Windows Live Mail on my old computer and now I want to import them into Outlook on my new computer.