“`html

Published: 2025/11/25 04:35:58

Excel’s new Get Data Dialog: A Streamlined Data import experience

Microsoft is rolling out a redesigned “Get Data” dialog in Excel for Windows, aiming to simplify and streamline the process of importing data from various sources. This update introduces a more modern interface and a more intuitive workflow for connecting to data, making it easier for users to bring external details into their spreadsheets. While the classic method isn’t disappearing immediately, the new dialog represents a significant step towards a more user-friendly Excel experience.

What’s New in the Get Data Dialog?

The updated “Get Data” dialog focuses on a cleaner, more focused experience. Rather of the traditional categorized dropdown menus, the new dialog presents a simplified interface with prominent search functionality and commonly used data sources readily available. This allows users to quickly find and connect to the data they need without navigating through multiple layers of menus.

Key Improvements:

• simplified Interface: A cleaner design reduces clutter and focuses on essential options.
• Enhanced Search: A robust search bar allows users to quickly locate specific data sources.
• Modern Design: The new dialog aligns with Microsoft’s current design language, providing a more consistent user experience.

How to Access the New Get Data Dialog

The new “get Data” dialog is currently being rolled out to Microsoft 365 subscribers using Excel for Windows. To access the preview, you need to be running Version 2509 Build 16.0.19328.20000 or later. You can check your Excel version by going to File > Account > About Excel.

Still Have Options: Classic Get Data Remains Available

For users who prefer the familiar interface, Microsoft hasn’t removed the classic “Get Data” options. You can still access the traditional dropdown categories on the Data tab alongside the new preview dialog. this provides a transition period for users to adapt to the new experience at their own pace.

supported Data Sources

the new “Get Data” dialog supports a wide range of data sources, including:

• Files: Excel workbooks, CSV files, text files, and more.
• Databases: SQL server, Access, Oracle, and other database systems.
• Online Services: SharePoint,Dynamics 365,Salesforce,and other cloud-based services.
• Web: Data from websites and web apis.

FAQ

Is the new Get Data dialog available on all platforms?

Currently, the new dialog is only available for Microsoft 365 subscribers using Excel for Windows. Microsoft has not yet announced plans for a rollout to other platforms, such as Excel for Mac or Excel online.

Will the classic Get Data dialog be removed eventually?

While Microsoft hasn’t provided a specific timeline, it’s likely that the classic dialog will eventually be phased out as users become more familiar with the new experience. Though, Microsoft is committed to providing a smooth transition for its users.

How do I update Excel to the latest version?

If you have a Microsoft 365 subscription, Excel should update automatically. You can also manually check for updates by going to File > Account > Update Options > Update Now.

key Takeaways

• Microsoft is introducing a redesigned “Get data” dialog in Excel for Windows.
• The new dialog offers a simplified interface,enhanced search,and a modern design.
• The classic “Get Data” options remain available for users who prefer them.
• The update is rolling out to Microsoft 365 subscribers running Version 2509 Build 16.0.19328.20000 or later.

This update to the “Get