HOW TO EXPORT AN EXCEL FILE TO PIPE DELIMITED FILE RATHER THAN COMMA DELIMITED FILE

  
Windows 7 - Following to change the delimiter:

- Make sure Excel is closed
- Navigate to control panel
- Select ‘Region and Language’
- Click the ‘Additional Settings’ button
- Find the List separator and change it from a comma to your preferred delimiter such as a pipe (|).
- Click OK
- Click OK
- Exit Control panel
- Open the Excel file you want to export to a pipe delimited file
- Select File, Save As
- Change the ‘Save as type’ to ‘CSV (Comma delimited)(*.csv)’
- Change the name and file extension if you want, by default stays as csv even though a different delimiter
- Click Save
- Click OK
- Click Yes