Maximum file size allowed for import | 50 MB |
Maximum number of rows | 262144 |
Maximum number of columns | 2048 |
Maximum number of cells | 10 Million |
Maximum number of characters in a cell | 32768 |
Maximum number of worksheets | 1024 |
Maximum number of hyperlinks in a worksheet | No limit |
Maximum number of characters in a sheet name | 31 |
Maximum number of characters in a file name | 1000 |
Maximum number of undo actions in a worksheet | 30 |
Maximum number of cells you can paste data into | 3,00,000 |
Maximum number of live collaborators (users with edit permission) | 100 |
Maximum number of rows that can be hidden | 262143 |
Maximum number of columns that can be hidden | 1023 |
Column width | 2000px |
Row height | 2000px |
Limit for Audit Trail | 1000 in Audit Trail dialog. However, further audits will be available in the corresponding version history. |
Limit for Version History | No limit |
Zoom range | 50 % to 400 % |
Number precision | 15 digits |
Maximum number of custom functions | No limit. However, each function is limited to a maximum evaluation period of 3 seconds. |
Maximum number of formulas in a worksheet | No limit. However, each function is limited to a maximum evaluation period of 3 seconds. |
Maximum number of nested functions | No limit. However, the length of the formula can't exceed the cell value limit of 32768. |
Maximum number of iterations in circular references | 10000 |
Maximum number of charts in a worksheet | No limit |
Maximum number of data points in a chart | 5000 |
Maximum number of Pivot Tables in a worksheet | No limit. However, each Pivot Table is restricted to a maximum evaluation period of 15 seconds. |
Maximum number of unique value fields in a Pivot Table row | 10000 |
Maximum number of unique value fields in a Pivot Table column | 250 |
Maximum number of entries in a Picklist | 500 |
Maximum number of items in a filter drop-down | First 5000 unique items |
Maximum file size of image that can be inserted inside and over the cell | 10 MB |
Maximum number of sources files that can be linked to a single destination file using IMPORTRANGE() | 25 |