CSV files typically use commas to separate column values (hence Comma Separated Values). But sometimes they use other characters, such as 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:
If you replace all the commas with semi-colons, you will get:
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:
As well as changing file format, Easy Data Transform also allows you to combine 38 transforms to quickly and easily create complex data transformations.
v1.1.0 for Windows 10 / 8 / 7 (22 MB)
v1.1.0 for Mac 10.15 to 10.12 (21 MB)
Questions or problems?