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 ?
0
give a positive ratinggive a negative rating
03 Nov 2019 at 04:05 PM
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
0
give a positive ratinggive a negative rating
16 Nov 2019 at 05:14 PM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
Follow us on Facebook
2022 AnswerTabsTermsContact us