Question: how to convert excel data to pipe delimited text file?
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.