What is UTF-8 and UTF-16 CSV?

UTF-8 is a more compact encoding since it uses 1 to 4 bytes for each symbol. Generally, this format is recommended if ASCII characters are most prevalent in your file because most such characters are stored in one byte each. Another advantage is that a UTF-8 file containing only ASCII characters has absolutely the same encoding as an ASCII file.

UTF-16 uses 2 to 4 bytes to store each symbol. However, a UTF-16 file does not always require more storage than UTF-8. For example, Japanese characters take 3 to 4 bytes in UTF-8 and 2 to 4 bytes in UTF-16. So, you may want to use UTF-16 if your Excel data contains any Asian characters, including Japanese, Chinese or Korean. A noticeable disadvantage of this format is that it’s not fully compatible with ASCII files and requires some Unicode-aware programs to display them. Please keep this in mind if you are going to import the resulting file somewhere outside of Excel.

Windows

If you are ready to convert XLS or XLSX files to create UTF-8 or UTF-16 CSV files on Windows. The primary choice would be Microsoft Excel. However, it is said that using Excel for exporting to CSV as it tends to create unreadable characters in CSV files. You can also use Notepad to add the .csv extension and save it as the format you want. what’s more, to save CSV file as UTF-8 encoded, you can upload the file on Google Drive and easily store it as UTF-8.

Mac

Excel for Mac does not natively support the import or export of UTF-8 encoded files, you cannot get off the ground the same way as what you di in Windows. Microsoft Excel for Mac cannot open a CSV file with UTF-8 characters. To make matters worse, if you put UTF-8 characters into an excel file and try to save it as CSV, it will generate garbage. It just won’t write the proper UTF-8 encoding into the file.

If you spend $20 to download Numbers from the Mac App Store, it turns out that Numbers handles the UTF-8 encoding just fine, but their implementation of reading CSV files in Numbers is buggy.

Fortunately, you can try this easy-to-use converter-XLS2csv. The spreadsheet tool can correctly change files in UTF-8, and it has all of the search and replace functions you need. With this handy desktop application, you can save hours of tedious manual file conversions.

How to create UTF-8 and UTF-16 CSV from XLS/XLSX by XLS2csv?

Step 1: Import your Excel file or a batch of files into this converter by clicking.



Step 2: Set your output directory to put your output in the right file.



Step 3: If you want to preview the convert effects, you can see it clearly



Step 4: In the Preview interface, there are “Sheet” and “Others” options for you, here is the sheet select setting:



Step 5: Clicking “others”, you can easily find the coding set, then you can feel free to choose UTF-8 or UTF-16, or any other codings here.



Step 6: The final step is to click the convert button, you can choose to convert one file at once or convert all files at one go.



Hopefully the above has given you an insight into the wonderful world of XLS2csv. Now download it and give it a try.



Also read
Mac batch convert XLS to CSV
How to convert a .xlsx file to .csv on Mac?
How to create border radius CSS code on Mac?
Can I batch convert XLS/XLSX to CSV in Mac?
Convert XLS to CSV on Mac without Excel installed
XLSX to CSV Converter for Mac (bulk conversion supported)
How to convert Excel spreadsheets to UTF-8 or UTF-16 CSV on Mac?