CSV UTF 8 Not Available in Excel: 3 Solutions

Method 1 – Using Excel’s Save As Option


  • Go to the File tab.

Using Excel Save As Option

  • Choose the Save As option >> click the Browse button.

Browsing file location

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

Selecting Web options

  • Click on the Encoding tab >> Select Unicode (UTF-8) >> Hit OK.

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

Method 2 – Utilizing Notepad App


  • Navigate to the File tab >> Go to the Save As option >> Select Browse location as shown previously.
  • Select the CSV (Comma delimited) (*.csv) option >> Hit the Save button.

Utilizing Excel and Notepad

  • Right-click on the CSV file >> Open the file with Notepad.

Opening with Notepad

  • Use the CTRL + SHIFT + S shortcut to activate the Save As option.

  • Choose UTF-8 encoding >> Press the Save button.

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

Method 3 – Applying Text Import Wizard


  • 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

  • Locate the CSV file in the file explorer >> Click the Open button.

  • Select 65001 : Unicode (UTF-8) encoding in File Origin box >> Check My data has headers >> Press Next.

Using 65001 : Unicode (UTF-8) encoding

  • Check the Comma Delimiter >> Click on Next.

Choose Comma Delimiter

  • 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

You can see the steps of the Text Import Wizard in real-time in the GIF given below.

Text Import Wizard steps

How to Convert Excel to UTF-8 CSV Using Online Converter


  • Go to the Convertio website >> Click the Choose Files button.

How to Convert Excel to UTF-8 CSV Online

  • Upload the Excel file >> Choose the CSV format >> Hit the Convert button.

Uploading excel file and converting to CSV

  • Download the CSV file by clicking the Download button.

Download CSV file

How to Convert Excel to CSV UTF-8 with Preserving Special Characters


  • Jump to the File tab at the top left corner of the Home ribbon.

Move to File tab

  • Navigate to the Save As option >> Choose Browse.

  • Select CSV UTF-8 (Comma delimited) (*.csv) option >> Press the Save button.

Selecting CSV UTF 8 encoding

Open the CSV file to check for foreign symbols and characters.

Preserved Foreign symbols in the CSV file

We kipped some of the processes of converting an Excel file to CSV by saving it, which you may explore if you wish.

Download Practice Workbook

Related Article

<< Go Back to Excel Encoding | Excel Files | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF