How in Excel to change the encoding. Three ways

Often, working with different files in the program"Excel", the user can face the fact that instead of intelligible letters there will be an incomprehensible font that can not be read. The fault is all the wrong encoding. In this article, we'll talk about how to change the encoding in Excel so that words can be read.

Method one: using Notepad ++

So it happened that to change the text encodingeasier in a third-party program, rather than in the "Excel". That's why we'll now look at a way how to change the encoding in Excel using Notepad ++.

So, in order to correctly follow all the steps, follow the instructions:

1. Run the program "Notd ++ ++".
2. Click the "File" button.
3. In the menu that appears, select "Open" (you can also do this by pressing CTRL + O).
4. In the Explorer window that appears, navigate to the desired file, the encoding in which is incorrect, and click the "Open" button.
5. In the opened file, click the "Encodings" button, which is located above the toolbar.
6. In the menu, select the item "Convert to utf-8", because this encoding program "Excel" perceives with a bang.
7. Click the "Save" button that is on the left side of the toolbar, and close the program window.

That's all, now you know how to change the encoding in Excel one way. Although it is the fastest, most convenient and easiest, but there are others that can not be silenced.

Method two: using the "Text Wizard"

Directly in the program Microsoft Excel itself there are also tools that will allow you to change the encoding. It is about this and will now be the speech, or rather, the "Master Text":

1. Open the Excel program. Note that you do not need to double-click on the file that is displayed incorrectly, but directly with the program with an empty sheet.
2. Go to the "Data" tab.
3. Click the "Receive external data" button, and from the drop-down menu select "From text".
4. In the Explorer window that appears, specify the path to the file that has encoding problems, and click the "Import" button.
5. Now the "Text Wizard" window will open directly. It needs to change the file format, that's why click on the drop-down list with the same name and select "Unicode (utf-8)" from there.
6. Click "Next".
7. The next window also skip, clicking the "Next" button, all the settings in it should be the default.
8. Now you need to determine the data format of the column of the file and, in accordance with it, select one of the items of the same name list. Click "Finish".

After all this, you must specify the very first cell, so that the data is placed at the beginning of the table.

How to change the encoding in Excel in the second way is understandable. We pass to the third.

Method three: preservation

How to change the encoding in Excel? To implement the third method, it is necessary to perform a number of the following actions:

1. Open the file in the program.
2. Click "File".
3. Select "Save As".
4. In the menu that appears, select the extension and click "Tools", from the drop-down menu - "Web document settings".
5. In the window that appears, go to the "Encoding" tab and select it from the "Save document as" list.
6. Click OK.

Now it only remains to specify the folder where the file will be saved. When you later open it, the text should be displayed correctly.