Export Tags to CSV

Support
1

I recently installed version 3.32. In my older version, there was an option to export the tags to a CSV file, which I could open in Excel. However, there are now no export configurations. (My %appdata%\Mp3tag did not contain an export folder.)

Export
Export454×516 8.67 KB

I looked in the Export Configuration Archive but don’t see any configurations for exporting to CSV or Excel.

Does anyone have a configuration file or know how I can restore this option?

Thanks!

2

The default csv.mte looks like this:

German:

$filename(csv,utf-16)Titel;Interpret;Album;Track;Jahr;Länge;Größe;Geändert;Pfad;Dateiname;
$loop(%_filename_ext%)%title%;%artist%;%album%;%track%;%year%;%_length_seconds%;%_file_size%;%_file_mod_date%;%_folderpath%;%_filename_ext%;
$loopend()Erstellt am %_date% mit %_app% - dem universellen Tag Editor - http://www.mp3tag.de/
3

I suggest uninstalling your current Mp3tag version and searching for older/different Mp3tag versions, too.
Then reinstall the latest version of Mp3tag. You should see 6 default exports scripts in the automatically created \export folder:

image
image210×225 3.23 KB

4

Just out of interest: for which use-case do you need Excel to manage your collection?

And another footnote:
I would modify the default CSV script so that the field separator becomes ASCII character #9. That separator eases the import as you do not have to handle the comma or semicolon in the data.
The export script could look like this:

$filename(csv,utf-16)Titel$char(9)Interpret$char(9)Album$char(9)Track$char(9)Jahr$char(9)Länge$char(9)Größe$char(9)Geändert$char(9)Pfad$char(9)Dateiname$char(9)
$loop(%_filename_ext%)%title%$char(9)%artist%$char(9)%album%$char(9)%track%$char(9)%year%$char(9)%_length_seconds%$char(9)%_file_size%$char(9)%_file_mod_date%$char(9)%_folderpath%$char(9)%_filename_ext%$char(9)
$loopend()Erstellt am %_date% mit %_app% - dem universellen Tag Editor - http://www.mp3tag.de/
5

I restored the CSV export configuration by uninstalling Mp3tag, installing version 3.29, and then updating to the current version. (Previously, I had to completely uninstall Mp3tag to update — the installation process kept ending prematurely. I suspect that is how I lost my export configurations.) I now have a backup of the configuration files in case this happens again. Thanks!

I like to maintain spreadsheets of my music files, especially game soundtracks. I try to keep consistent titles and track numbers (matching the order in which the music plays in the game) across different versions of the same song. Exporting all versions to Excel helps me spot discrepancies.