Question: how to convert excel to text file with pipe delimiter?
Answer: 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.