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 wi…

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 $filename(csv,txt)Title$char(9)Artist$char(9)Album$char(9)Track$char(9)Year$char(9)Length$…

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.

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.

[image] This is what I get after following your instructions

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]

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…

I'm going to leave everything as is. I can edit it afterwards what would be the next step?

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 sav…

Mp3tag Community

Exporting to Excel spreadsheets

Support

Scorpius May 23, 2023, 7:00pm 21

image1174×123 5.82 KB

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled