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

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.

edit the export script and replace the semicolon as column separator with $char(9) and try again.

[image] 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: [image] Adding Length (time) to CSV Support Additonal note for the import of a CSV into MS Excel: Don't just dou…

[image] 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.

Is there info about editing scripts on the website? If not can you guide me?

[image] 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 scr…

[image] afcchris: Is there info about editing scripts on the website? Inside Mp3tag, press CTRL + E (you need at least one selected track) [image] There you see the New or Edit button for your listed export scripts. You can also copy/duplicate an existing one.

yes i know how to do that bit but don't know how to edit the scripts and save

thanks all. i was able to do it

Excel exporting

Support

LyricsLover January 13, 2022, 5:44pm 3

Or you could try it adjusting the various import possibilities in Excel: