We’re excited to share the latest addition to Excel for the web: The ability to import and edit data using Power Query!
We’ve reached yet another milestone in Excel for the web: The full Power Query user experience is now generally available, including the import wizard and Power Query Editor.
After we released the ability to refresh Power Query data from authenticated data sources, we were able to unlock the ability to complete the full user journey of importing data and editing it using Power Query.
Getting started
Learn all about Power Query in Excel for the web here >
See this support article for more information on Power Query data sources in Excel versions.
Note:
Viewing and refreshing queries is available to all Microsoft 365 Subscribers.The full Power Query experience is available to all Microsoft 365 Subscribers with Business or Enterprise plans.
Importing data
You can import data into Excel using Power Query from a wide variety of data sources, for example: Excel Workbook, Text/CSV, XML, JSON, SQL Server Database, SharePoint Online List, OData, Blank Table, and Blank Query.
- Select Data > Get Data:
- In the Choose data source dialog box, select one of the available data sources:
- Connect to the data source.
- After you select the source, the authentication kind will be auto-populated, according to the relevant source (you can still change it, if you like).
- Press Next, and choose the table you wish to import:
- Press Transform data to open the table in the Power Query editor, where you can perform many powerful transformations.
Note: You can open the editor whenever you need it, by using Data > Get Data > Launch Power Query Editor.
- When you are done, load the table – press Close & Load to load to the Excel grid:
Or Close & Load to - to either load to the Excel grid, or create a connection-only query:
- See the query was created in the Queries & Connections pane:
If you loaded to a table, you can see it on the Excel grid: - You can refresh the created query from the Queries & Connections pane, or by using Data > Refresh/Refresh All.
You can also perform operations, such as editing the query (with the Power Query Editor), renaming it, and more:
What’s next?
Future plans include adding data sources and advanced features.
Feedback
We hope you like this new addition to Excel and we’d love to hear what you think about it!
Let us know by using the Feedback button in the top right corner in Excel - add #PowerQuery in your feedback so that we can find it easily.
Want to know more about Excel for the web? See What's new in Excel for the web and subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.
Jonathan Kahati, Gal Horowitz
~ Excel Team
Microsoft
