Google Sheets Enhances Excel File Imports with Formatting Preservation
Photo: Android Authority
Quick answer
Google Sheets now correctly imports Excel tables and pivot tables while preserving formatting and dynamic structure. This simplifies data handling and eliminates the need for manual adjustments after import.
Google has announced two key improvements in Sheets that simplify working with Excel files. When importing tables from Excel, they now retain their original formatting and structure, appearing as native Sheets tables. This eliminates the issue of lost styles and settings that users previously encountered.
The second major update is the support for pivot tables. Previously, imported pivot tables were converted into static data, stripping them of their dynamic capabilities. Now, Sheets preserves their functionality, allowing real-time data updates and changes.
Both features are already rolling out to users. No additional setup is required—updates are applied automatically. Full deployment may take up to 15 days. These improvements follow recent Sheets updates, including Gemini integration and 3D chart support.
Common questions
- What improvements have been made to Google Sheets for Excel imports?
- Sheets now preserves Excel table formatting and structure, and supports pivot table imports without losing functionality. Previously, pivot tables were converted into static data.
- Do users need to enable these new features manually?
- No, updates are applied automatically. All Google Workspace and personal account users will gain access to these features within 15 days.
- What other recent features have been added to Google Sheets?
- Recent additions include Gemini integration and support for importing 3D charts from Excel, expanding data analysis capabilities.
Dzen feed: /feed/dzen.xml · RSS: /feed.xml