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

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+

  • Published 08/3/08

Enter Your Email Here to Get Access for Free:

Go check your email!