Google Sheets Simplifies Excel Imports with Enhanced Tables Feature

Google has been working to improve its Google Sheets web app, and the latest update aims to make importing Excel files less of a headache for users. One of the key features of this new update is that when users import an Excel file into Google Sheets, its tables will be added as 'Sheets tables.' This ensures that structural and formatting information remains intact and that Excel tables stay properly formatted when opened in Google Sheets.

The web app now also supports importing pivot tables from Excel. Previously, importing an Excel file with pivot tables into Sheets resulted in those tables being converted into static tables. Now, however, Sheets will keep pivot tables intact, allowing users to easily manipulate data in their worksheets and have the updated data reflected in the pivot tables.

Both features are rolling out to Sheets users automatically, and there's no need to manually enable anything. Importing Excel tables as Sheets tables is available right now to all users with Google Workspace or personal accounts. The ability to import pivot tables is rolling out as well and could take up to 15 days to reach everyone.