Click Don't Save on the message box that appears.

The Save As dialog box will appear again.

A message box stating that the csv file may contain features that are not compatible with CSV.

A message box may appear stating that the select file type does not support workbooks that contain multiple sheets.

On the Save As dialog box, click on the down arrow on the Save as type dropdown and select CSV (Comma Delimited) (*.csv).

Use the existing File name or enter a new one in the File Name dropdown.

Open an Excel spreadsheet or create a new one with data.

The Region and Languate dialog box will close.

Click Apply on the Region and Language dialog box.

The Customize Format dialog box will close.

Click on the List separator text box and change the ',' to a '|' (no quotes).

The Numbers tab (which is the default tab) contains a text box called List separator, which is set to a comma ','.

The Customize Format dialog box will appear.

The Region and Language dialog box will appear.

From the Start menu, Click Control Panel > All Control Panel Items > Region and Language.

Convert excel to pipe delimited text file