There has always been a vision in computing where you can access the same data with different tools.
In the Kernigan and Plauger Software Tools book that describes the Unix user space you could use tools like wc, awk, sort, uniq, and grep, bound together with the shell, to do all kinds of things on plain text files.
As a photographer of course I want to share images between Lightroom Classic and DxO and as a computer graphics “artist” (I almost want to say “technician”) I want to work with images in Photoshop, web editors, tools I write to create images, etc.
Shouldn’t I be able to make music with GarageBand and then listen to it in iTunes and then write a program that plays it through my smart speakers at sunrise to wake me up?
Office 95 revolved around COM which meant that a Microsoft Word file was a composite file that could also contain data from other programs like PowerPoint and Excel so I could embed a small spreadsheet in a word document. (The fact that this system was documented and open was a weakness as much as a strength because you never knew if the recipient of a file had all the applications to open it)
Currently Office uses a documented XML and ZIP based file format. It is easy-peasey to load data in Excel format into pandas to do data analysis (less error prone than CSV even.). It’s not hard to write a program in PHP or Java that makes an Excel sheet complete with formulas for somebody to fill in then have them upload it back to a web site and suck the data out.
Locked in data is one reason why the cloud and mobile age feels like a step backwards than forwards, never mind the possibility of losing your data because you couldn’t pay the bill or your vendor got bought by Google, etc.