Excel Does Not Parse Quoted String containing comma in CSV File Correctly

csvmicrosoft excelparsing

I have a CSV file that with quoted string that contains comma. When I open it in excel it still uses the comma inside the strings and parse it in different columns. Can someone help?

T7, 7, "331-8463 C - Ind. HT collar, laser HT insert, crown TR", 85, 0.37, N, 0.00, N
T7, 8, "331-8463 C - Ind. HT collar, laser HT insert, crown TR", 90, 0.33, N, 0.00, N

Simply create a CSV file with the above two lines and open it in Excel File.

Here is the result I get.

CSV Comma Parsing Issue

Best Answer

Remove the extraneous spaces and it'll work correctly:

T7,7,"331-8463 C - Ind. HT collar, laser HT insert, crown TR",85,0.37,N,0.00,N
T7,8,"331-8463 C - Ind. HT collar, laser HT insert, crown TR",90,0.33,N,0.00,N
Related Question