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:
“Name”,”Country”
“Smith, John”,”UK”
If you replace all the commas with semi-colons, you will 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:
- Install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully fuctional free trial and you don’t have to give us your email or sign up to anything.
- Start Easy Data Transform.
- Drag the CSV file or Excel spreadsheet whose columns you wish to split onto Easy Data Transform. A pink input item will be added.
- Ensuring the pink input item is selected, click the To File button in the left pane (scroll to the bottom of the left pane).
- A window will appear. Choose the file name and location. Choose CSV file for the file type.
- An output item is now added.
- In the right pane select the new Delimiter. You can also change the CSV file Encoding. the CSV file is updated immediately, no need to ‘run’ anything.
As well as changing file format, Easy Data Transform also allows you to combine 42 transforms to quickly and easily create complex data transformations.
Windows Download
Mac Download