I am preparing a course for QGIS newbies, which includes handling Excel spreadsheet data in QGIS.
It's so easy: Just drag an XLS, XSLX or CSV from Windows Explorer to QGIS!
For data with no coordinates, I teach them 1:1 joins to shape files to obtain positions, e.g. a place name. For data with coordinate attributes in the CSV, I teach them how to use the "Add Delimited Text Layer" function, and the same goes for Excel XLS files using XY Tools plugin.
The problem is XLSX files, which can easily be dragged and dropped into QGIS and displayed as attributes. But I haven't found a way to plot points from (correct) coordinate information - without previous conversion to XLS or CSV. I would like the operation to be smooth and inviting for the QGIS newcomers.
Question: How can you drag-drop an Excel XLSX file and plot the coordinates using the fewest steps?