My experience is, that many times, I end up with a UI that is quite restrictive, in the sense that I have to use forms, where people with fewer principles use spreadsheets, in which it is easy to jump from one row to another. My late father did that, when he transcribed information from films in the archives, and I also know fellow genealogists who still distribute data that way.
Working with spreadsheets is easy, when your data can be organized in a few tables, where all data that you have found for a person can be stored in a single row. And most times it can, also if you do most your research on-line, because the number of fields in the archives’ databases are quite limited, and there are no repeating fields, meaning that a person never has more than one birth date, or place, and since most sources are tied to a single event, multiple date columns, like a birth and a death date, are also quite rare. They can exist, but even then, there is at most one birth and one death date in that kind of data.
I am assuming, but I can’t check, because the posts were removed, that the CSV files that StoltHD uses also represent flat tables, and I think that’s a valid approach. And I also have the experience that no software that I know has a grid control with the flexibility of a spreadsheet. You always run into some kind of (hidden) commit when you move to another row, so that the underlying database knows what is going on.
It might be possible to create better grid controls than we have in the attributes and person name editors, but I doubt that, so in the end, what I reaaly want is a two way interface, so that I can edit my evidence infomation in a spreadsheet, import it into Gramps, and export it again, to work on it in another location. And for that, it must at least be compatible with flat tables, for the persons, event, and citation.
This is how I see open data, and horizontal integration.