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 .
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.
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.
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:
- How to set the default font and font size on Excel
- 10 ways to recover corrupted Excel files
- Summary of expensive shortcuts in Microsoft Excel
I wish you all success!
You should read it
- Common causes of Excel workbook errors
- What is ### error in Excel? how to fix ### error in Excel
- Fix error when Excel file is minimized
- How to fix the SUM function doesn't add up in Excel
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
- Forgot password protected Excel file, what should you do?
- How to set the default font and font size on Excel
- Microsoft Excel test P5
May be interested
- Disable automatic updating of Adobe Reader DCadobe reader dc is set to automatically update (if your device is connected to the internet), to make sure that the updated version has cloud computing features and computer features, functionality is synchronization and compatibility.
- Complete guide Word 2016 (Part 1): Familiarize yourself with the Ribbon interfacemicrosoft word 2016 is a word processing application that allows you to create a variety of documents, including letters, resumes and many other document documents.
- Error correction 'The document is locked for editing by another user' when opening a Word documentin the process of opening any word document, you will receive an error message on the screen: 'the document file name is locked for editing by another user. Đang mở một đọc-chỉ bản của tập tin document, click ... '. where file name is the name of the document you are trying to open.
- How to write calligraphy for writing sentences, 2019 Tet wishestipsmake.com will guide you how to write calligraphy without error font to write spring sentences, tet greetings in calligraphy right on your computer is very simple, no need to install additional software at all.
- Instructions for dividing and merging columns on Google Docswhen working with the google docs online editing application, in addition to importing content, you sometimes need to perform table processing operations.
- How to convert PNG images to PDF filesthe need to convert files like doc, jpeg, .. to pdf files has become too common. in addition to the software installed, users can also use online support programs such as png2pdf.