In the Get & Transform data group, click From Table/Range. That’s all there is to it. Figure A shows the data in Power Query. ... How to load the Power Query data into Microsoft Excel.

Learn how Power Query can boost your Excel skills with tips to clean, transform, and analyze data faster and more efficiently ...

Excel’s new Get Data preview improves Power Query with a modern layout, search, and OneLake catalog access in Version 2505.