Import contacts from csv with comma in Company field

[audrius]

Hello,
Maybe someone knows how to import Contacts from CSV file where company names have comma in the name.
name,name2,company,Ltd,+123456789,..etc numbers...
I tried "company,Ltd" (failed) and company&#0044Ltd (imported as is)


Audrius

 

[JohnS_3CX]

Hi Audrius,

You will have to edit the CSV file, this is the only way to do it as far as I'm aware.

Example: Adrian,Shuler2k,Company, LLC,5409047262,,,,,,,,,,

You can open it in a spreadsheet and correct the ones that have a problematic entry

From this:


To this:


Save the CSV, and import it now

 

[craigreilly]

Funny I got a similar answer for a different product just yesterday - to put double quotes around the company name. CSV - ugh!