The problem with spreadsheet like import formats (Excel, CSV) is that some patron data structures can be repeated arbitrarily. An example is the address block. We can force them into columns, but it makes the format unfriendly. In my example I was using these column names for the fields of the first address:
It's error prone and looks weird. JSON is a more natural format to describe these.
Of course there should be a way to import column based formats, but this can be solved by building a tool which converts the spreadsheet format to JSON. The same goes to other formats, like an LDAP file. JSON will be the primary format we are supporting.