Yes the joy of a spreadsheet is the blank slate - you can just start writing random things in random boxes.
What I'd like is something you can do both. Start writing random things but then slowly formalise - define columns as specific types for consistency etc. And if you do this enough end up with a structured database. But not force only one or the other