# 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:** 2
**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, 7:04pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/22 "2023-05-23T19:04:44Z")
The line `$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%; $loopend()` determines which fields are sent to the resulting csv file. Which of the fields do you want to keep and which other fields from the file list are you missing. The field variable %\_length\_seconds% may be the one that puzzles you as it writes the length in seconds and not in minutes:seconds. If you want to get the formatted output, replace %\_length\_seconds% with %\_length%. ---
**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:13pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/23 "2023-05-23T19:13:51Z")
I'm going to leave everything as is. I can edit it afterwards what would be the next step? ---
**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, 7:17pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/24 "2023-05-23T19:17:40Z")
You edit the script so that the list of fields contains all the fields that you want to see in the export. If you are not sure how they are represented in a script then list the names as you think they are called. It would then probably be easy to find the corresponding variable name. You then save the script and call it from the list of export scripts and open the output as you described in the first post. ---
**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:32pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/25 "2023-05-23T19:32:37Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/1/125b2e8e2526f819b50b0ccb484b3862ddb89add.png) this what I have? ---
**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, 7:37pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/26 "2023-05-23T19:37:39Z")
And what have you done in the meantime? The last dump shows 1 entry more in the list of export scripts. Aren't we talking about an unaltered script called "csv"? ---
**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:59pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/27 "2023-05-23T19:59:14Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/b/ba77aa0bb6a240eaa308b21966948a95baebfe39.png) this is a cvs file export without the modifications. As you can see I'm missing genre comment bpm bitrate ---
**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, 8:07pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/28 "2023-05-23T20:07:13Z")
Apparently, you do not have any data in TRACK If you want to see > [@Scorpius](#): > > genre comment bpm bitrate then add `%genre%;%comment%;%bpm%;%_bitrate%` to the line > [@ohrenkino](#): > > $loop(%\_filename\_ext%)%title%;%artist%;%album%;%track%;%year%;%\_length\_seconds%;%\_file\_size%;%\_file\_mod\_date%;%\_folderpath%;%\_filename\_ext%; $loopend() so that it becomes `$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%;%genre%;%comment%;%bpm%;%_bitrate% $loopend()` ---
**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, 8:27pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/29 "2023-05-23T20:27:16Z")
I'm not concerned about the missing data, my only requirements are title artist year length bit rate genre comment bpm ---
**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, 8:28pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/30 "2023-05-23T20:28:36Z")
That may be as it is. Did you adapt the script accordingly so that in now meets your > [@Scorpius](#): > > requirements ... title artist year length bit rate genre comment bpm ---
**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, 8:33pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/31 "2023-05-23T20:33:13Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/4/4b7e2892e069409fce3cefdf39c2797db1798761.png) this is what I get when entering the new sequence ---
**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, 8:41pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/32 "2023-05-23T20:41:39Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/5/5b083e9e2708a5fe5c206ab81cc3f7b0d4cfcf79.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, 8:44pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/33 "2023-05-23T20:44:39Z")
Please show me the actual export script. The name of the script does not say a lot. Also, it would help if you told us what you did so far. The text from the screenshot does not look like it has been generated by a modified sample script with the name "csv" in which only the existing list has been appended by some field variables. ---
**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, 8:48pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/34 "2023-05-23T20:48:27Z")
the script is what you sent me $loop(%\_filename\_ext%)%title%;%artist%;%album%;%track%;%year%;%\_length\_seconds%;%\_file\_size%;%\_file\_mod\_date%;%\_folderpath%;%\_filename\_ext%;%genre%;%comment%;%bpm%;%\_bitrate% $loopend() ---
**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, 8:52pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/35 "2023-05-23T20:52:18Z")
this is all i have from you today. Nothing further ---
**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 24, 2023, 5:08am UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/36 "2023-05-24T05:08:11Z")
> [@Scorpius](#): > > the script is what you sent me It is a partial script as I said > [@ohrenkino](#): > > then add > `%genre%;%comment%;%bpm%;%_bitrate%` > to the line > > > [@ohrenkino](#): > > > > $loop(%\_filename\_ext%)%title%;%artist%;%album%;%track%;%year%;%\_length\_seconds%;%\_file\_size%;%\_file\_mod\_date%;%\_folderpath%;%\_filename\_ext%; $loopend() > > so that it becomes > `$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%;%genre%;%comment%;%bpm%;%_bitrate% $loopend()` So, what does the whole script look like? ---
**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 24, 2023, 1:50pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/37 "2023-05-24T13:50:31Z")
i sent it to you already. It's #30 of the thread ---
**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 24, 2023, 1:51pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/38 "2023-05-24T13:51:16Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/8/88873f5e7f67c0b40b6306fcdb6088cec9b71dc1.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 24, 2023, 1:59pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/39 "2023-05-24T13:59:53Z")
I do not see the contents of an export script in any of the posts following > [@Exporting to Excel spreadsheets](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/21): > What I see is a list of names of export scripts. You would have to select the script name in the list of export scripts and then click the edit button. Then you see the contents. And that contents would be of interest for your problem and would also have to be adapted. As you do not describe what you do (step by step) it is hard if not impossible from the distance to tell what might have gone wrong. I cannot look over your shoulder. ---
**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 24, 2023, 2:10pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/40 "2023-05-24T14:10:25Z")
would you you be willing to do remote access? to get me where I need to me? I'll be donating to this cause and your time? ---
**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 24, 2023, 2:20pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/41 "2023-05-24T14:20:24Z")
As others do not see what would happen during the remote access, yet they could benefit from a decent description of the problem plus eventually a possible solution, I would rather deal with the problem in the public forum. So, the following questions should preferably be answered with "yes" or need a description what happened instead: 1. Have you selected the files for which you want to get the export? 2. Have you pressed Ctrl+E? 3. Did the list of export scripts open? 4. Did you select the script with the name "csv"? 5. Did you click on the "edit" button? 6. Did a text editor window open that shows a text starting with `$filename(csv,utf-16)`? 7. Did you replace the string `$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%;` with `$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%;%genre%;%comment%;%bpm%;%_bitrate%`? 8. Did you save the modfied export script? 9. Did you close the text editor? 10. Did you click OK to execute the script? 11. Did you check the output in Excel? 12. Was it OK? [Previous page](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040.md?page=1) [Next page](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040.md?page=3)