I am planning to use spread sheet as a database for a simple website. My major concern is the size limit. It seems that a single spread sheet cannot hold more than 400,000 cells, which is not a large number if the table has 50+ columns. Is there any recommended way to circumvent this problem when the table is too large for a single sheet?
Another question is about how to store a row with many fields. Should each field be stored as different columns? or just record the entire row as a single string filled with key value pairs? Many thanks. :)
