Google is updating Google Sheets to improve how Microsoft Excel files import and to add two new features for Connected Sheets users working with BigQuery.
Excel tables now convert directly to native Sheets tables, and linked pivot tables import as interactive pivot tables instead of static grids. For Connected Sheets, Google is introducing list parameters and column aliasing to make BigQuery analysis easier.
These updates address common issues with converting spreadsheets and working with large datasets. Excel table imports are available now, while linked pivot table support is rolling out gradually.
Google Sheets Improves Excel Imports and BigQuery Tools
Previously, importing Excel files into Google Sheets often meant extra cleanup. Excel tables did not become native Sheets tables, so structural formatting was lost. Linked pivot tables also turned into static, uneditable grids.
With this update, Excel tables now import as native Sheets tables and keep their original formatting, sort controls, and structure. Pivot tables in Excel that use table ranges now come into Sheets as interactive pivot tables instead of flat, static data.
These changes mean imported spreadsheets are reThese changes let users work with imported spreadsheets right away, without having to rebuild tables or pivot structures. Table imports are available now.
Linked pivot table support is rolling out gradually to all Workspace domains and personal Google accounts. Adding two features to Connected Sheets aimed at making database analysis more accessible to non-technical team members.
List Parameters let users reference a whole range of cells as a single list parameter in BigQuery queries. This means power users or data admins can set up input sheets with drop-down menus or selection grids, so others can filter large database queries without editing SQL code.
Column Aliasing lets users create easier-to-read column names directly in Connected Sheets. Database columns are often hard to read or use technical names. Aliasing lets users rename them for a wider audience without changing database references or breaking formulas.
Availability and Rollout
The rollout differs slightly by feature:
- Excel table imports are available now to all users.
- Linked pivot table support is rolling out gradually to all Workspace domains and personal Google accounts.
- Both Connected Sheets features, list parameters and column aliasing, are rolling out now for all Google Workspace customers and personal account users with Connected Sheets access.
The Excel table import feature is live now. Linked pivot table support is still rolling out, so some users may not see it yet.
The Connected Sheets list parameters and column aliasing features are also rolling out now for users with Connected Sheets access. It is not confirmed when the pivot table rollout will be complete.
Thank you for being a Ghacks reader. The post Google Sheets Improves Excel Imports With Native Tables and Adds Connected Sheets Upgrades for BigQuery appeared first on gHacks.
0 Commentaires