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.
Video of the Day
Edit Your Regional Settings
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.
Click the Additional Settings button to open the Customize Format window.
Enter a pipe symbol in the List Separator field and save your new settings by clicking Apply and OK.
Save the Spreadsheet
Load the spreadsheet and select File from the Excel Ribbon.
Select Save As from the sidebar.
Open the Save As Type menu and select CSV (Comma Delimited). Name your file and click the Save button.