In editing Excel file from Configuration Package, Excel is necessary. Other office application like Google Spreadsheet, LibreOffice Calc, or else cannot edit the file. Cannot edit was too much. Those apps can edit, but not enough for the exported file.
LibreOffice can edit the exported file.
After editing the file, other office apps, Google Spreadsheet, LibreOffice Calc, or etc., delete XML map from the Excel workbook. Excel for Web cannot even open the exported files from Configration Package.
1) LibreOffice (v7.4)
The file can be imported into Business Central.
2) Google Spreadsheet
Google Spreadsheet can also edit the file, but saves it as .xlsm format. So Configuration Package rejects the file because of the extension is wrong.
What if change the file extension from .xlsm to .xlsx?
The same error as LibreOffice comes out.
In order to edit Configration Package file, at least one Excel app is necessary.
If you believe Google Spreadsheet is enough, get good support from a solution partner for Business Central.