Use power query in excel to import data into excel from a wide variety of popular data sources, including csv, xml, json, pdf, sharepoint, sql, and more. Using microsoft query, you can connect to external data sources, select data from those external sources, import that data into your worksheet, and refresh the data as needed to keep your รขโ‚ฌยฆ View and analyze excel xlsx and xls files directly in your browser.

In this video, we will look at how to download an excel or csv file with direct link into excel power query.