I need to import a xls / xlsx / ods into QGIS. But while the first row (field names) of my XLSX in LibreOffice shows up on the first place as it should, QGIS shows the first row on place 452! As you can see in the screenshot below. I imported the XLSX to QGIS simply by drag'n'drop.
This issue seems to be very strange, because every program I tried, finds the row with field names on the first place! Also saving the XLSX to CSV results in the expected order: first row = field names (second screenshot). I tried saving and copying in all directions and variants - but QGIS still don't finds the field names on row 1.
- I can not go for csv or any other format (just for testing)
- the imported table need to be editable in QGIS.
- The plugin "spreadsheet layers" is also not helping, because it uses virtual tables.
- I can't share the data because there is a copyright.