vote up 0 vote down star
1

I know that MS office spread sheets have a limit on the number of rows and columns you can have in them what is the limit on google docs spread sheets?

flag

1  
For clarification: Since Office 2007 the Excel format has been changed to XML and the limit for both is pretty much dependent on how much memory and hard drive space you have. In fact the current limit is over 17 billion cells. Reference: cyberskillsguide.com/32/… – Diago Sep 3 at 21:39

1 Answer

vote up 3 vote down check

From Getting to know Google Docs: Size limits:

Spreadsheets

  • Each spreadsheet can be up to 256 columns, or up to 200,000 cells, or up to 100 sheets -- whichever limit is reached first. There's no limit on number of rows.
    • Each spreadsheet can have up to 20,000 cells with formulas. Of this total, the following limits apply:
      o Up to 1,000 GoogleFinance formulas
      o Up to 1,000 GoogleLookup formulas
      o Up to 50 Import formulas
    • You have a limit of 1000 spreadsheets. The spreadsheets that are shared with you do not count against 1000 limit.
    • The limit on spreadsheets open at one time is 11.
    • You can import spreadsheets up to approximately 1 Mb in xls, xlsx, csv, ods, txt, tsv, or tsb format.

Of course, these might change as Google rolls out enhancements so I'd always look up the Google Docs support site to see what the current limits are.

link|flag

Your Answer

Get an OpenID
or
never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.