Converting an Excel spreadsheet to a text-based file can reduce the size and could be potentially easier to manage in some situations.
Fortunately, you can convert your Excel file into a text file where each cell is delimited by a tab. The process doesn’t involve any third-party software or addons. This converting feature is available on all modern Microsoft Excel versions, ranging from Excel 2007 to Excel 365.
Here’s how to export spreadsheets to a TXT file.
How to convert Excel to text
1. Launch the spreadsheet you want to convert.
2. Go to File.
3. Click Save as and then Browse. In older versions, you may have to choose Other Formats.
4. On the file type, select Text (Tab delimited) option. Next, click Save.
5. The delimited text format would look like this.
It looks in a way similar to Excel where each cell is separated by a line, but in this case, separated by a tab. The file was converted to TXT format where bundled apps like Notepad should be able to render it.
Working with Excel? Why not take some rest by creating an 8-bit art using Microsoft Excel in this article.
