convert excel to pipe delimited text file

Information here may no longer be accurate, and links may no longer be available or reliable.Īssume a file named test.txt with a pipe-delimited Saves only the active sheet.This content has been archived, and is no longer maintained by Indiana University. Saves only the active sheet.ĭata Interchange Format. Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium. Saves a workbook as a tab-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves a workbook as a tab-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly.

Saves a workbook as a tab-delimited text file for use on another Microsoft Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. In the File name box, accept the suggested name or type a new name for the workbook. Note: The file formats you’ll see vary, depending on what type of sheet is active in your workbook (a worksheet, chart sheet, or other type of sheet).

Convert excel to pipe delimited text file