Spreadsheet Layers
Plugin ID: 766
Load layers from spreadsheet files (*.ods, *.xls, *.xlsx)
(498) votes
This plugin adds a "Add spreadsheet layer" entry in "Layer" / "Add new Layer" menu and a corresponding button in the "Layers" toolbar.
These two links open the same dialog to load a layer from a spreadsheet file (*.ods, *.xls, *.xlsx) with some options (use header at first line, ignore some rows and optionally load geometry from x and y fields).
When this dialog is accepted, it creates a new GDAL VRT file in same folder as the source data file and layer name, expanded with a .vrt suffix which is loaded into QGIS using OGR VRT driver.
When reusing the same file twice, the dialog loads its values from the existing .vrt file.
No need to install additional dependencies.