Google Sheets updates import feature for easier Excel file transfers

Google has enhanced its Sheets application with new features that simplify the process of importing Excel files. The updates, announced in a recent blog post, allow users to maintain the structure and formatting of their Excel documents when transferring them to Google Sheets. This change is effective immediately for all users, enhancing the overall user experience.

The improvements come as part of Google’s ongoing efforts to make Sheets more user-friendly and compatible with Microsoft Excel. Users have often faced challenges when importing Excel files, particularly in retaining complex elements like tables and pivot tables. Now, when an Excel file is imported, its tables will be converted into Sheets tables, preserving their formatting. This ensures that users do not lose any critical data structure during the transition.

Additionally, the new features include the ability to import pivot tables without losing their functionality. Previously, pivot tables were converted into static tables upon import, making it difficult for users to manipulate their data. The latest update allows users to retain the interactive features of pivot tables, enabling them to easily update and manage their data within Sheets. This improvement is set to roll out gradually, with full availability expected within the next 15 days.

These updates are significant for users who rely on both Google Sheets and Excel for their work. By streamlining the import process, Google is helping users save time and reduce frustration during data transfers. As businesses increasingly adopt cloud-based tools for collaboration, features like these will likely play a crucial role in encouraging users to switch from Excel to Google Sheets.