Overview
Improved file importing in Google Sheets with tables and linked pivot tables
Google have introduced two key improvements in Google Sheets that preserve formatting and linked data when converting files from Microsoft Excel.
- First, Excel tables will now seamlessly import as Sheets tables.
- Second, Sheets now fully supports importing Excel pivot tables that are backed by table ranges.
Benefits
Previously, when converting Excel files, Excel tables did not import as Sheets tables, causing users to miss out on the structural and formatting benefits of tables, and pivot tables linked to tables were replaced with static grids. These updates ensure your data structures remain intact and correctly formatted upon import. Most importantly, your imported spreadsheets will be ready to use right away, no manual reconstruction needed.
What does it look like?
Resources
- Google Docs Editors Help: Use tables in Google Sheets
- Google Docs Editors Help: Create & use pivot tables