Are the new Google Sheets faster than the old?

In December, Google released new Sheets, saying they are faster and better than the old – including working offline. I’ve made a couple of tests to compare the old and the new – a simple operation – writing data.

In each case I’m doing 2 tests

  • Writing data cell by cell to a sheet
  • Writing data in a single operation to a sheet
In old Spreadsheets, it has always been best to get all the data in one go, play around with it, and write it all back in one go. Let’s see if there is still such a dramatic difference with the New Sheets For comparison, I’m also approximating the same thing in VBA in offline mode. I’ll also repeat the test a number of times throughout the day to get a good sample of numbers.

The results

This shows the average run time across each of the 3 variations

So we see that that writing values all at once, as opposed to cell by cell is still about 5 times as fast, and that new sheets is indeed 2-3 times as fast as old sheets for this kind of test. Of course, VBA, since it is entirely local is much faster than either to perform equivalent operations

The code – Google Apps Script

 

The code – VBA

 
For more stuff like this, see Excel Liberation. I haven’t reproduced the timer code here, but if you are interested you can find it here.
About brucemcp 223 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.

Be the first to comment

Leave a Reply

Your email address will not be published.


*


three × three =