---

Go back to the main page
Go back to the Excel overview page

---

Excel Data Import

Exercises

---

Exercise 1

Load the following datasets in Excel using the csv import functionality (Power Query). First have a look at them in your text editor.
Then load in Excel.

• file 1
• file 2
• file 3
• file 4

Report the field separator.

Exercise 2

Load the Heart Disease Health Indicators Dataset dataset in Excel using the csv import tool (Power Query).

Exercise 3

Load the Properties of ATC accepted medicines dataset in Excel using the csv import tool (Power Query).

Exercise 4

Load the food-allergens-and-allergies dataset in Excel using the csv import tool (Power Query).

Exercise 5

Load the Beta-Lactamase dataset in Excel using the csv import tool (Power Query). This dataset contains several csv files. Just use the first (CHEMBL1989.csv)

Exercise 6

Load the SARS-CoV-2 Genetics dataset in Excel using the csv import tool (Power Query). There are two separate csv files. Load both in the same Excel file (albeit at different worksheets).

You can try to load more data from the datasets web page. Alternatively, you can search for more datasets on Kaggle, KDnuggets or other dataset repositories.

Exercise 7

The zip file in this link contains 25 small exercises to load data in Excel.
Unpack the zip file and import the files using Power Query.
Hint: first inspect the file using a text editor.
Check for the following:

• What column delimiter is used?
• Are there top rows to be removed?
• What decimal separator is used?
• Are there missing data? Replace to NA.
• Are column names present? If not, add them during loading in PowerQuery. You can take the column names from another file in the series.

Load the files using PowerQuery and do not modify the csv files from within a text editor!

---

Go back to the main page
Go back to the Excel overview page
⬆️ Back to Top

---

This web page is distributed under the terms of the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited. Creative Commons License: CC BY-SA 4.0.