Change CSV Column Separator

Tags:

Form for change CSV column separator

This form allows you replace CSV column separator to any custom, paste or upload your CSV file below:

browse fullscreen sample copy clear

Old CSV Separator:

New CSV Separator:

If the CSV separator can occur in the field between double quotes:

Your result can be seen below.

Result of replacing CSV column separator

download fullscreen copy clear

Move to "Paste Code" for Save it

About replacing CSV column delimiter

About replacement CSV column separator

The Change CSV Column Separator was created for online replacing columns separator in the CSV(Comma Separated Values) data. You can replace CSV column separators with any custom.

How it Works?

Just select the options you need and paste your CSV data to the textarea above and click to the button "Convert" and you will instantly get modified CSV.

Example of replacement CSV column delimiter

Before:

"LatD", "LatM", "LatS", "NS", "LonD", "LonM", "LonS", "EW", "City", "State"
   41,    5,   59, "N",     80,   39,    0, "W", "Youngstown", OH
   42,   52,   48, "N",     97,   23,   23, "W", "Yankton", SD
   46,   35,   59, "N",    120,   30,   36, "W", "Yakima", WA
   42,   16,   12, "N",     71,   48,    0, "W", "Worcester", MA
   43,   37,   48, "N",     89,   46,   11, "W", "Wisconsin Dells", WI

After replacement of the separator "," with ";" :

 "LatM"; "LatS"; "NS"; "LonD"; "LonM"; "LonS"; "EW"; "City"; "State"
    5;   59; "N";     80;   39;    0; "W"; "Youngstown"; OH
   52;   48; "N";     97;   23;   23; "W"; "Yankton"; SD
   35;   59; "N";    120;   30;   36; "W"; "Yakima"; WA
   16;   12; "N";     71;   48;    0; "W"; "Worcester"; MA
   37;   48; "N";     89;   46;   11; "W"; "Wisconsin Dells"; WI

After the conversion, you can apply your modified CSV to your project or use it for some other purpose.

Donate

Did you like this tool? You can donate to us. This will help us improve our free web tools.

Paypal

Tools