14,958
edits
Troubleshooting of common Excel errors: Difference between revisions
Jump to navigation
Jump to search
→Resolving Excel File Save as CSV Causing Garbled Text
| Line 46: | Line 46: | ||
'''Solutions''' | '''Solutions''' | ||
There are three solution methods | |||
* 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 [https://zh-tw.libreoffice.org/ LibreOffice] to open the Excel file, then when saving the file, select "Text CSV (.csv)" format and choose the "Character set: Unicode (UTF-8)" option. | |||
* Using newer versions of Excel (such as Office 365), and selecting the "CSV UTF-8 (Comma delimited) (.csv)" option when saving. | * Using newer versions of Excel (such as Office 365), and selecting the "CSV UTF-8 (Comma delimited) (.csv)" option when saving. | ||
=== Resolving "Support 32767 characters in a cell only" Error When Exporting Database Data to Excel Files === | === Resolving "Support 32767 characters in a cell only" Error When Exporting Database Data to Excel Files === | ||