On Mon, Nov 7, 2011 at 9:58 PM, scott <[email protected]> wrote: > 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? > > You could circumvent this by spanning data across multiple sheets, and minimizing the number of columns in each row.
> 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. :) > If data could be consolidated somehow, it would slightly increase the amount of data you could store in the sheet. Some users do this by storing JSON representations of data sets in a cell.
