How to fix Vietnamese error when opening CSV file in Excel

In the process of working with Excel data files, due to the need to export or import data in the database, you often have to convert Excel content into a CSV file. However, a common situation is that Vietnamese fonts will be corrupted, because the open file does not use UTF-8 encoding. So how can I fix the Excel font error when you convert to a CSV file?

The workaround of this problem is that you will use the import data feature available in Excel. We will not need to install any other application or fix software. You can apply for both Excel and Windows versions. The following article will work with Excel on Mac.

Step 1:

You open the Excel file on your computer. At the main interface, we will switch to the Data tab .

How to fix Vietnamese error when opening CSV file in Excel Picture 1

Step 2:

Next we will click Import data from text file. Soon the Text Import Wizad dialog box appears. We look down at the items below, you will select the Delimited partition. Next to the File origin section is UTF-8 . Click Next to proceed to the next step.

How to fix Vietnamese error when opening CSV file in Excel Picture 2

Step 3:

In the new Delimiters dialog box interface, readers will uncheck the Tab option and check the Comma option . This will set up in Excel with the case of comma separated files that will separate the column.

Finally, click Next at the bottom of the interface, select the cell to display data or leave it as default and click OK to save the changes.

How to fix Vietnamese error when opening CSV file in Excel Picture 3

Above is how to fix Vietnamese font error when we open CSV file in Excel. After editing, we will not see an error as before. Pretty fast and simple when using the Excel file right away ?!

Refer to the following articles:

  1. How to set the default font and font size on Excel
  1. 10 ways to recover corrupted Excel files
  1. Summary of expensive shortcuts in Microsoft Excel

I wish you all success!

3.9 ★ | 86 Vote

May be interested

  • How to fix the error can not save Excel fileHow to fix the error can not save Excel file
    how to fix the error can not save excel file. in some cases, you can open a spreadsheet directly on outlook, or open a file as read only; you can edit the file, but when saving the file, excel will alert you with the following content:
  • Fixed an error when opening DWG files in CorelDRAWFixed an error when opening DWG files in CorelDRAW
    dwg is a graphic file format on auto cad used for design and errors when opening dwg files in coreldraw also occur quite often, mainly for those who want to convert to coreldraw before printing.
  • Instructions for inserting a PDF file into Excel spreadsheetInstructions for inserting a PDF file into Excel spreadsheet
    if you're having trouble inserting a pdf file into an excel spreadsheet and you don't know how to do it. inserting pdf files into excel spreadsheets is not as simple as you think. in the article below, network administrator will guide you through the steps to insert a pdf file into excel spreadsheet.
  • Corrupted Excel file and the most effective way to recover Excel files!Corrupted Excel file and the most effective way to recover Excel files!
    repair, recover corrupted excel file most effectively, with extremely high success rate. share professional excel, word file format recovery software ..
  • 5 nightmares for Excel and how to fix it5 nightmares for Excel and how to fix it
    we will show you how to handle multiple workbooks effectively, speed up heavy files, track changes from multiple users, find the required features in a multitude of ribbons and import data one by one. easy way.
  • How to fix errors not typing Vietnamese on ViberHow to fix errors not typing Vietnamese on Viber
    error typing vietnamese on viber or other chat applications will affect messaging, chatting with friends. so what is the fix for vietnamese typing error on viber?
  • Fix the error Unikey can't type VietnameseFix the error Unikey can't type Vietnamese
    unikey when typing vietnamese when using vietnamese keyboard, is a mistake many users still encounter. this error causes many difficulties for users in their daily work. so the cause of unikey error does not type vietnamese with the mark of where and how to fix this unikey? please follow the following article of network administrator to find solutions when you cannot type vietnamese on unikey.
  • What is ### error in Excel? how to fix ### error in ExcelWhat is ### error in Excel? how to fix ### error in Excel
    ### in excel is an error that excel frequently encounters and appears in many different cases when we enter data in excel, functions in excel, enter formulas in excel or when displaying results.
  • How to fix We Found a Problem With Some Content error in ExcelHow to fix We Found a Problem With Some Content error in Excel
    the we found a problem with some content error in excel often appears when there is incompatibility or error right from the excel file you are opening.
  • Fix the error 'File Error: data may have been lost' in ExcelFix the error 'File Error: data may have been lost' in Excel
    in some cases when using excel users often encounter many errors, in which the most serious error is data loss - file error: data may have been lost.