Google Sheets now plays more nicely with your imported Excel spreadsheets

Google Sheets has implemented several enhancements to improve compatibility with imported Excel spreadsheets. Now, users can effortlessly drag and drop rows or columns within pivot tables, while the data hierarchy remains intact even when moving items with nested child elements.

Additionally, Google Sheets has ensured that custom-sorted pivot tables retain their sorting order when importing Excel spreadsheets. Previously, Sheets would revert pivot tables to a standard alphanumeric sort order upon import, but this issue has been resolved. Users can now seamlessly transfer custom sorting preferences between the two applications, facilitating a smoother workflow.

Furthermore, Google has maintained the exact sorting order of pivot tables when exporting a Sheets file to an Excel spreadsheet. This feature ensures that the pivot table arrangement remains consistent across both platforms, allowing users to effortlessly navigate between Google Sheets and Excel without losing any formatting or sorting preferences.