I have problems with importing csv, html and txt files which seems to be rather common. After reading a large number of post, I still have no solution. This is driving me nuts. (In the past, I have managed to write some Microsoft Access code that worked.)
In the main mp3tag view, I have the following columns.
Filename, artist, album, track, disc, albumartist, title, path
After export to csv and importing to a new Excel document, the columns are these.
Title, artist, Album, track, year, length, size, last modified, path, filename
After making changes, the following columns remain. I have left the last two columns untouched and have tried saving as csv or html files.
Title, artist, album, path, filename
I have made many attempts to write an adequate format string. The last four I have tried are these.
What about a delimiter at the end of a format string?
In very few cases, some information was imported, though appearing in the wrong columns. The most common result is ”Can’t parse line … ”. (This is quite common in other posts.) One result was that the app couldn’t understand any of the lines in the csv file (the message was in Swedish).
I have tried semicolon as a separator/delimiter, to no avail. I have changed the default delimiter in Windows 10. This doesn’t seem to take effect in mp3tag. In txt files, blank spaces, tabs or ” – ” are the only delimiters. As the ”-”- sign appears sometimes in the information itself, mp3tag gets confused. It seems in Excel, when saving, that there are several versions of csv, html and txt files.
I have tried txt files with BOM and without it, not being sure if BOM is necessary from version 2.91 onwards.
What should I do now?