# CSV Export with seperate cells
**URL:** https://community.mp3tag.de/t/csv-export-with-seperate-cells/19029
**Category:** Export
**Created:** [June 8, 2017, 5:10pm UTC](https://community.mp3tag.de/t/csv-export-with-seperate-cells/19029 "2017-06-08T17:10:30Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@hillcreative](https://community.mp3tag.de/u/hillcreative)
#### Post date: [June 8, 2017, 5:10pm UTC](https://community.mp3tag.de/t/csv-export-with-seperate-cells/19029/1 "2017-06-08T17:10:30Z")
Trying to use the default CSV export but output creates a single cell for header and data output. I'd like each data item to reside in a single CSV cell instead of ";" as a separator.
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [June 8, 2017, 5:25pm UTC](https://community.mp3tag.de/t/csv-export-with-seperate-cells/19029/2 "2017-06-08T17:25:35Z")
What do you mean by "single CSV cell"?
The ; is the "C" in CSV ("comma") and if you import a CSV file e.g. into Excel, you get every piece of data that sits between a ; in a single cell.
So what should the result look like?
---
### Author:  [@hillcreative](https://community.mp3tag.de/u/hillcreative)
#### Post date: [June 8, 2017, 9:27pm UTC](https://community.mp3tag.de/t/csv-export-with-seperate-cells/19029/3 "2017-06-08T21:27:29Z")
> [@ohrenkino](#):
>
> What do you mean by "single CSV cell"?
> The ; is the "C" in CSV ("comma") and if you import a CSV file e.g. into Excel, you get every piece of data that sits between a ; in a single cell.
>
> So what should the result look like?
Each header such as ARTIST TITLE SONG should end up in a separate cell instead of a single cell with each field separated by a ; When I look at the export result the first cell contains all the data!
---
### Author:  [@hillcreative](https://community.mp3tag.de/u/hillcreative)
#### Post date: [June 8, 2017, 11:34pm UTC](https://community.mp3tag.de/t/csv-export-with-seperate-cells/19029/4 "2017-06-08T23:34:37Z")
> [@hillcreative](#):
>
> Each header such as ARTIST TITLE SONG should end up in a separate cell instead of a single cell with each field separated by a ; When I look at the export result the first cell contains all the data!
Answer my own question: use a comma "," not a ";" for separate cell entries. Also don't forget to quote around the metatags so a comma in the tag triggers another cell or field.
---
### Author:  [@system](https://community.mp3tag.de/u/system)
#### Post date: [November 26, 2023, 9:13am UTC](https://community.mp3tag.de/t/csv-export-with-seperate-cells/19029/5 "2023-11-26T09:13:10Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.