Change the delimiter character in Excel 2013/2016 to use a pipe character instead of a comma for saved CSV files by modifying the system's regional settings in the Windows Control…
Learn how to easily paste comma-separated values into an Excel 2013 file without creating a temporary CSV file"Please let me know if any further modification needed on above output.