I know CSV will work as I've done it before, however it probably will not be what you want because of the limitations of the CSV file format. You can use multiple lines by including a linefeed (0x0A) character in the quoted string for that column, but the column will only be the height of a single line so you will not see this extra data until you manually (in excel) resize that row, or edit the data to automatically resize the row. You can't include this row-height property in the CSV file.
I would therefore suggest you use XML file format. For example:
<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="s21">
<Alignment ss:Vertical="Bottom" ss:WrapText="1"/>
</Style>
</Styles>
<Worksheet ss:Name="Book1">
<Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="1" x:FullColumns="1"
x:FullRows="1">
<Row>
<Cell><Data ss:Type="String">a</Data></Cell>
<Cell><Data ss:Type="String">b</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">c
line 2</Data></Cell>
<Cell><Data ss:Type="String">d</Data></Cell>
<Cell><Data ss:Type="String">e</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook>
<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
</Style>
<Style ss:ID="s21">
<Alignment ss:Vertical="Bottom" ss:WrapText="1"/>
</Style>
</Styles>
<Worksheet ss:Name="Book1">
<Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="1" x:FullColumns="1"
x:FullRows="1">
<Row>
<Cell><Data ss:Type="String">a</Data></Cell>
<Cell><Data ss:Type="String">b</Data></Cell>
<Cell ss:StyleID="s21"><Data ss:Type="String">c
line 2</Data></Cell>
<Cell><Data ss:Type="String">d</Data></Cell>
<Cell><Data ss:Type="String">e</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook>
To copy to clipboard, switch view to plain text mode
Note the use of a different style for the cell where you wish to include an embedded linefeed. Without this, the line feed character will be parsed incorrectly and you'll just see a square box.
EDIT: Hmm, it seems the forum software has converted the "
<semicolon>" into an actual line feed. If you wish to try this XML file out, you may wish to change that back, or just download this attachment: Book1.xml
Bookmarks