# CSV export can fail on value containing double-quotes

**URL:** https://community.mp3tag.de/t/csv-export-can-fail-on-value-containing-double-quotes/9067
**Category:** Support
**Created:** [October 2, 2009, 5:36pm UTC](https://community.mp3tag.de/t/csv-export-can-fail-on-value-containing-double-quotes/9067 "2009-10-02T17:36:21Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![chrisjj](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/c/a698b9/32.png) [@chrisjj](https://community.mp3tag.de/u/chrisjj)
#### Post date: [October 2, 2009, 5:36pm UTC](https://community.mp3tag.de/t/csv-export-can-fail-on-value-containing-double-quotes/9067/1 "2009-10-02T17:36:21Z")

</div>

Double quotes are not escaped so e.g. **"thisstringincquotes"** will lose its quotes when imported by e.g. Excel.

Workaround: recode.

---

<div class="post-metadata">

### Author: ![Florian](https://community.mp3tag.de/user_avatar/community.mp3tag.de/florian/32/5759_2.png) [@Florian](https://community.mp3tag.de/u/Florian)
#### Post date: [November 27, 2009, 9:06am UTC](https://community.mp3tag.de/t/csv-export-can-fail-on-value-containing-double-quotes/9067/2 "2009-11-27T09:06:08Z")

</div>

> [@chrisjj](#):
>
> Workaround: recode.

I'll happily incorporate any fix you can provide that covers any types of quotes that can be reinterpreted by Excel. I've also noticed that some versions of Excel produce different results between opening a file via double click or from the file menu. Using import is another thing.

Until then, I'll mark this as [LP]

---

<div class="post-metadata">

### Author: ![chrisjj](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/c/a698b9/32.png) [@chrisjj](https://community.mp3tag.de/u/chrisjj)
#### Post date: [November 27, 2009, 9:18am UTC](https://community.mp3tag.de/t/csv-export-can-fail-on-value-containing-double-quotes/9067/3 "2009-11-27T09:18:09Z")

</div>

> I'll happily incorporate any fix you can provide that covers any types of quotes that can be reinterpreted by Excel.

I don't know what Excel reinterprets and the problem I'm reporting is not specific to Excel. I think it deserves fixing regardless.

---

<div class="post-metadata">

### Author: ![dano](https://community.mp3tag.de/user_avatar/community.mp3tag.de/dano/32/6_2.png) [@dano](https://community.mp3tag.de/u/dano)
#### Post date: [November 27, 2009, 10:07am UTC](https://community.mp3tag.de/t/csv-export-can-fail-on-value-containing-double-quotes/9067/4 "2009-11-27T10:07:05Z")

</div>

I suggest for all text fields:  
"$replace(%title%,","")";

---

<div class="post-metadata">

### Author: ![chrisjj](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/c/a698b9/32.png) [@chrisjj](https://community.mp3tag.de/u/chrisjj)
#### Post date: [November 27, 2009, 10:12am UTC](https://community.mp3tag.de/t/csv-export-can-fail-on-value-containing-double-quotes/9067/5 "2009-11-27T10:12:41Z")

</div>

Agreed.

---

<div class="post-metadata">

### Author: ![DetlevD](https://community.mp3tag.de/user_avatar/community.mp3tag.de/detlevd/32/123_2.png) [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [November 27, 2009, 11:34am UTC](https://community.mp3tag.de/t/csv-export-can-fail-on-value-containing-double-quotes/9067/6 "2009-11-27T11:34:34Z")

</div>

Yes, doubling of quote characters within a string field is standard CSV convention.

DD.20091127.1333.CET

---

<div class="post-metadata">

### Author: ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)
#### Post date: [February 9, 2026, 12:21pm UTC](https://community.mp3tag.de/t/csv-export-can-fail-on-value-containing-double-quotes/9067/7 "2026-02-09T12:21:50Z")

</div>


