An upcoming feature for Copilot in Excel will let you bring in data from the web and other documents. The new feature is available to Microsoft 365 Insiders in the Beta Channel.

TL;DR Key Takeaways : Power Query in Excel simplifies importing, cleaning, and transforming external data, making it ready for analysis and insights.