Data Import & Export

Change Excel's Field Separator to a Pipe Character

Anum MushtaqAnum Mushtaq Nov 18, 2026 868 views

Question details

The user needs to import or export Excel data with a pipe or tab as the column delimiter.

Change Excel's Field Separator to a Pipe Character
Product
Microsoft Excel
Device & OS
Windows
Scenario
An external system requires a pipe-delimited or tab-delimited file.
Observed behavior
Excel may use the Windows regional list separator instead of the delimiter required by the external system.
Before you start

Check whether the receiving system requires a pipe or a tab, and confirm the expected file extension and encoding. Note the current Windows list separator so you can restore it afterward.

Solution 1Recommended

Set the Windows list separator to a pipe for Excel CSV export

Use this method when Excel's CSV export follows the Windows regional list separator.

1
Open regional settings

Open Control Panel, select Region, and click Additional settings.

2
Change the separator

On the Numbers tab, replace the List separator value with |, then click Apply and OK.

3
Restart and export

Close and reopen Excel, open the workbook, and select File > Save As. Choose a CSV file type and save the active sheet.

4
Verify the file

Open the exported file in a text editor and check that fields are separated by pipes. Confirm that the file extension and encoding meet the receiving system's requirements.

5
Restore the original setting

Return to Control Panel > Region > Additional settings and restore the original List separator when you no longer need the pipe setting.

Set the Windows list separator to a pipe for Excel CSV export
System-wide setting: The list separator can affect other applications as well as Excel. Some import and export tools use their own delimiter settings instead.
Free Microsoft Office alternative

Work with spreadsheet files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format support makes it easier to move existing files between applications. Changing Excel's Windows list separator still requires the Windows settings described above.

Open and edit spreadsheet data in WPS Spreadsheets.Work with Microsoft Excel formats, including XLSX and XLS.Use a familiar spreadsheet interface for a smoother transition from Excel.Get a free, lightweight office suite for everyday document work.
microsoft office alternative - wps office

Frequently Asked Questions

Where do I change the Windows list separator?

Open Control Panel > Region > Additional settings, then change List separator on the Numbers tab. Restart Excel before exporting again.

Can I import a pipe-delimited file without changing Windows settings?

Yes. In Excel, select Data > From Text/CSV, choose the file, and select the pipe character in the Delimiter menu before loading the data.

How do I export tabs instead of pipes?

Select File > Save As in Excel and choose Text (Tab delimited). Check the saved file's encoding against the receiving system's requirements.

Will changing the list separator affect other programs?

It can affect other applications that use the Windows regional setting. Restore the original value under Control Panel > Region > Additional settings after completing the export.

Does a CSV file always use commas?

No. Excel's CSV export may use the Windows list separator instead. Open the saved file in a text editor to verify the actual delimiter.