Excel Showing Empty Cells When Importing File Created With Csv Module

I have a .csv with rows that are something like: 'Review',Clean Review 'The hotel _was, re3ally good',the hotel was really good but when I was open with excel 2013 the cells with

Solution 1:

The problem is in your CSV file. There is a CR after the w in Review. And Review is actually on the 2nd line of A1 (seen if you increase the height of row 1).

Here is an analysis of the characters at the beginning of your actual CSV with the character and the ASCII code. Note the 10 after the w

"              34 
R              82 
e              101 
v              118 
i              105 
e              101 
w              119     
               10 
"              34 

Solution 2:

Try

="Review",CleanReview="The hotel _was, re3ally good",the hotel was really good

This forces the value to be text and not something else. Haven't tried but theoretically should work.

Please check this and more solutions here