Change Excel's Field Separator to a Pipe Character
Question details
The user needs to import or export Excel data with a pipe or tab as the column delimiter.

- 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.
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.
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.
Open Control Panel, select Region, and click Additional settings.
On the Numbers tab, replace the List separator value with |, then click Apply and OK.
Close and reopen Excel, open the workbook, and select File > Save As. Choose a CSV file type and save the active sheet.
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.
Return to Control Panel > Region > Additional settings and restore the original List separator when you no longer need the pipe setting.

Import a pipe-delimited file using Excel's text import tools
Use this option to select the delimiter for an import without changing the Windows list separator.
Save an Excel sheet as tab-delimited text
Use this option when the external system requires tabs rather than pipes.
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.

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.




