Excel Export CSV Pipe Delimited: Steps and Options

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, you can export a pipe-delimited file by temporarily changing Windows’ list separator to a vertical bar (|), then saving the active worksheet as a CSV file. Excel does not provide a separate “pipe” choice in its Save As dialog, so check the exported file before sending it.

What “pipe-delimited CSV” means

A delimited text file stores fields in a row with a chosen character between them. A comma-delimited row might look like R41,West,23; the pipe-delimited equivalent is R41|West|23. The vertical bar is also called a pipe. The term “CSV” is often used loosely for delimited text, but it technically means comma-separated values. A file with pipes is more precisely pipe-delimited text, even if it has a .csv extension because a receiving system requires that name.

There is no universal rule that every .csv file must use commas. What matters for a data exchange is that the file’s actual delimiter, encoding, quoting rules, and file extension match what the receiving application expects. If a system specifically requests pipe-delimited data, a comma-separated file renamed to .csv is not enough; the separators inside the file must be pipes.

Export a pipe-delimited file in Excel for Windows

Excel’s CSV export follows the Windows list-separator setting in many desktop configurations. Set that separator to a pipe, save the worksheet, and then restore the original setting so other applications continue to use their normal delimiter.

  1. Save a copy of your workbook first. CSV export keeps only the active worksheet, not every sheet in the workbook.
  2. Close Excel. In Windows, open Control Panel, choose Clock and Region, then Region, and select Additional settings…. On the Numbers tab, change List separator to |. The exact Control Panel labels can vary slightly by Windows release.
  3. Reopen Excel and the workbook. Select the worksheet you want to export, then choose File > Save As > Browse.
  4. In Save as type, choose CSV UTF-8 (Comma delimited) (*.csv) if it is available, enter a filename, and select Save. Although the format name says “Comma delimited,” the output delimiter can follow the Windows list-separator setting. Confirm the file’s contents rather than relying on the label.
  5. If Excel warns that only the active sheet can be saved or that some workbook features are not supported, accept the warning only if that is what you intend. Reopen the saved file in a text editor and confirm that fields are separated by pipes.
  6. Close Excel, return to the same Windows List separator setting, and put back the original character. Reopen Excel afterward.

Windows’ list separator is a system-level preference, not a setting confined to one workbook. Changing it can affect how other programs display or interpret lists. Record the original value before editing it, and restore it promptly. If your Excel installation does not use the changed separator, do not assume that the export succeeded: inspect the result and use another export method.

What Excel puts in the exported file

CSV-style export writes the contents of the selected worksheet as text. It does not preserve the workbook’s formulas as working formulas, formatting, charts, multiple sheets, filters, or other Excel features. Formula cells are generally exported as their calculated results. That makes this format suitable for transferring a table, but not for archiving a workbook that must remain editable in Excel.

Delimited files also need a way to represent a field that contains the delimiter itself. A correctly quoted field can contain a pipe without splitting into two columns. For example, a row might contain 17|"North|East"|Open. Quotes inside a quoted field are typically doubled, and a field containing a line break may also need quotes. A recipient that does not support standard text-file quoting may interpret such records differently, so check its import requirements.

Pay attention to values Excel may reinterpret when the file is opened. Product codes such as 00127 can lose leading zeros if imported as numbers; dates and long numeric identifiers can also be converted or displayed unexpectedly. Format identifiers as text before entering or importing them, and ask the destination system how it expects dates, decimals, and blank fields to be represented.

Check the delimiter, encoding, and rows

Do not verify a pipe-delimited export by opening it in Excel alone. Excel may parse a text file into columns based on the current regional settings, which can make a wrong delimiter look plausible or a correct file look like one long column. Open the file in a plain-text editor, or use the destination application’s import preview, and inspect several records.

  • Confirm that a typical row has pipes between fields and no unintended commas acting as separators.
  • Check a row with a blank cell, a value containing a pipe, a quotation mark, or a line break.
  • Compare the number and order of fields with the source worksheet, including the header row if the recipient expects one.
  • Check non-English characters. Choosing CSV UTF-8 can help preserve them, but confirm the receiving system supports UTF-8.
  • Verify that the file contains the intended sheet and that the last expected row is present.

Alternatives when changing Windows settings is not suitable

If you cannot change a shared computer’s regional settings, or the export must be repeatable, use a tool that explicitly lets you select a pipe as the delimiter. A data-transfer utility, a script designed to write delimited text, or the receiving system’s own export tool may provide that control. For dependable results, choose an option that correctly quotes fields containing pipes, quotation marks, or line breaks; replacing every comma in a regular CSV with a pipe is not safe because commas can be part of the data.

You can also construct text by joining cells with a pipe, but a simple join is not a general-purpose CSV exporter. It will not automatically handle embedded pipes, quotes, newlines, dates, or other formatting consistently. For a small, controlled table whose values contain none of those characters, a manual text-building approach may be adequate; for data exchange, use a proper delimited-text writer and test its output.

Excel for the web does not provide a custom pipe-delimiter choice in its normal download options. Downloading a CSV there should not be treated as a pipe export. On a Mac, the Windows Control Panel route does not apply; CSV delimiter behavior can depend on macOS regional settings and the Excel version. Check a small test export on the target Mac, or use a tool with an explicit delimiter setting if you need predictable output across computers.

Common problems and how to avoid them

The file still has commas. Excel may not have picked up the changed setting, the setting may not have been applied, or that export path may behave differently in your configuration. Close and reopen Excel after changing the separator, export a small test, and inspect it in a text editor. Do not send the file based only on the Save As format name.

Everything appears in one column when opened. That does not necessarily mean the file is broken. The application opening it may be configured to expect commas or tabs. Use its import controls to specify a pipe, or inspect the raw text to see which character actually separates the fields.

Some rows have extra columns. Look for unquoted pipe characters inside cell values. A plain text replacement can introduce this problem, as can a recipient that fails to honor quotes. Test records with unusual values and agree on a quoting convention with the receiving system.

Other programs now use unexpected separators. Restore the original Windows list separator. The setting can affect more than Excel, which is why a temporary change should not be left in place without a reason.

Frequently Asked Questions

Can I choose pipe directly in Excel’s Save As menu?
No. Excel’s standard Save As options do not offer a general custom-delimiter selector for CSV. On Windows, changing the list separator is a common workaround; otherwise use a tool that explicitly exports pipe-delimited text.

Is a pipe-delimited file still a CSV?
People often call any delimited text file a CSV, but a pipe-separated file is not comma-separated in the literal sense. Follow the receiving system’s specification for the delimiter and extension; it may require a .csv filename even when the contents use pipes.

Will exporting as CSV include every worksheet?
No. Excel’s CSV export saves the active worksheet, not the full workbook. Export each required sheet separately or choose a format that preserves multiple sheets if the recipient needs them.

Can I just replace commas with pipes?
Not safely in a normal CSV file. A comma may occur inside a cell, and quoted fields can contain commas, quotes, or line breaks. A basic replacement can change the data rather than just the separators. Use a CSV-aware conversion tool or export from the source with the correct delimiter.

How do I import a pipe-delimited file back into Excel?
Use Excel’s text import tools and specify the pipe as the delimiter rather than opening the file and relying on automatic detection. In Microsoft 365 for Windows, you can start from Data > From Text/CSV, select the file, and check the delimiter in the preview before loading it.

Choosing the right approach

For a one-time export on a Windows computer you control, changing the list separator, saving the active sheet as CSV UTF-8, checking the text, and restoring the setting is a practical route. For recurring transfers, shared machines, or files with complicated text values, prefer a process with an explicit delimiter setting and well-defined quoting. In either case, confirm the output against the recipient’s specification before treating the file as ready to import.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.