How to change CSV delimiter

CSV files typically use commas to separate column values (hence Comma Separated Values). But sometimes they use other characters, including: semi-colons (;), pipes (|) and tabs. So it is sometimes necessary to change the delimiter, for example when another tool expects a particular character delimiter.

Trying to convert the delimiter 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:

"Name","Country"
"Smith, John","UK"


If you replace all the commas with semi-colons, you get:

"Name";"Country"
"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 the change the CSV delimiter of CSV or Excel files in Easy Data Transform:

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 CSV delimiter, Easy Data Transform also allows you to combine 56 transforms to quickly and easily create complex data transformations.

CSV to HTML converter

Try it free now!

Windows Logo Windows Download

v1.22.0 for Windows 11 / 10 / 8 / 7 (38 MB)

Apple Logo Mac Download

v1.22.0 for Mac 12.x to 10.13 (38 MB)


Questions or problems?

Email support@easydatatransform.com