SEARCH

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

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 08/3/08

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!