[Fixed!] CSV UTF 8 Not Available in Excel

Get FREE Advanced Excel Exercises with Solutions!

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.

Dataset for csv utf 8 not available in excel

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.

📌 Steps:

  • In the first place, go to the File tab.

Using Excel Save As Option

  • Next, choose the Save As option >> click the Browse button.

Browsing file location

  • Then, choose the CSV (Comma delimited) (*.csv) option >> click on Tools drop-down >> move to Web Options.

Selecting Web options

  • Later, click on the Encoding tab >> select Unicode (UTF-8) >> hit OK.

Fixing csv utf 8 not available in excel with Save As option

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.

📌 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.

Utilizing Excel and Notepad

  • Third, Right-click on the CSV file >> open the file with Notepad.

Opening with Notepad

  • Fourth, use the CTRL + SHIFT + S shortcut to activate the Save As option.

  • Lastly, choose UTF-8 encoding >> press the Save button.

fixing csv utf 8 not available in excel with Excel and Notepad options

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.

📌 Steps:

  • 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.

Applying Text Import Wizard

  • 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.

Using 65001 : Unicode (UTF-8) encoding

  • Afterward, check the Comma Delimiter >> then click on Next.

Choose Comma Delimiter

  • Eventually, hit the Finish button to complete the process >> apply the CTRL + S to save the CSV file.

Fixing csv utf 8 not available in excel with Text Import wizard

Here, you can see the steps of the Text Import wizard in real time in the GIF given below.

Text Import Wizard steps

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.

📌 Steps:

  • At the very beginning, go to the Convertio website >> click the Choose Files button.

How to Convert Excel to UTF-8 CSV Online

  • Now, upload the Excel file >> choose the CSV format >> hit the Convert button.

Uploading excel file and converting to CSV

  • Lastly, download the CSV file by clicking the Download button.

Download CSV file


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.

Dataset for How to Convert Excel to CSV UTF-8 (Preserving Special Characters)

📌 Steps:

  • To begin with, jump to the File tab at the top left corner of the Home Ribbon.

Move to File tab

  • At this point, navigate to the Save As option >> choose Browse.

  • Later, select CSV UTF-8 (Comma delimited) (*.csv) option >> press the Save button.

Selecting CSV UTF 8 encoding

Consequently, open the CSV file to check for foreign symbols and characters.

Preserved Foreign symbols in the CSV file

Admittedly, I have skipped some of the processes of Converting an Excel file to CSV, which you may explore if you wish.


Practice Section

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.

Practice Section for csv utf 8 not available in excel


Conclusion

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.


Related Articles

Eshrak Kader

Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo