Excel does not provide a native export function for this type of file. Therefore, you must change the Windows regional settings to save a file in pipe-delimited format.

A comma delimited file cannot process any information other than straight data. This means that if your Excel spreadsheet has formulas in it, only the formula result will be saved in the CSV file.