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.