Question

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?

Answer 1

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.