Tag Editing

Batch with Mp3tag

You can use this program to import a CSV file of tags. 

Menu: 
    Convert -> Text file - tag

It will want two things: A file and a Format String.  The file will have the tags, and the format string you will construct.

File

Compile your Spreadsheet, using the column names at the top. These column names will become the names of your tags.
Ensure you have one line for every mp3.
Export to a CSV, and exit the Spreadsheet program
Open the CSV in wordpad. 
Cut out the header row,  and paste it into a new wordpad, saving it for later
Take a look at the data in the columns. Make note of any that have quotes surrounding them (this happens when the contents have a comma in them)
Note this in the other wordpad that has your header row
Save

Format String

In the wordpad that has your header row, you want to change it from ALBUM,ARTIST to %ALBUM%,%ARTIST%. You can do this with find and replace somewhat. Of the columns that had quotes, simply insert them;  %ALBUM%,"%ARTIST%" 


Sample CSV File

ALBUM,ARTIST,COMMENT COMMENT,COMMENT ITUNPGAP,COPYRIGHT,GENRE,ITUNESPODCAST,ITUNESPODCASTDESC
NPR: Car Talk Podcast,NPR,Stories: ,0,2010,Podcast,1,"Teresa in Yakima, WA"

Sample Header

%ALBUM%,%ARTIST%,%COMMENT COMMENT%,%COMMENT ITUNPGAP%,%COPYRIGHT%,%GENRE%,%ITUNESPODCAST%,"%ITUNESPODCASTDESC%"

Comments