How to convert Excel to GIS data in QGIS using Spreadsheet Layers plugin
Let’s say you have some survey of Parks, and the data is in Excel format, for example, because it was done by non-GIS people. You need to take a quick look, to see if everything is correct, maybe even make a basic map, without creating more files, and leave it available for non-GIS people to edit. You can use the “Spreadsheet Layers” plugin to convert Excel to GIS in QGIS, creating spatial data from X and Y fields and even use some of the basic tools you could use in a shapefile for example. The advantages are that you don’t need to replicate the same data over and over again, and it’s more accessible to non-GIS folks.
Open an empty project. Click on Plugins menu, then Manage and Install Plugins…
Type “spreadsheet”, and install the plugin “Spreadsheet Layers”.
As you can see a new button is added to Add Layer toolbar.