guglbing.blogg.se - Importing contacts into outlook 2016 for pc

Importing contacts into outlook 2016 for pc windows#

My adviseĪlways double check the delimiter being used before importing anything. The thing is, files with another delimiter than a comma usually are named *.csv as well so the confusion remains when getting another file for import. I think I’d prefer the first solution as that is what Outlook expects as well when importing and that is simply what the csv-format stands for.

So, would you call it a bug or a feature? Should WLM, OE and WM always use the comma and not look at your list separator value or should they rename the file format to dsv instead? 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.

Importing contacts into outlook 2016 for pc 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.