Google Workspace Changes

Google Sheets now supports publishing spreadsheets in five additional formats: .csv, .tsv, .pdf, .xlsx, and .ods.

Users of Google Sheets on the web can now publish their spreadsheets in five additional formats beyond the standard web page: comma-separated values (.csv), tab-separated values (.tsv), PDF documents (.pdf), Microsoft Excel spreadsheets (.xlsx), and OpenDocument spreadsheets (.ods). When the generated URL is opened in a browser, the spreadsheet will automatically download in the chosen format.

Insert images into Google Sheets while offline

Users can now insert images into Google Sheets when working offline in the Chrome browser, provided that offline access has been enabled. Any images inserted while offline will be synced once the user regains internet connectivity.

Introduction of protected cell warnings to prevent accidental edits.

To facilitate safer collaboration, Google Sheets now allows owners to set warnings for individuals who attempt to edit certain cells, reducing unintended changes like typos without requiring complex permission settings.

Pivot table enhancements with calculated fields and GETPIVOTDATA function.

Google Sheets has introduced calculated fields to pivot tables, allowing users to apply formulas to pivot table data, and the GETPIVOTDATA function to retrieve specific data from a pivot table.

New data analysis tools including formula previews and conditional filtering.

Users can now preview formula results and errors instantly as they type and filter rows and columns based on specific conditions such as 'less than', 'greater than', 'text contains', and 'date after'.

Enhanced chart customization options in Google Sheets.

Google Sheets now offers more ways to visualize data with the addition of data labels to display exact values of bars and points, custom shapes and symbols for data points in line and scatter charts, and improved functionality for moving and resizing charts.