I need to export gpkg layer contained Cyrillic characters to a spreadsheet, e.g. csv file. I do that using Export -> Save Features As and pick UTF-8 encoding. I tried encodings: Cyrillic, different UTF's but nothing works. Just UTF 16LE keeps very few Cyrillic words. I also tried to find encoding in Advanced Settings according to an answer from here but it is not available in QGIS 3.16: Does anyone know how to fix?
I tried it and indeed, exporting to CSV does not preserve the cyrillic characters. But when you export in QGIS from geopackage to MS Office Open XML table, the characters are kept: see my screenshot with (left) the attribute table in QGIS and (right) the exported Excel file opened in Excel.
When I export this file again from Excel to CSV, again the cyrillic characters are not preserved. See below the screenshot for this. But as I understand you, you need any file format that you can use in Excel, so exporting to another format should work fine.
This here explains the problem with using CSV for cyrillic characters and how to solve it: https://stackoverflow.com/a/12097021/13651925
As it is an old answer, here is a screenshot with a current Excel version and a test for the CSV exported from QGIS, including the import dialog as well as the result: it works! Open an empty file, go to
import from text, select the saved csv and set UTF-8 (if not already selected). See screenshot with changed names for the numbers ;-)