Have you ever faced a situation where you cannot encode a CSV file in the UTF-8 format, and you’re not sure how to fix it? Then, this article can help you solve the problem because we’ll explore 3 fixes when CSV UTF 8 is Not Available in Excel. In addition, we’ll also learn to convert CSV UTF 8 online and preserve special characters.
Download Practice Workbook
3 Solutions to Fix If CSV File in UTF 8 Format Is Not Available in Excel
First of all, let’s assume the Project Checklist dataset shown in the B4:C13 cells, which contains a list of “Tasks” and their “Status” respectively. Here, we want to convert this Excel file to CSV UTF-8 format, henceforth, without further delay, let’s see each solution in detail and with necessary illustrations.
Here, we have used the Microsoft Excel 365 version; you may use any other version according to your convenience.
1. Using Excel’s Save As Option
First and foremost, let’s begin with a simple workaround that involves using the Save As option in Excel.
- Next, choose the Save As option >> click the Browse button.
- Then, choose the CSV (Comma delimited) (*.csv) option >> click on Tools drop-down >> move to Web Options.
- Later, click on the Encoding tab >> select Unicode (UTF-8) >> hit OK.
Read More: How to Encode Data in Excel (with Easy Steps)
2. Utilizing Notepad App
Alternatively, we can also employ the Notepad application to encode CSV files in UTF-8 format. It’s simple and easy, just follow the steps.
- First, navigate to the File tab >> go to the Save As option >> select Browse location as shown previously.
- Second, elect the CSV (Comma delimited) (*.csv) option >> hit the Save button.
- Third, Right-click on the CSV file >> open the file with Notepad.
- Fourth, use the CTRL + SHIFT + S shortcut to activate the Save As option.
- Lastly, choose UTF-8 encoding >> press the Save button.
Read More: How to Change Encoding in Excel (3 Suitable Methods)
3. Applying Text Import Wizard
Conversely, Excel’s Text Import wizard can also apply UTF-8 encoding to a CSV file. Therefore, let’s see it in action.
- Initially, open Microsoft Excel >> proceed to the Data tab >> click the Get Data drop-down >> in the Legacy Wizards, select the From Text (Legacy) option.
- Following this, locate the CSV file in the file explorer >> click the Open button.
- Not long after, select 65001 : Unicode (UTF-8) encoding >> check My data has headers >> press Next.
- Afterward, check the Comma Delimiter >> then click on Next.
- Eventually, hit the Finish button to complete the process >> apply the CTRL + S to save the CSV file.
Here, you can see the steps of the Text Import wizard in real time in the GIF given below.
Read More: How to Check Encoding of Excel File (With Easy Steps)
How to Convert Excel to UTF-8 CSV Using Online Converter
For one thing, we can also convert an Excel file to CSV UTF-8 online, so just follow along.
- At the very beginning, go to the Convertio website >> click the Choose Files button.
- Now, upload the Excel file >> choose the CSV format >> hit the Convert button.
- Lastly, download the CSV file by clicking the Download button.
How to Convert Excel to CSV UTF-8 with Preserving Special Characters
Last but not least, we can preserve any foreign symbols or characters when converting from Excel to CSV by choosing the UTF-8 encoding. In this case, let’s consider the List of Currency and Symbols dataset shown in the B4:C11 cells which displays a list of “Currency” and their “Symbols” respectively.
- To begin with, jump to the File tab at the top left corner of the Home Ribbon.
- At this point, navigate to the Save As option >> choose Browse.
- Later, select CSV UTF-8 (Comma delimited) (*.csv) option >> press the Save button.
Consequently, open the CSV file to check for foreign symbols and characters.
Admittedly, I have skipped some of the processes of Converting an Excel file to CSV, which you may explore if you wish.
We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.
This article describes some quick and easy fixes when CSV UTF 8 is Not Available in Excel. Now, we hope you find it useful and will share your thoughts in the comments section. And visit ExcelDemy for more articles like this.