Subscribe to How-To Geek

Convert An Excel Spreadsheet To A Tab Delimited Text File

When it comes to the business world and office documents, there are tons of file formats, extensions, and associations to be considered.  When Adobe came out with the PDF format it was to be the “standard” and even that can be sometimes be difficult when dealing with conversion for different tasks and software utilities.

One problem that occurs in desktop publishing is being able to convert data from one program to another.  This is where converting data into a text or Tab Delimited file comes in handy.  You will lose color and font formatting, but you will have the proper data arranged in columns and rows that will make it much easier to manipulate in another program.

233

Click the Office Button and choose Save As \ Other Formats.

1

Now just select the save as type menu item Text (Tab delimited) (*.txt) and a location

2

The resulting text file can then be opened and used in basically any office or desktop publishing application you choose.

3

| More
This article was originally written on 08/3/08 Tagged with: Office, Windows

Daily Email Updates

You can get our how-to articles in your inbox each day for free. Just enter your name and email below:


Name:
Email:

Leave a Comment




Leave your friendly comment here.

If you have a computer help question, click here to leave it on the forums instead.

Note: Your comment may not show up immediately on the site.