How to Convert Excel to a Delimited Text File

Excel to Text - How to Convert Excel to a Delimited Text File 3

Converting an Excel spreadsheet to a text-based file can reduce the size and in some cases, might be easier to manage.

Fortunately, you can convert your Excel file into a text file where each cell is delimited by a tab. 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.

Launch Excel - How to Convert Excel to a Delimited Text File 5

2. Go to File.

File - How to Convert Excel to a Delimited Text File 7

3. Click Save as and then Browse. In older versions, you may have to choose Other Formats.

Advertisement
Save as Browse - How to Convert Excel to a Delimited Text File 9

4. On the file type, select Text (Tab delimited) option. Next, click Save.

Save Text Tab delimited - How to Convert Excel to a Delimited Text File 11

5. The delimited text format would look like this.

Excel to Text - How to Convert Excel to a Delimited Text File 13

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 default 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.

Advertisement

Leave a Comment

Your email address will not be published.