MC1508229 - Microsoft Excel: Changes to Get Data from Web (Legacy) experience

Microsoft 365 Message Center announcement MC1508229.

MS Message Center's Summary

Microsoft is retiring the legacy Get Data from Web experience in Excel between January and April 2027 in favour of an improved modern version. While existing legacy queries will continue to refresh, creating new legacy queries or editing them through the old dialog will no longer be possible. Administrators should update internal training materials and advise users to migrate active queries to the current web import workflow before the rollout completes.

Administrator impact
No direct administrator action is required.
End user impact
Users will no longer be able to create or edit legacy web queries through the old interface.
Importance
3/10: This is a planned feature retirement that requires updates to internal training but causes no disruption to existing data refreshes.

Microsoft Summary

Microsoft Excel will phase out the legacy Get Data from Web experience starting January 2027, encouraging use of the newer version with enhanced features. Existing legacy queries will still refresh, but new or edited legacy queries will be disabled. Users should update training and consider migrating queries to the new experience.

Message Center ID
MC1508229
Category
plan For Change
Severity
normal
Services
Microsoft 365 apps
Tags
User impact, Retirement
Published
2026-10-14
Last updated
2026-10-14
Expires
2027-06-05

[What and Why:] To import data from the web with Power Query, use the newer Get Data from Web experience. The existing Get Data from Web (Legacy) functionality will be reduced. The newer experience provides modern authentication, table detection, data transformation, and refresh capabilities. Existing queries that use the legacy experience will continue to refresh. [Rollout Schedule:] General Availability (Worldwide, GCC, GCC High, DoD): We will begin rolling out in mid-January 2027 and expect to complete by early April 2027. [Impact on Your Organization:] After this change: Users will no longer be able to create new legacy web queries with the dialog accessed through Get Data > Legacy Wizards > From Web (Legacy) or edit existing ones. Existing legacy web queries in workbooks will continue to refresh, and users can continue to edit refresh properties through Queries & Connections > Properties > Refresh control UI . Programmatic attempts to open the legacy New Web Query dialog will return an error. Programmatic attempts to create legacy Web Query connections will continue to work. Creating legacy Web Query connections through an .iqy file will continue to work. Other legacy data import wizards are not affected by this change. [Action Required/Recommendations:] You may want to update internal training and documentation because users will receive this change automatically as it progresses through deployment rings. Consider migrating web queries to the newer Get Data from Web experience: Right-click the section of imported data that you want to migrate. Select Edit query . Copy the URL from the address bar. From the Data tab, select From Web in the Get & Transform Data section. Paste the URL into the address bar and follow the steps to create the new web query. [Compliance considerations:] No compliance considerations identified. Review as appropriate for your organization.