# Excel exporting
**URL:** https://community.mp3tag.de/t/excel-exporting/55882
**Category:** Support
**Created:** [January 13, 2022, 5:32pm UTC](https://community.mp3tag.de/t/excel-exporting/55882 "2022-01-13T17:32:42Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@afcchris](https://community.mp3tag.de/u/afcchris)
#### Post date: [January 13, 2022, 5:32pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/1 "2022-01-13T17:32:43Z")
Hi there. I tried searching for this but all the results are in german. I am trying to export my list of tracks to Excel to interrogate them but either the text file (opened in Excel) or the CSV export are both unusable as they don't format into proper columns in Excel. Has anyone been able to get over this?
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [January 13, 2022, 5:36pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/2 "2022-01-13T17:36:46Z")
edit the export script and replace the semicolon as column separator with `$char(9)` and try again.
---
### Author:  [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)
#### Post date: [January 13, 2022, 5:44pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/3 "2022-01-13T17:44:57Z")
> [@afcchris](#):
>
> I tried searching for this but all the results are in german.
Or you could try it adjusting the various import possibilities in Excel:
> [@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:  [@afcchris](https://community.mp3tag.de/u/afcchris)
#### Post date: [January 13, 2022, 7:22pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/4 "2022-01-13T19:22:44Z")
> [@ohrenkino](#):
>
> $char(9)
Thanks for the tip. I did try the sequence of events before i saw your tip but selected fixed and not delimited. When i got into the screen which gives me choices of "comma', "semicolon" etc. which one do i choose? I don't have much experience of csv files.
---
### Author:  [@afcchris](https://community.mp3tag.de/u/afcchris)
#### Post date: [January 13, 2022, 7:23pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/5 "2022-01-13T19:23:29Z")
Is there info about editing scripts on the website? If not can you guide me?
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [January 13, 2022, 7:26pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/6 "2022-01-13T19:26:32Z")
> [@afcchris](#):
>
> which one do i choose?
$char(9) is the code for the non-printable tab character.
Select this as delimiter.
Editing the export script should be easy as they are plain text files. You can edit the export script either with "NEw" for a new script or "Edit" for an existing script.
---
### Author:  [@LyricsLover](https://community.mp3tag.de/u/LyricsLover)
#### Post date: [January 13, 2022, 7:49pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/7 "2022-01-13T19:49:45Z")
> [@afcchris](#):
>
> Is there info about editing scripts on the website?
Inside Mp3tag, press CTRL + E (you need at least one selected track)
There you see the **New** or **Edit** button for your listed export scripts.
You can also copy/duplicate an existing one.
---
### Author:  [@afcchris](https://community.mp3tag.de/u/afcchris)
#### Post date: [January 13, 2022, 9:03pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/8 "2022-01-13T21:03:19Z")
yes i know how to do that bit but don't know how to edit the scripts and save
---
### Author:  [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)
#### Post date: [January 13, 2022, 9:07pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/9 "2022-01-13T21:07:29Z")
Edit: press the button that @LyricsLover showed you.
Save: Press Ctrl-S in the Windows Editot or use File\>save - as usual.
Then call the (updated) script in the export function.
There is also the help that you can call with F1 and open the topic on Export.
---
### Author:  [@afcchris](https://community.mp3tag.de/u/afcchris)
#### Post date: [January 16, 2022, 7:00pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/10 "2022-01-16T19:00:41Z")
thanks all. i was able to do it
---
### Author:  [@system](https://community.mp3tag.de/u/system)
#### Post date: [February 15, 2022, 7:01pm UTC](https://community.mp3tag.de/t/excel-exporting/55882/11 "2022-02-15T19:01:10Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.