I came across this issue the other day and after a lot of looking and wasting time finally found how to do this.
This post is to save time for other people in the future.
- Go to the Regional and Language Options in the control panel
- Under the Regional Options tab, click on ‘Customize’
- In the new window, there is a List separator option that has a comma, replace that by a pipe ‘|’ (or any other character of your choice)
- Click OK all the way out.
- Create a new Excel spreadsheet, or open an existing one.
- Click on save as, in the ‘Save as Type’ drop down menu, find the csv option and click ok.
- Open the file in wordpad/notepad and you’ll see that the file is now pipe delimited!
