New Google Sheets: faster, more powerful, and works offline

Posted by Zach Lloyd, Google Sheets Software Engineer

(Cross-posted on the Original Google Blog and the Google Drive Blog.)

Whether you’re crunching big data or tracking your team's budget, you don’t want to waste time waiting for files to load or re-doing edits that were lost because your Internet connection dropped. You can now get more done by switching to the new version of Google Sheets. It’s faster, supports larger spreadsheets, has a number of new features, and works offline.

Bigger, faster spreadsheets

The new Sheets supports millions of cells and kicks many of the old size and complexity limits to the curb. Scrolling, loading and calculation are all snappier, even in more complex spreadsheets.

New features based on your feedback and requests 

Filter views is a new feature unique to Google Sheets that lets you quickly name, save and share different views of your data. This comes in handy when you’re collaborating so you can sort a spreadsheet without affecting how others see it.

Whether you’re new to formulas or a whiz at running complex functions, it’s now easier to set up and perform calculations. New function help and examples guide you as you type, and error highlighting and coloring make it easy to spot and fix mistakes.

As another time-saving improvement, text now automatically flows into empty adjacent cells—no manual merge needed.

With the improved conditional formatting, you can add rules to change the colors and styles of cells in your spreadsheet based on custom formulas.

No internet connection? Work offline with Chrome 

You shouldn’t have to think about whether you have a WiFi connection when you want to work. So just like Google Docs and Slides, you can now make edits to Sheets offline. When you reconnect to the Internet, your edits will automatically sync. If you've edited Docs or Slides offline in the past, then you’re already set up to edit Sheets offline. If not, follow these one-time instructions for setting up offline in Chrome.

Ready to try it out? 

Turn on the new Sheets by checking the “Try the new Google Sheets” box in Google Drive settings. From then on, all new spreadsheets you create will work offline and include these new features. We’ll be adding a small list of missing features in the coming months, so if you rely on any of them, you may want to wait a little longer before opting in.

We hope you enjoy these and the many other updates that come along with the new Google Sheets, including colored sheet tabs, custom number formatting, paste transpose and more.