Open and convert an Excel file in Notepad

Open and convert an Excel file in Notepad

If you try to open an xls file in notepad, the data will be mixed up and not make much sense. Which leads you to ask how you can open an xls file in notepad? In this guide, we will show you how to do just that.

How to open an Excel file in Notepad++?

  • You need to save your file in CSV format and then, afterwards open it via Notepad++++.
  • Open Notepad++, and change the file type of all and then browse to your file and open.

How to convert an Excel file to Notepad++?

  • Open your file in Excel.

  • From the Office tab, select Save As.,

  • In the new dialog box select Text and click OK. You will receive a warning that Text (Tab delimited) does not support multiple sheets. 

  • Click Yes.

  • You'll receive a warning that the Text format does not preserve formatting of the spreadsheet.

  • Click Save.

  • To check if you now can view the file in Notepad++, open Notepad and find your .txt file.

Do you need more help with excel? Check out our forum!