EDIT: Found a working solution using working software:I believe I found a working solution using software called Mp3tag. It should meet all of your requirements. Here is a list of instructions that I used and that you may be interested in:
- Download and install Mp3tag.
- Open your Mp3s in the software, sort them so they match the order of whatever list you have.
- Select all tracks or the ones you want, right click them and click "Export"
- Select txt_taglist in the list, select a location and filename if you want and click OK.
- Open the .txt file with a program that can do "find and replace", I used Notepad++.
- Select the
-
(That's supposed to be four spaces with a dash between them) that divides the tags with something else like Press Ctrl+H and find and replace all with;
(unless your tags contain that character) so it changes fromArtist - Album - Title - Track - year - Genre -
toArtist;Album;Title;Track;year;Genre;
on each row. - Save that file as a .csv file
- Now you got a .csv that you can edit in your preferred spreadsheet software, make the changes you need and save the .csv file.
- In Mp3tag, select all tracks and make sure they are sorted like before and in the menu bar click "Convert > Text file" - Tag or press "Alt+4".
- Browse for the .csv file and use the text import as described here. I used
%artist%;%album%;%title%;%track%;%year%;%genre%
as the format string for the .csv file. - Use the preview button on the left to make sure that it works and if it looks good hit OK and you are done.
Found this question when I was searching around for answers to the same question, I eventually found MP3 Book Helper. This is a free software that has functionality for importing .csv
files to tag mp3s export and import.
I had some problems with it though, it worked perfectly until I wanted to save the tags and then i got a "Range Check Error" but maybe it will work for you?