Import csv with blank cells

[JoshK131]

Hello,

I am trying to import a csv using an import template from the front end side.

Below is a sample of a csv

Contact ID, Contact Name, Detail 1, Detail 2, Detail 3
11111, John Smith,,,
22222, Mohamad Lee,"","",""
33333, Peter Parker, "",,

Of the 3 rows above, only row 1 will be imported.

It seems to have trouble importing when the row contains empty double quotes.

Is there any way to work around this?

[Jaymer]

Use text editor, find/replace all the “” to null/empty string
Then the import will work