How to format a pipe delimited file in excel

A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.

About Us Our team. Save an Excel file as pipe delimited file Save an Excel file as pipe delimited file To save an Excel workbook as a pipe delimited file, please do as follows. See screenshot: 3. See screenshot: 5. See screenshot: 7. In the Save As window, you need to: 7. See screenshot: 8. Read More Free Download You are guest Login Now. Loading comment The comment will be refreshed after To post as a guest, your comment is unpublished.

Hi vivek, This has been successfully tested in Excel , and I have a couple files that have to be exported to a 3rd party as pipe-delimited, but usually I need the files to be comma-delimited. Unfortunately, I haven't found a way to give both options. I would say be careful with this. On my system it worked as intended, but unintentionally it prevented excel functions with commas from working. When a comma is part of data, make sure to enclose the word in a double inverted comma, else Microsoft Excel will treat it as a separate character.

You can use other characters as a delimiter to avoid this issue like PIPE or any other character available on the keyboard but which is not part of the data. The method is the same for other delimiters as well. Excel opens TextImport Wizard as shown below. Excel TextImport Wizard is intelligent enough to understand that data is Delimited and provides default options. You can choose the file type is it is not correct as below.

Choose if you want to import at row number and File Origin. Select My data has headers if your file has a header. Click the Next button. Excel recognizes the data format but if you want, you can select each column one by one and choose the data format. You can also choose not to import that column. Click on a finish to import pipe-delimited file. This will open a delimited file in Microsoft Excel.