Export library in a universal format

There’s a lot of great artists I’ve found using Roon’s ability to link artists through their metadata that I’ll never remember if they disappear. So with Tidal possibly going the way of the dodo I exported all the Tidal albums in my library as a backup.

Unfortunately the .xls opens like this in Numbers on my Mac:

I don’t think I’m doing anything wrong. I can open other .xls files just fine. Assuming it does have to do with how the export was coded, can we get an update to a more universal format? .xlsx? .csv? .json?

I can convert it to JSON with some of the online converters but it’s still not formatted sensibly and would be difficult to work with at best.

I agree that a more robust export format would be desirable, either .json or (second best) .csv. In the meanwhile, I found that Libre Office on the Mac does a good job of converting Roon-generated .xls to .csv. I read the result into a Python script I have to clone a part of my Roon library into a microSD to use in my DAP.

3 Likes

Thanks for the tip. Haven’t tried Libre Office so I’ll take a look at that.