Import contacts from excel file / files

đź’¬ General Discussion
4

Hi,

I advise you to open your XLS file in LibreOffice and then save them to CSV. LibreOffice is an open source alternative to excel and can be downloaded for free here:

http://www.libreoffice.org

Excel doesn’t do well writing CSV files, especially concerning quoting fields that contain newlines. When you save in LibreOffice, the option “edit filter settings” enables you to set delimiter, character encoding and quotation.