How to Change Encoding in Excel -3 Methods



This is the sample dataset.

How to Change Encoding in Excel Dataset

Method 1 – Changing the Encoding by using the Web Options in Excel


  • Select the File tab.

Change Encoding Through Web Options in Excel

  • Choose Options.

  • In Advanced, choose General
  • Click Web Options to change the encoding.

  • A dialog box will open.

Change Encoding in Excel Dialog Box

  • In Save this document as, change the encoding and click OK.

  • Click OK again.

  • The encoding of your Excel file is changed.

Read More: How to Apply UTF 8 Encoding on CSV File in Excel

Method 2 – Using the Text Import Wizard to Change the Encoding

This is the sample dataset.

Text File to Change Encoding in Excel


  • Go to the Data tab and select From Text.

Use Text Import Wizard for Changing Encoding

  • Select the text file and click Import.

  • Select the encoding from File Origin and click Load.

This is the output.

Method 3 – Changing the Encoding While Saving the Excel File


  • Go to the File tab.

Change Encoding while Saving Excel File

  • In Save As, select More Options.

  • In Tools, choose Web Options.

  • In Encoding, select the encoding.

  • Click Save.

  • This is the output.

Read More: How to Check Encoding of Excel File

Download Practice Workbook

Download the workbook here.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan
Mehedi Hasan

Mehedi Hasan, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a profound passion for research and innovation, he actively engages with Excel. In his capacity, Mehedi not only adeptly tackles intricate challenges but also showcases enthusiasm and expertise in navigating tough situations with finesse, underscoring his unwavering dedication to consistently delivering exceptional and high-quality content. He... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF