Wednesday, November 19, 2014

Google Update: New Version of Google Sheets


Upgrading older Spreadsheets to new Google Sheets

This post is from Google Support.  For additional information, visit Google Support.

Using the new version of Google sheets will soon be the only way to create and edit spreadsheets.  To make sure that everyone can take advantage of all the features available in Sheets, all spreadsheets created in the old version of Google Sheets are being migrated to the new version.  This process will take place over the course of 2014-2015.

What actions do I need to take with my spreadsheets?

No action is needed. Your old spreadsheets will automatically be upgraded to the new Google Sheets so that you can take advantage of lots of great new functionality. At any point, you can tell what version your spreadsheet is in by checking to see if there is a green checkmark  at the bottom of your spreadsheet.  
There is no way to manually upgrade a spreadsheet to the new version, although there are other ways to move spreadsheets to the new Sheets.

What is the timeline? When should I expect my spreadsheets to be switched to the new version?

Not all spreadsheets will be migrated at the same time. We expect nearly all spreadsheets to be upgraded over the course of the next year, starting in late fall 2014. If you’d like to edit older spreadsheets in the new Google Sheets sooner, there are steps you can take to manually import your older spreadsheet into the new version of Google Sheets.

Is it possible to revert back to the old Sheets?

No. After migration, your spreadsheets will exist solely in the new version of Google Sheets. You will not be able to revert upgraded spreadsheets back to the old version, and all new spreadsheets are already created in the new version by default.
After your spreadsheet has been upgraded to the new version of Google Sheets, you’ll see a banner at the top of the spreadsheet letting you know the migration has taken place. In that note, you’ll see a link to report any issues or feedback you may have. If you’re experiencing any issues with your spreadsheet, we encourage you to send us feedback via this form.

Will this affect my spreadsheet data?

No data should be affected; however, the results of some formulas and some other features may be slightly different. See "What's different in the new Sheets?" for more detailed information.
What's different in the new Sheets?
You may notice some subtle differences in behavior between the old and new versions of Google Sheets:
  • Formulas — You may notice some subtle differences in formula behavior, most of which fix problems or bugs with some formulas in the old version.
  • Text wrapping — Previously, if you’d turned off wrapped text in your spreadsheet, text would get clipped at the end of a cell. In the new Sheets, you’ll see text flow into the adjacent cell, if that cell is empty. To wrap the text, simply click the Wrap text button  in the toolbar.
  • APIs — You may notice some subtle differences in API behavior.
  • External tools — Spreadsheets may not interact the same way with third-party tools. We encourage you to provide feedback on issues you may be experiencing with any popular add-ons, scripts or tools.
  • Unsupported features — A few features have been retired in the new version of Sheets.

How can I provide feedback on the new Sheets?

As mentioned above, if you notice any issues immediately after your spreadsheet is migrated to the new Sheets, please click on “Send feedback” in the notification you see in the bottom right corner of your file. Filling out this form will help us investigate any potential issues.
Otherwise, you can always click on the Help menu and select Report an issue from within your spreadsheet, or post in our product forums.

Here is a short video about the new Google Sheets by the Google Guru