Does the script Export > Metadata as CSV do what you want? If not installed already, you can install this from the Support Assistant. There are several variations already posted in this forum if you’re interested in customizing it.
Might be a Unicode issue – something for Christian to look into.
Here’s another user’s variation that might be useful here:
“transformed” how? Is there a particular format that you’re looking for?
As @sander did in the post mentioned above, there is script that Christian posted (somewhere, don’t have time to find it) called “customizable metadata export” that might be more in line with what you need.