# Export to columns
**URL:** https://community.mp3tag.de/t/export-to-columns/6133
**Category:** Support
**Created:** [January 26, 2008, 7:38pm UTC](https://community.mp3tag.de/t/export-to-columns/6133 "2008-01-26T19:38:33Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@Notter](https://community.mp3tag.de/u/Notter)
#### Post date: [January 26, 2008, 7:38pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/1 "2008-01-26T19:38:33Z")
Is there anyway to export to Excel in a column format? I'd like to be able to delete some of the information and re-arrange the remainder of the information when exporting to a csv. Currently each line exports to a single cell and the information (Title, Album, Genre, etc.) can't be globally manipulated.
---
### Author:  [@Florian](https://community.mp3tag.de/u/Florian)
#### Post date: [January 29, 2008, 9:15pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/2 "2008-01-29T21:15:56Z")
Can you give an example? I'm not sure if I understand you correctly.
---
### Author:  [@Notter](https://community.mp3tag.de/u/Notter)
#### Post date: [January 30, 2008, 4:09pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/3 "2008-01-30T16:09:13Z")
When I export using the csv option all of the linear information is exported together to the same cell, for instance in one cell it looks similar to:
c:\documentsandsettings\abbafernando3:28mp3pop3142kb and so on. I can't delete columns or sort in anyway because all of the above is in just one cell (column). I renamed the original export file and then played around with some of the syntax but I'm by no means a programmer and it showed. I also looked around the forum and got some ideas but none of them worked for me, probably associated with my not being a programer. I also modified the columns by deleting all the columns I did not want to see when exporting. When I look at them while using the program only those I want to see show up but when exporting they all show up as above. Thanks in advance
---
### Author:  [@DetlevD](https://community.mp3tag.de/u/DetlevD)
#### Post date: [January 31, 2008, 1:48pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/4 "2008-01-31T13:48:23Z")
> [@Notter](#):
>
> When I export using the csv option all of the linear information is exported together to the same cell, ...
Please read this and come back with your questions:
[Zu doof für Export?](https://community.mp3tag.de/t/4473/1)
[CSV output](https://community.mp3tag.de/t/4483/1)
DD.20080131.1548.CET
---
### Author:  [@Notter](https://community.mp3tag.de/u/Notter)
#### Post date: [January 31, 2008, 3:52pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/5 "2008-01-31T15:52:54Z")
> [@DetlevD](#):
>
> Please read this and come back with your questions:
> [Zu doof für Export?](https://community.mp3tag.de/t/4473/1)
> [CSV output](https://community.mp3tag.de/t/4483/1)
>
> DD.20080131.1548.CET
I saw this last weekend and cut and pasted but got the same syntax error. That's when I started playing around with the coding but not being even an entry-level programer I didn't have much success. I was smart enough however to have renamed the original csv file so that when I was through screwing up in my attempts I could un-rename and get back to the original.
---
### Author:  [@Florian](https://community.mp3tag.de/u/Florian)
#### Post date: [February 1, 2008, 2:46pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/6 "2008-02-01T14:46:05Z")
I think the problem that all information is exported to one single cell might be caused by Excel not recognising the semicolon as a column separator.
Can you please try to replace all semicolons by commas in the export configuration (or vice-versa if you already use commas as column separator).
Which version of Excel are you using?
---
### Author:  [@aladoro](https://community.mp3tag.de/u/aladoro)
#### Post date: [February 3, 2008, 7:47am UTC](https://community.mp3tag.de/t/export-to-columns/6133/7 "2008-02-03T07:47:19Z")
if you just doubleclick a CSV file it will open in Excel _but_ the semicolon _isn't_ recognized as a delimiter (at least with Excel up to version 2003).
so first start Excel and File Open your CSV file. you will get a wizard letting you specify your delimiter ...
(we had a similar problem in this (German) thread: [/t/2798/1](https://community.mp3tag.de/t/2798/1)
HTH, andreas
---
### Author:  [@Scorpius](https://community.mp3tag.de/u/Scorpius)
#### Post date: [February 24, 2023, 8:11pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/8 "2023-02-24T20:11:40Z")
this is what I get when I export as a cvs file. It compressed into one cell.
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [February 24, 2023, 9:09pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/9 "2023-02-24T21:09:55Z")
Did you follow the advice in the post immediately above yours?
> [@aladoro](#):
>
> so first start Excel and File Open your CSV file. you will get a wizard letting you specify your delimiter ...
and also:
> [@Florian](#):
>
> I think the problem that all information is exported to one single cell might be caused by Excel not recognising the semicolon as a column separator.
---
### Author:  [@MotleyG](https://community.mp3tag.de/u/MotleyG)
#### Post date: [February 24, 2023, 9:15pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/10 "2023-02-24T21:15:54Z")
You need to make sure you are using a unique identifier as the separator for the data you export from mp3tag. I use the Section sign § (Alt+0167) since it is highly unlikely to be used in most tags. After the file has been exported, you have to start Excel separately, then use Open your saved export file from within Excel. You will get a wizard that will prompt you through the steps required to get the columns, including one that will let you define the separator you chose.
---
### Author:  [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)
#### Post date: [February 24, 2023, 9:42pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/11 "2023-02-24T21:42:58Z")
> [@Scorpius](#):
>
> this is what I get when I export as a cvs file. It compressed into one cell.
I posted some screenshots from the Excel options for CSV in this thread:
> [@Adding Length (time) to CSV](https://community.mp3tag.de/t/adding-length-time-to-csv/55643/17):
>
> Additonal note for the import of a CSV into MS Excel: Don't just double click on your CSV file to open it in Excel. Open Excel first and then inside Excel click on Open -\> Search then change the extension from the default \*.xls to All files \*.\* or Text files \*.csv to find your \*.csv file. Then click on the Open-Button. This way, you get a 3 step wizard to import your data into Excel. In Step #1 of #3 you should choose Delimited (even if Excel tells you it has detected "Fixed …
---
### Author:  [@system](https://community.mp3tag.de/u/system)
#### Post date: [March 26, 2023, 9:43pm UTC](https://community.mp3tag.de/t/export-to-columns/6133/12 "2023-03-26T21:43:15Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.