Starting back in 2011 I was working on a way to manage a variety of spreadsheets in a variety of layouts with a common schema. Over the last 13 years, I've been updating and maintaining this little project. It's not widely used, but it interests me.
Fundamentally, the use of well-defined schema is really important. And often overlooked.
See https://pypi.org/project/stingray-reader/
See https://slott56.github.io/Stingray-Reader/build/html/index.html
History
See More Command-Line Goodness. This started as an elaborate exercise in literate programming. In 2012, I got some feedback. See Stingray Schema-based File Reader
In 2014, I added and refactored it quite a bit. See Python Package Design, Refactoring and the Stingray Reader Project and Stingray 4.4 Update -- the Posix split command applied to COBOL files and TDD, API Design and Refactoring. Busy year. This was the tail end of my hiatus, and I was back to looking for paying jobs.
In 2015, I considered the Literate Programming nature of the project. See Literate Programming and GitHub.
Then. Work interfered.
In 2018, I added some things. See Coping with a Spreadsheet Database.
Also, I moved from SourceForge to GitHub. See The SourceForge vs. GitHub Conundrum.
In 2020, some more upgrades. See StingrayReader Upgrade, Stingray Reader Rewrite, and Stingray Reader Pervasively Bad Decision,
In 2021, some more revisions, mostly related to annotations. See Spreadsheets, COBOL, and Schema-Driven File Processing. Also Reading Spreadsheets with Stingray Reader and Type Hinting. And Processing Apple Numbers Files.
In 2022, some additional thoughts. See The Enterprise COBOL Conundrum.