Spreadsheets: 400,000 cells, with a maximum of 256 columns per sheet. Uploaded spreadsheet files that are converted to Google spreadsheets format can’t be larger than 20MB, and need to be under 400,000 cells and 256 columns per sheet. More information about spreadsheets limits 40,000 of your cells can have formulas. Certain formulas have their own specific limits, too, to make sure that even complex spreadsheets stay fast. Up to 1,000 GoogleFinance formulas Up to 1,000 GoogleLookup formulas Up to 50 Cross-workbook reference formulas and/or Functions for external data. VLOOKUP and HLOOKUP formulas tend to be more complex than other formulas. If your spreadsheet is slowing down or you think you may be approaching limits, you may want to remove some of these formulas. To determine the number of responses that a form can take, you need to take into account the number of questions in your form and the number of other cells of data within your spreadsheet.