In this article, I will show you how to check the encoding of an Excel file. As we use Microsoft Excel regularly, we may need to check the underlying encoding of those Excel files. Knowing the encoding format of an Excel file allows us to have a deeper understanding of how Excel stores its data.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Step-by-Step Procedures to Check Encoding of Excel File
In this section, I will demonstrate how to check the encoding of an Excel file with 5 easy steps. To check the encoding of an Excel file, we need to see the file in XML format. An Excel file is actually a compacted form of multiple XML files that document every component and characteristic of that file in detail. In fact, an Excel file (.xlsx) has a folder structure and these folders have different files in them. These folders are compressed in ZIP format by Excel and then given the Excel file extension(.xlsx). To check the encoding of the file, we have to unzip the file first. To know more about the checking process in detail, follow the steps below:
Step-1 Changing the File Extension of the Excel File
- In the first step, we will rename the file extension of the Excel file as zip. To do that, first, select the Excel file in File Manager for which you want to check the encoding and select the Rename option.
- Then change the extension from .xlsx to .zip
- This has essentially converted the Excel file into a compressed zip file.
Step-2 Open the Zip File in Windows Explorer
- Now, we have to open the newly converted .zip file in Windows Explorer which is the default software for opening a compressed file.
- To do that, select the file and then right-click on the mouse, and then click on Open with > Windows Explorer.
- As a result, Windows Explorer will open the zipped
Step-3 Opening the Worksheets folder
- Now, first, go inside the xl From there, go to the worksheets folder.
- As a result, we will see that, for every sheet, there is a separate XML
Step-4 Opening the XML Files in Notepad
- Now, we will open the XML files in Notepad to check the encoding of the Excel file.
- To do that, select the sheet file you want to open and left-click on the mouse two times. Consequently, a window will open up asking how we want to open the file. Chose the Notepad
Step-5 Observing the First Line of the XML File
- After opening the file in Notepad, we need to look at the first line of the code.
- Here, we can see that the file is encoded in UTF-8.
- Similarly, we can check the other sheets encoding.
- After checking the encoding, we need to rename the file extension to .xlsx
Read More: How to Encode Data in Excel (with Easy Steps)
How to Change the Encoding of an Excel File
Sometimes we may find that some words in Excel are not showing properly. There are various reasons behind this problem but the major reason is the incorrect encoding of Excel files. In this section, I will show how to change the encoding of an Excel file.
- First, go to the File tab.
- Then, in the File tab, click on Save As.
- Now, choose the destination and formatting of the file.
- Now, on the Save As dialogue box, click on Tools and then choose Web options.
- Afterward, on the Web Options dialogue box, choose the Unicode (UTF-8) option from the dropdown menu under Save this document as. Then click OK.
- Finally, save the file by clicking on Save.
- Now, check if the file is displaying all the words properly or not. If this type of encoding doesn’t work, you have to try the other ones in a similar process until you get the desired result.
Read More: How to Apply UTF 8 Encoding on CSV File in Excel
Things to Remember
- You can use any 3rd party software apart from Windows Explorer to open the zip file.
That is the end of this article regarding how to check encoding of Excel file. If you find this article helpful, please share this with your friends. Moreover, do let us know if you have any further queries. Finally, please visit ExelDemy for more exciting articles on Excel.