Search form

MS Power Query

Power Query
Koen Timmers
by Koen Timmers
Educator - Author - Keynote speaker - Global Teacher Prize 2017 finalist

Making data meaningful: importing data via MS Power Query to Excel

Big data is a broad term for data sets so large or complex that traditional data processing applications are inadequate.

The Microsoft Power Query for Excel allows to import large amounts of data provided by external sources like Wikipedia.

Navigate to

Select a language and hit the button Download.

Select the 32 or 64-bit version and hit Next.

Open the downloaded file.

Hit Next.

Check "I accept the terms…" and hit Next.

Hit Next, Install and Finish.

Open Excel and notice the new tab "Power Query".

Click the option Data Catalog Search.

Enter a query in the right sidebar.

Example "medals olympics".

Several kind of search results are offered. The majority by Wikipedia.

Double click at the desired results. The data will be imported and soon appear in your Excel sheet.

Some other examples:

"Most common display resolutions"

"Oil production by country"

"List of countries by number of (mobile phones)"

Save your Excel document (on your computer or on OneDrive).


Learn how Power BI will bring life into these data

© - Part of, by Koen Timmers - Alle rechten voorbehouden