Apply audio tags from CSV file

I have an archive of audio files named like <title>.<ext> (e.g. Track title.ogg) and a CSV file with metadata for those files with the following structure:

Album,Track number,Title,Author,Cover file,Foo,
Lorem ipsum,1,Dolor sit amet,John Doe,image.png,bar
...

Is there a way to automatically apply the metadata to the corresponding tracks?

Please also consider the following.

1. Some file names contain possibly problematic charachters like spaces, ', ., ,. I could remove them easily via regex, but I'd prefer to avoid that if possible because it would mean that I also have to rename those files manually after applying the tags.
2. I'd much prefer to use only FOSS software.
3. The metadata includes the name of the cover for each file. I would like to add it automatically too, but I could also do that manually (the tracks are divided in several groups - roughly for author - sharing the same cover, so doing that manually shouldn't require much time).

Either CLI or GUI solutions are good as long as they work.