How to export album collection with metatags information

[Leo]

Hello,

I'd like to export my collection into an excel spreadsheet. I do not want to export tracks but only album. The goal would be to fill columns according to the metatags of tracks of an album

%artist% | %albumname% | %catalogid% | %releasedate% | % www%

Thank you for your help

[zappaphone]

Have you tried some of the examples in the

Export Configuration Archive

This is the official list of export configurations submitted by users of Mp3tag. Please note, that some of them are in german, others are in english. Feel free to post about your creative works with Mp3tag's export feature in the Export discussion subforum How do I install export configurations? The *.mte files must be copied/extracted to the corresponding profile folder %appdata%\Mp3tag\export Wie installiere ich Export-Konfigurationen? (german) Die *.mte Dateien müssen in das…

[ohrenkino]

I assume that you want to get a list of albums but not the list of the individual titles.
Please note that the fields that you mention

@Leo

%albumname% |... %releasedate%

are no standard names for fields.

You could try this script:
$filename(csv,utf-16)Artist | Album | Catalog ID | Release Date | www
$loop(%artist%)$loop(%album%,1)%artist% | %album% | %catalogid% | %releasetime% | %www%
$loopend()$loopend()

[Leo]

That\s almost exactly what I want. The script works well and gets all the needed information, but the data are not well separated into columns when opening the file in excel. Everything is written in the first cell. What should I do ?

[ohrenkino]

Use
$filename(csv,utf-16)Artist,Album,Catalog ID,Release Date,www
$loop(%artist%)$loop(%album%,1)%artist%,%album%,%catalogid%,%releasetime%,%www%
$loopend()$loopend()

[Leo]

Same conclusion

EDIT : It's OK now. Thanks a lot