Fix XLSX to CSV Conversion and SYLK Format Errors
Question details
The user needs to resolve the "file cannot be loaded" or "not in SYLK format" error that appears when saving an XLSX workbook as CSV or reopening the CSV file.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is converting an XLSX workbook to CSV for data import or export and then reopening the CSV in a spreadsheet application.
- Observed behavior
- Excel reports that the file cannot be loaded or is not in SYLK format when saving or opening the CSV file.
Before converting, check whether the first cell in the CSV contains uppercase text such as "ID" and confirm which encoding option is available in your spreadsheet's save dialog.
Convert XLSX to CSV UTF-8 in WPS Office Spreadsheets
Use WPS Office to save the workbook as CSV UTF-8, which avoids the SYLK misinterpretation that can occur with older CSV encodings.
CSV UTF-8 preserves international characters and reduces the chance that Excel or another application will misread the file as SYLK format.
Launch WPS Office and open the affected .xlsx workbook in WPS Spreadsheets.
Click Menu > Save As and select CSV UTF-8 (Comma delimited) from the format list.
Choose a save location, enter a file name, and click Save.
Open the saved CSV in WPS Spreadsheets or import it to verify that columns and encoding are correct.

Adjust the first CSV value to prevent SYLK detection
Use this workaround when the CSV must remain compatible with Excel and the first cell begins with a SYLK-triggering value such as "ID".
Convert XLSX to CSV with WPS Office Without SYLK Errors
Use WPS Office to save XLSX workbooks as CSV UTF-8, preventing the SYLK format misinterpretation while keeping data clean and Excel-compatible.
- 1. Open the affected workbook: Launch WPS Office and open the .xlsx file in WPS Spreadsheets.
- 2. Choose CSV UTF-8 format: Click Menu > Save As and select CSV UTF-8 (Comma delimited) from the format list.
- 3. Save the converted file: Select a destination folder, name the file, and click Save.
- 4. Verify the CSV file: Reopen the CSV in WPS Spreadsheets to confirm that columns, delimiters, and encoding display correctly.

Frequently Asked Questions
Why does Excel show "not in SYLK format" when I open a CSV file?
Excel checks the beginning of a CSV file. If the file starts with certain uppercase text such as "ID", Excel may detect it as a SYLK-format file and refuse to open it.
How do I save an XLSX as CSV UTF-8 in WPS Office?
Open the workbook in WPS Spreadsheets, click Menu > Save As, choose CSV UTF-8 (Comma delimited), select a location, and click Save.
Does changing the first cell from "ID" prevent the SYLK error?
Yes. Renaming the first cell to something like "RecordID" or "Code" can stop Excel from misdetecting the CSV as SYLK format.
Can I reopen a CSV saved from WPS Office in Excel?
Yes. WPS Office saves standard CSV formats, including CSV UTF-8, so the file can be opened in Excel without losing data.
What is the difference between CSV and CSV UTF-8?
CSV UTF-8 uses Unicode encoding, which better preserves special characters and helps avoid encoding-related errors when reopening the file.




