# Export multiline fields into csv or xls

**URL:** https://community.mp3tag.de/t/export-multiline-fields-into-csv-or-xls/10185
**Category:** Support
**Created:** [March 26, 2010, 8:47am UTC](https://community.mp3tag.de/t/export-multiline-fields-into-csv-or-xls/10185 "2010-03-26T08:47:09Z")
**Posts on this page:** 1
**Showing post:** 1

<div class="post-metadata">

### Author: ![incifinci](https://community.mp3tag.de/user_avatar/community.mp3tag.de/incifinci/32/6526_2.png) [@incifinci](https://community.mp3tag.de/u/incifinci)
#### Post date: [March 26, 2010, 8:47am UTC](https://community.mp3tag.de/t/export-multiline-fields-into-csv-or-xls/10185/1 "2010-03-26T08:47:09Z")

</div>

Hi all,

I spent a big time but couldn't find the answer.

I want to export some multiline field (for example comment, unsuncedlyrics) into a spreadsheet (csv or xls). Of course the whole content of 1 field must be in 1 cell of the table. Both csv and xls formats are able to store line breaks in one cell - but I don't know, what character does it. I tried to replace CRLF sequencences (\r\n) to $char(10), $char(13), $char(11) (=vertical tab - it seems that Excel uses), but in all cases breaks will not in one cell - instead they make a new cell in the second line every time.

Is there a solution? Thank you in advance.

---

_[View the full topic](https://community.mp3tag.de/t/export-multiline-fields-into-csv-or-xls/10185)._