I have a data file with 14 columns and 9,523,125 rows.
Can a Google Spreadsheet handle at least 9,523,125 rows?
-
Welcome to Web Applications Stack Exchange! This site does not accept requests for recommendations. We have a sister site that does, but your question needs to meet certain guidelines. In particular, all questions must both define a goal or task to accomplish, and list some objective requirements. Please read the guidelines and improve your question accordingly, then you can repost your question on the Software Recommendations site. – jonsca♦ Jul 22 '14 at 18:01
-
Even if it can, how will you open it in browser :P – Umair Ayub Jul 10 '19 at 10:00
-
Related What's the biggest .csv file you can import into a Google Sheets? – Rubén Oct 10 '19 at 16:29
As this post is old but the current data has changed I will add a new answer for (2019) data.
Again for your cell count the answer is still: NO
That said google has upped its cell limit to 5 million. I have tested this and it will load exactly 5 million cells into google sheets but no more.
As a reference at the time of this post the current limitations are:
- Up to 5 million cells for spreadsheets that are created in or converted to Google Sheets 40,000 new rows at a time. (I have loaded files with 100k lines so I believe this is creating new lines within sheets at one time)
- Maximum number of columns of 18,278 columns
- Number of Tabs: 200 sheets per workbook
- GoogleFinance formulas: 1,000
- GoogleFinance formulas ImportRange formulas: 50 cross-workbook reference
- Formulas ImportData, ImportHtml, ImportFeed, or ImportXml formulas: 50 functions for external data
- Maximum string length is 50,000 characters
For the direct information on what is supported by google drive here is the Google Help Answer. This does not have as much info as the tips but does confirm the 5 million cell limitation.
-
1Finally the gsutetips.com article was updated (Very frequently I found it on the Google Web Search top results but until now I shown 2 instead of 5 millions limit). – Rubén Oct 10 '19 at 16:28
-
Perhaps you can add this reference to your answer: support.google.com/drive/answer/37603?hl=en – Jacob Jan Tuinstra Oct 11 '19 at 7:11
-
@JacobJanTuinstra I did add the reference. Do you mean some content from the 2nd reference? Mostly it just mirrors the other info. If I added quotes from the 2nd reference it would just be redundant. – Mike - SMT Oct 11 '19 at 12:24
-
As for the cell reference, this comes from Google...I think some of the info is outdated as well. – Jacob Jan Tuinstra Oct 11 '19 at 12:30
-
@JacobJanTuinstra I have tested all the limitations for Google Sheets and the current info is reflected as accurate in my testing. The 5m cells, the 100mb limit and so on. – Mike - SMT Oct 11 '19 at 12:31
