5 ms·

I’ve had trouble getting more than 10k rows in google sheets. It will be interesting to see how well this works.

• ramraj07 8y ago
  I have a couple sheets that are very close to the 2 million cell limits, in which almost every cell either does a vlookup or is being queried or is displaying some Google sheet SQL result. Sheet takes time to load but still works fine!
  • hyperbovine 8y ago
    Have to ask, what is the use for such a Frankenstein?
  • richjdsmith 8y ago
    Boy, I'm not sure quite why, but the idea of a spreadsheet with nearly 2 million cells stresses me out... Why that over a DB?
    • prepend 8y ago
      Spreadsheets are a DB. Do you mean over a DB server? Or a relational DB? Or a DB without a bundled Model view controller?
    • ramraj07 8y ago
      Not for a lack of programming skills, but I really felt (and still stand by it) that Google sheets was the perfect solution for that problem.
• seektable 8y ago
  well, for >10k rows most likely it is better to use more specialized tools to create pivot tables. Google Sheets as browser app just not intended to do this.