I don't know the specific issue with Excel when creating multi-line entries in the CSV file. The correct format is simply to have the line break appear inside the double-quote marks that surround the value of a field.
A quick test shows the following CSV file was generated for 4 lines in the spreadsheet:
what,the vaule,another value
line 1,a single line,"a line
with a line break"
line 2,another single line,yet another singleline
line3,,no data in previous column
A quick test shows the following CSV file was generated for 4 lines in the spreadsheet:
what,the vaule,another value
line 1,a single line,"a line
with a line break"
line 2,another single line,yet another singleline
line3,,no data in previous column
Last edited: