How to Save an Excel Spreadsheet As Pipe Delimited

As the name implies, Excel uses commas as the default value delimiter when saving a spreadsheet in the comma-separated values -- or CSV -- format. Set pipes as Excel's default value delimiter by editing your regional settings in Windows.

Edit Your Regional Settings

Step

Open the Windows Start Screen or Start Menu and type change date in the search box. Select Change Date, Time, or Number Formats from the search results list.

Search for "change date"
credit: Image courtesy of Microsoft
Click Additional Settings.
credit: Image courtesy of Microsoft

Step

Click the Additional Settings button to open the Customize Format window.

Enter a pipe symbol in the List Separator field.
credit: Image courtesy of Microsoft

Step

Enter a pipe symbol in the List Separator field and save your new settings by clicking Apply and OK.

Save the Spreadsheet

Step

Load the spreadsheet and select File from the Excel Ribbon.

Select File.
credit: Image courtesy of Microsoft
Select Save As.
credit: Image courtesy of Microsoft

Step

Select Save As from the sidebar.

Open the Save As Type menu and select CSV (Comma Delimited).
credit: Image courtesy of Microsoft

Step

Open the Save As Type menu and select CSV (Comma Delimited). Name your file and click the Save button.