I am working on a project with an attribute table of approx. 5,564,098 rows. I've tried exporting it to Excel using the "save as" CSV or XLS but the data keeps getting cut off. I would ideally like to combine some of the data so that the attribute table is not so large, and I think I could do that either in QGIS or Excel (if I could manage to download the whole table).
The data is % vegetation type (from the Oregon Statewide Habitat Map) within buffer zones surrounding 860 points. There are 75 different vegetation types that I would like to condense into approximately 30 general categories. Does anyone know either how I could do that within QGIS or how I could export a really large attribute table into Excel?
The .xls file format has a limit of 65,536 rows in each sheet, while the .xlsx file format has a limit of 1,048,576 rows per sheet.Please Edit your Question to state how many rows you are trying to export.
ogr2ogr -f "XLSX" "/home/bera/Desktop/GIStest/output_excel.xlsx" "/home/bera/Drives/data1/data/LMV/a_very_large_shapefile.shp"