Separate data values with Commas or Semicolons in CSV - Excel

What should I do to separate text values, that include Commas in case of comma delimited CSV or Semicolons in case of semicolon delimited CSV ? How to split text values or numbers with commas or semicolons, to keep the content appearing in correct column in Excel ?
posted on 03.11.2019 at 16:05
0pnshow more
aticatic
Hi,

To separate text content, that includes commas in case of comma separated CSV file, or that includes semicolons in case of semicolon separated CSV file, you have to add double quotes before and after this content. The presence of double quotes will split text values correctly, and will keep them appearing in relevant columns.

Comma separated CSV should look like:
A,B,C
1,"2,5",5

Semicolon separated CSV should look like:
A;B;C
"1;7";1;7
posted on 16.11.2019 at 17:14
0pnshow more
TimTim
share on facebookshare on twitter
2020 AnswerTabsTermsContact us
This site uses cookies to improve your experience, for analytics and ads. By continuing to browse this site you agree to our use of cookies.