Escaping quotes and delimiters in CSV files with Excel

When reading in a quoted string in a csv file, Excel will interpret all pairs of double-quotes ("") with single double-quotes(").

so "this; is"" a;test" will be converted to one cell containing this; is" a;test

So replace all double-quotes in your strings with pairs of double quotes.

Excel will reverse this process when exporting as CSV.

Here is some CSV

a,b,c,d,e
"""test1""",""",te"st2,"test,3",test"4,test5

And this is how it looks after importing into Excel: