# Exporting to Excel spreadsheets **URL:** \ **Category:** Support\ **Created:** [May 22, 2023, 3:08am UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040 "2023-05-22T03:08:14Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 22, 2023, 3:08am UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/1 "2023-05-22T03:08:14Z")
Hello all, I've been trying for a several months now to export one of my music files to no avail. Finally tonight I was able to export and open in simple fashion: Export CVS file open Excel click on the DATA banner Get Data {furthest left} select from file select from text/cvs Excel then will place all the columns in order as per your spread sheet select load Now the only issue I ran into is it did not provide me all the columns I have in my editor nor did the length match what's in the directory ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 22, 2023, 5:36am UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/2 "2023-05-22T05:36:02Z")
You would have to show us the export script and tell us which fields you are missing. Also, the screenshot of a file in the file list showing the length field for which you see the wrong length plus a screenshot of the extended tags dialogue for this file would help. ---
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 22, 2023, 3:44pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/3 "2023-05-22T15:44:53Z")
where do i find the export script? ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 22, 2023, 4:03pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/4 "2023-05-22T16:03:19Z")
How did you export as CSV? Ctrl-E opens the export script list. Select the export script that you used and click the Edit button. An editor window will open that shows the export script. Copy and paste the script to a post, preferably in a section of preformatted text (see toolbar or this editor window). ---
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 22, 2023, 4:16pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/5 "2023-05-22T16:16:13Z")
file export selected csv export file name mp3tag.csv clicked ok opened up in excel with columns missing ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 22, 2023, 4:46pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/6 "2023-05-22T16:46:13Z")
I assume that you use the CSV script that comes with the default installation. That is just an example how a csv file could look like. If you have special needs then you would have to adapt to these requirements. Which should be easy enough as it the script is a plain text file. The export scripts do not update automatically according to your modifications of columns in the file list. So it would still be helpful if you could tell us which fields you find to be exported and which ones you did not but would like to be included. ---
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 22, 2023, 5:34pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/7 "2023-05-22T17:34:57Z")
fields included in the cvs export file title artist album track year length size last modified and filename columns' wanted title artist file name year genre comments bpm bitrate length as i stated earlier the length does not match the actual length of the song ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 22, 2023, 5:40pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/8 "2023-05-22T17:40:25Z")
> [@Scorpius](#): > > title artist file name year genre comments bpm bitrate length So, for title artist file name year genre comments bpm bitrate length you set in the export script: `%title%$char(9)%artist%$char(9)%file%$char(9)%name%$char(9)%year%$char(9)%genre%$char(9)%comment%$char(9)%bpm%$char(9)%_bitrate%$char(9)%_length%` This separates the fields with the tab character which is better in those cases when the data in the fields could contain also a comma. > [@Scorpius](#): > > as i stated earlier the length does not match the actual length of the song How do you know? I think that this might be a different topic, though. ---
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 22, 2023, 5:51pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/9 "2023-05-22T17:51:42Z")
thank you, how do I do set in the export script: `%title%$char(9)%artist%$char(9)%file%$char(9)%name%$char(9)%year%$char(9)%genre%$char(9)%comment%$char(9)%bpm%$char(9)%_bitrate%$char(9)%_length%`? I've never done script writing ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 22, 2023, 5:52pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/10 "2023-05-22T17:52:52Z")
Did you try what I described in > [@Exporting to Excel spreadsheets](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/4): > > How did you export as CSV? Ctrl-E opens the export script list. Select the export script that you used and click the Edit button. An editor window will open that shows the export script. Copy and paste the script to a post, preferably in a section of preformatted text (see toolbar or this editor window). ---
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 23, 2023, 5:23pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/12 "2023-05-23T17:23:34Z")
in the export configuration window, I clicked edit and it brings me to the Microsoft app store? ---
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 23, 2023, 5:25pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/13 "2023-05-23T17:25:53Z")
would you be able to provide me with a screen shot? ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 23, 2023, 5:26pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/14 "2023-05-23T17:26:48Z")
> [@Scorpius](#): > > configuration window, I clicked edit and it brings me to the Microsoft app The "Edit" function opens the application that is the default editor for text files. If you have not yet set a default application then select the "Editor" from the list. ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 23, 2023, 5:28pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/15 "2023-05-23T17:28:03Z")
> [@Scorpius](#): > > would you be able to provide me with a screen shot? I would. If I only knew of what I should take a screenshot. Apparently, your system is configured in a different way than mine as you do not have set a default text editor application, ![grafik](https://community.mp3tag.de/uploads/default/original/2X/a/a43758ed8afd9466095cc978f5aadba617e93f79.png) ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 23, 2023, 5:32pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/16 "2023-05-23T17:32:13Z")
As the export to excel seems to be so many problematic - what do you want to do with the exported data in Excel? Most of the functions that Excel can provide can also be found in MP3tag and probably better as they are specifically tailored to deal with taggable files. ---
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 23, 2023, 6:24pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/17 "2023-05-23T18:24:48Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/2/247f179a82ed2ff20ce73947cb588bc34bfac776.png) ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 23, 2023, 6:27pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/18 "2023-05-23T18:27:13Z")
Great. Now please select the export configuration "csv" and click the edit button (the second from the top, that one with the pencil). A text editor should open and there you see the export script. Either copy and paste it to a forum post or show a screenshot of the editor window. ---
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 23, 2023, 6:47pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/19 "2023-05-23T18:47:46Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/9/9a27cbbb616e5825abc4e4bdf8c8d712bd3832d4.jpeg) This is what I get after following your instructions ---
**Author:** ![ohrenkino](https://community.mp3tag.de/user_avatar/community.mp3tag.de/ohrenkino/32/4843_2.png) [@ohrenkino](https://community.mp3tag.de/u/ohrenkino)\ **Post date:** [May 23, 2023, 6:51pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/20 "2023-05-23T18:51:58Z")
You see the Link "more apps" with the arrow down - please click on this link to open the list of suggested applications. You should see the notepad editor somewhere. Please select that: ![grafik](https://community.mp3tag.de/uploads/default/original/2X/6/6ab2b9bc329ebd136f2cbd32e94a9038e7726bf1.png) ---
**Author:** ![Scorpius](https://community.mp3tag.de/letter_avatar_proxy/v4/letter/s/a87d85/32.png) [@Scorpius](https://community.mp3tag.de/u/Scorpius)\ **Post date:** [May 23, 2023, 7:00pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/21 "2023-05-23T19:00:19Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/5/5575277c654cbf93a9d51203446760b9e1f5d7f0.png) [Next page](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040.md?page=2)