How to Convert Excel to Notepad

While the Microsoft Excel is commonly used in business, it is not ubiquitous. Sometimes, users must convert the data in an Excel spreadsheet into a universally portable format that can be read by such simple text editors as Notepad. The way to do this is through the Tab Delimited Text save option.

African American businesswoman using computer.
credit: BraunS/iStock/Getty Images

Step

Open up an existing spreadsheet in Microsoft Excel 2007. If your spreadsheet has multiple sheets, activate the sheet you wish to convert.

Step

From the "Office" button, select "Save As" to open the Save As dialog box.

Step

Select "Text (Tab delimited)" from the Save As Type pull-down menu in the Save As dialog box.

Step

Click "OK" on the first dialog box warning, which advises that Text (Tab delimited) does not support multiple sheets.

Step

Click "Yes" on the second dialog box warning, which advises that the Text (Tab delimited) format does not preserve formatting and features of the spreadsheet.

Step

Check that your final conversion file is legible by opening Notepad and finding the .txt extension version of your Excel file.