How to convert Excel to pipe delimited text file

Excel typically saves CSV files with using comma (,) or semi-colon (;) as the delimiter. However some programs expect a pipe (|) delimiter.

Trying to convert the delimiter of a CSV file using simple find and replace (e.g. in a text editor) is not advisable, because you might covert a delimiter character inside a value. For example a name value in a CSV file might include a comma:

"Smith, John","UK"

If you replace all the commas with pipes, you will get:

"Smith| John"|"UK"

Which means “Smith, John” has become “Smith| John”, which is almost certainly not what you want.

However it is very easy to convert an Excel file to pipe delimited in Easy Data Transform:

Auto run on

csv delimiter

csv file type

change csv delimiter character

change CSV delimiter

If you have a large number of files to convert you can do it using the batch processing feature.

As well as changing file format, Easy Data Transform also allows you to combine 66 transforms to quickly and easily create simple or complex data transformations.

change CSV delimiter

Try it free now!

Windows Logo Windows Download

v1.46.5 for Windows 11 / 10 / 8 / 7 (47 MB)
Zip file version

Apple Logo Mac Download

v1.46.5 for Mac 14.x to 10.13 (79 MB)

No commitments.
You can uninstall any time.
You don't even have to give us your email address.

Questions or problems?