I have been having a similar need for some sheets data in Obsidian, I was gonna look into writing a plugin to represent a JSON file as a Obsidian Base, but didn't get to that yet.

Have you tried some of the plugins that allow you to open CSV / TSV files within Obsidian?