Excel showing empty cells when importing file created with csv module

Question

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 the double quotes are showing empty on the sheet, and I can only see the text in the formula bar. Can anyone tell me why this is happening?

excel sheet kinda looks like:

|          |Clean Review|
|          |the hotel wa|

I have opened the .csv in notepad and there doesn't seem to be hidden characters causing this behavior

I used Python's csv module to create the .csv

it especially happens if you drag and expand the first column

I cannot reproduce your problem with the information you have provided. Can you upload a csv file that demonstrates the problem when opened in Excel? — Ron Rosenfeld
– Ron Rosenfeld, Commented Apr 23, 2017 at 20:21
@RonRosenfeld sure, what would be the best way to upload a file for you to download? — ragardner
– ragardner, Commented Apr 23, 2017 at 20:22
Use any of the various file-sharing sites. I've seen people use OneDrive, DropBox, and others; and edit your question to include the link. Make sure when YOU download the file from wherever you put it, that the problem is still reproduceable. — Ron Rosenfeld
– Ron Rosenfeld, Commented Apr 23, 2017 at 20:24
@RonRosenfeld if you're still interested I have uploaded the .csv, link in question — ragardner
– ragardner, Commented Apr 23, 2017 at 20:29
There is a carriage return character after the 'w'. Increase the height of row 1 and you will see it. — Ron Rosenfeld
– Ron Rosenfeld, Commented Apr 23, 2017 at 20:33

Ron Rosenfeld · Accepted Answer · 2017-04-23 20:59:46Z

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

edited Apr 23, 2017 at 20:59

answered Apr 23, 2017 at 20:54

Ron Rosenfeld

62k7 gold badges35 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:54:33Z

1

Try

="Review",Clean Review
="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

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Apr 23, 2017 at 20:19

norekhov

4,3881 gold badge32 silver badges48 bronze badges

Collectives™ on Stack Overflow

Excel showing empty cells when importing file created with csv module

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related