Forum Discussion
Creating .csv fails...
Magnus_Kjellson Outlook is expecting a comma-separated csv, but your Excel produces a ; separated csv. This is due to your regional settings where the decimal separator is a comma (I expect). In Excel, before exporting the file to csv, try this: Go to File, Options, Advanced tab. Uncheck "Use system separators" and set a period as the decimal separator and the comma as thousands separator:
Once you've exported the file, check the "Use system separators" box again.
Hi, and thank you so much for your help!
I've unchecked that box and put "." as decimal separator and "," as thousounds separator,
but still get the result in Outlook as i pic below..? 😞
(Should be three values in the left column, not one long one including them all.)
No luck so far. I hope you have another idea? 🙂
- No straightforward solution found, but a work around solved it..!
I opened the Excel csv-file, which contains just the needed parameters, name, and e-mail, in "Note pad" app, chose "edit" and "replace" and replaced ; (semicolon) with , (comma) and saved the file.
Now in Windows Explorer I changed the name/file format of the file from Note Pad from .txt to .csv and the the import into Outlook worked flawless..!
