# 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:** 5

<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 27, 2010, 6:59am UTC](https://community.mp3tag.de/t/export-multiline-fields-into-csv-or-xls/10185/5 "2010-03-27T06:59:17Z")

</div>

> [@DetlevD](#):
>
> ...I assume that Excel is not ready to import "multiline" CSV fields...

DetlevD, thank you too for quick and detailed help.

I decided to use use this variant, with replacing characters, because of  
**1.** remaining double quotes in cell,  
**2.** not soluted, too, tabs in field,

and because it meets booth my needs,  
**3.** backup and  
**4.** quick search in spreadsheet, without loading all files into Mp3tag.

Excel 2003 spreadsheet cell able to store 32,760 (I think, 2-digits - because I use unicode) characters. And as I found on the net, txt-format (what I need for restoring - Excel\>txt\>Mp3tag) has no line lenght limit.

> [@](#):
>
> $filename(C:\Documents and Settings\itsme\Desktop\Backup.xls)ALBUM ARTIST COMMENT  
> $loop(%\_path%)%album% %artist% $iflonger($replace(%comment%,$char(9),,$char(13)$char(10),**)****,32600,$left($replace(%comment%,$char(9),,$char(13)$char(10),),32600) !!! TOO LONG !!!,$replace(%comment%,$char(9),,$char(13)$char(10),))  
> $loopend()**

 

Have a nice week end!

---

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