14,958
edits
Troubleshooting of common Excel errors: Difference between revisions
Jump to navigation
Jump to search
m
→Resolving Excel File Save as CSV Causing Garbled Text
mNo edit summary |
|||
| Line 39: | Line 39: | ||
When saving Excel files containing text in other languages as CSV files, the content becomes garbled. | When saving Excel files containing text in other languages as CSV files, the content becomes garbled. | ||
'''Root cause''' | |||
Older versions of Excel only provide general CSV options when saving (defaulting to Big5 encoding), which is the main cause of garbled text. | |||
'''Solutions''' | '''Solutions''' | ||
* Upload the Excel file to [https://workspace.google.com/intl/zh-TW/products/sheets/ Google Sheets], then download as CSV file. CSV files exported from Google Sheets will be UTF-8 encoded, avoiding garbled text issues. | * Upload the Excel file to [https://workspace.google.com/intl/zh-TW/products/sheets/ Google Sheets], then download as CSV file. CSV files exported from Google Sheets will be UTF-8 encoded, avoiding garbled text issues. | ||
* | * Using newer versions of Excel (such as Office 365), and selecting the "CSV UTF-8 (Comma delimited) (.csv)" option when saving. | ||
== References == | == References == | ||