There is currently no workaround, no way to "buy more space," etc. If you are trying to upload 1M rows, and those rows each contain more than 5 cells each (which is likely), you'll have exceeded this number (in fact, 1M rows with 5 cells each completely maxes the space limitation).
One of them is that no spreadsheet may have more than five million cells total among all sheets/tabs. Google Sheets has hard-and-fast limitations. But, if there is another Google cloud solution I can upload the data to, I am also open to that.
I saw Google ad scripts can access Google sheets hence my approach. Ultimately, I would like to access the data in a Google ad script. Is there some way excel could write to a Google sheet? Maybe there's a better approach I am missing? I'm not sure if this is the right approach or how long to expect to wait.Ĭan Google sheets access my hard drive? Is there some code I could write in Google sheets to upload the records one at a time? The page keeps saying it is unresponsive, I say wait and that loop continues. I tried copying and pasting from the CSV into the Google sheet. Then I tried opening it as a Google sheet, but that took over 2 days and didn't open. I tried uploading the file as a CSV to my Google drive, which worked. I have an Excel spreadsheet with over a million rows that I would like to have as a Google sheet.
0 kommentar(er)
