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.