# 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:** 18\ **Page:** 3
**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:29pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/42 "2023-05-24T14:29:46Z")
1. Yes 2. Yes 3. Yes 4. Yes 5. Yes 6. Yes, I deleted that part as I wasn't sure if that was to be kept or not ( `$filename(csv,utf-16)` ?) 7. Yes 8. Yes 9. Yes 10. Yes 11. Yes, 12. No. it did not come out the way previous attempts where made ---
**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:41pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/43 "2023-05-24T14:41:19Z")
> [@Scorpius](#): > > No. it did not come out the way previous attempts where made which leads me to the alternative to "yes": > [@ohrenkino](#): > > ... need a description what happened instead: ---
**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:49pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/44 "2023-05-24T14:49:09Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/c/cf10b52b938a530e7a244754cfa190e952206643.png) please advise as to what line of scripting that needs to be eliminated and kept. I had to reinstall the program Thank you ---
**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:59pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/45 "2023-05-24T14:59:10Z")
If you start from scratch then I would think that you first follow the absolute basic list of tasks as described here: > [@Exporting to Excel spreadsheets](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/41): > > 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: Have you selected the files for which you want to get the export? Have you pressed Ctrl+E? Did the list of export scripts open? Did you select the script with … Independent from that: you tend not to answer the feedback. E.g. I am missing an answer to > [@ohrenkino](#): > > As the export to excel seems to be so many problematic - what do you want to do with the exported data in Excel? And how do you know that the length is not right? ---
**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, 3:01pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/46 "2023-05-24T15:01:39Z")
Yes, I am at the point of editing ---
**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, 3:06pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/47 "2023-05-24T15:06:12Z")
I was told that the length is in seconds ---
**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, 3:08pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/48 "2023-05-24T15:08:49Z")
... and the idea was then to use a different variable, right? > [@ohrenkino](#): > > 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 24, 2023, 3:10pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/49 "2023-05-24T15:10:34Z")
yes, I was given this path to hopefully export everything required $loop(%\_filename\_ext%)%title%;%artist%;%album%;%track%;%year%;%\_length%;%\_file\_size%;%\_file\_mod\_date%;%\_folderpath%;%\_filename\_ext%;%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 24, 2023, 3:17pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/50 "2023-05-24T15:17:47Z")
That did not replace only the part starting with "$loop()" right? Please open the export script for editing. Select all the text in the script Delete the whole text from the script Copy the following code ```auto $filename(csv,txt)Title$char(9)Artist$char(9)Album$char(9)Track$char(9)Year$char(9)Length$char(9)Size$char(9)Modified$char(9)Path$char(9)Filename$char(9)Genre$char(9)Comment$char(9)BPM$char(9)Bitrate $loop(%_filename_ext%)%title%$char(9)%artist%$char(9)%album%$char(9)%track%$char(9)%year%$char(9)%_length%$char(9)%_file_size%$char(9)%_file_mod_date%$char(9)%_folderpath%$char(9)%_filename_ext%$char(9)%genre%$char(9)%comment%$char(9)%bpm%$char(9)%_bitrate% $loopend() ``` and paste it to the empty export script window. Save the export script. Close the editor Execute the script Check the resulting CSV file in Excel. ---
**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, 3:22pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/51 "2023-05-24T15:22:09Z")
![image](https://community.mp3tag.de/uploads/default/original/2X/0/036f31d031ff52d5c4224fabfe81aed6712af378.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, 3:24pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/52 "2023-05-24T15:24:55Z")
No. > [@ohrenkino](#): > > Select all the text in the script > Delete the whole text from the script > Copy the following code and all the other bits in that post. Please! I am close to giving up on this. ---
**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, 3:31pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/53 "2023-05-24T15:31:20Z")
SUCCESS!!!!!!!!!!!!!!!! Thank you!!!!!!! ---
**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, 3:32pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/54 "2023-05-24T15:32:42Z")
Great. So now you have the data in Excel. And what next? ---
**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, 3:39pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/55 "2023-05-24T15:39:12Z")
That's it. I can go about how I want to set up my library and DJ list Thank you for your patience, it's truly appreciated ---
**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, 3:45pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/56 "2023-05-24T15:45:47Z")
> [@Scorpius](#): > > set up my library and DJ list Still, out of interest: in what respect does Excel help you? Finding particular tracks -\> filter in MP3tag Renumbering tracks to keep a certain order -\> track numbering wizard in MP3tag Playing the track to find out which version should be taken -\> double-click in MP3tag Assigning a new genre -\> edit file in MP3tag. Putting files together for a playlist -\> Generate playlist in MP3tag (file menu) So where does Excel come in handy? ---
**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, 3:52pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/57 "2023-05-24T15:52:28Z")
I will be doing a master play list for each genre of music for each of the song I play so I have a record if one song is played more than another ---
**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, 3:56pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/58 "2023-05-24T15:56:16Z")
If you want to sort that list by GENRE, wouldn't it then be better to have an export script that already sorts the files by genre? Doesn't you DJ player add a play-counter to the files? And even if it does not: the field POPULARIMETER has a parameter to add a play-counter. And that could easily be editted in MP3tag and be used as a filter criterion to find the popular files. ---
**Author:** ![system](https://community.mp3tag.de/uploads/default/original/2X/c/ce7035d426cb755a7916793326d23b465222a407.png) [@system](https://community.mp3tag.de/u/system)\ **Post date:** [June 23, 2023, 3:57pm UTC](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040/59 "2023-06-23T15:57:15Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed. [Previous page](https://community.mp3tag.de/t/exporting-to-excel-spreadsheets/61040.md?page=2)