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
Farling
Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module
Donations gratefully received via Patreon, Ko-Fi or Paypal
Last edited by Farling; April 3rd, 2018 at 09:56 AM.
|