QGIS 101: How to import Excel Data (No CSV files)

In this video I will show you how to prepare a properly formatted Excel file which you can drop into QGIS to make a map of point data. We will use some water well data from the Kharga Oasis in the Western Desert of Egypt, where I used to work. You will learn:
- tips and tricks of 'copy-paste'
- how to prepare a single title row
- Format the data as and Excel table & how to rename the table in Name Manager
- the importance of keeping data clean; don't mix numbers with text

We will import this data into QGIS without going via a CSV file & then you will learn:
- creating a points layer from table
- Editing point symbols & colours
- Adding labels and adjusting text buffer & placement
- Editing labels using the Expression Dialog
- Exporting point layer to GeoPackage
- Copying styles between layers
- Saving styles in GeoPackage

Source of data: Mustafa El-Rawy and Florimond De Smedt (2020): Estimation and Mapping of the Transmissivity of the Nubian Sandstone Aquifer in the Kharga Oasis, Egypt; Water 2020, 12, 604; doi:10.3390/w12020604

[chesko]

Thank you for this great video.
A short and less stressful way of getting the data into excel is to open excel, click on data, go to get data, then copy and paste the URL, select the table you need in this case table one and click load.

[bernsbuenaobra]

Wow, no steps needed for sometimes confusing step to convert the excel file to .csv. Too bad that newer versions of QGIS do not show a whole sheet but item by item now. Thanks.

[janawmm]

Thank you for the video. What can be my mistake if the points are not shown in the map at the end?

[leonardlange]

Hey, thank you for the video.
What doesnt work for me is the step "create points layer from table". I dont see any function to do that.
Can anyone help?

[hmichaelpower]

Thanks for the very clear and useful presentation

[parwizlalzada]

Thanks Mr.De Jong for a very useful video

[OlegLee]

Thank you very much for the useful video!