Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have created a very simple spreadsheet of 3 columns with about 5 rows of data (as a test). When I download it as a CSV it comes out all in one line; I would expect each row to be a separate line. How can I achieve this?

If I populate the first 3 columns and first 4 rows I would expect this (and get it from Excel) when opened in a text editor (e.g. Notepad):

a,b,c
hi,how,are
you,doing,today
i,like,kittens

Instead, I get this:

a,b,chi,how,areyou,doing,todayi,like,kittens
share|improve this question
    
What are you using to open (or view) the downloaded CSV with? It opens just fine in EXCEL 2010 and it opens in notepad as expected all on one line. –  William Jun 26 '13 at 14:36
    
Why on earth would all on one line be "as expected"? It wasn't all one line in the spreadsheet. Even Excel saves out a csv on multiple lines. (example moved to question, comments dont allow line breaks) –  Paul Jun 27 '13 at 10:50

1 Answer 1

up vote 2 down vote accepted

I just did a test myself, and can see what you're seeing.

The problem isn't with Google or the download. The problem is that Windows (and thus Notepad) expects to see both a carriage return character (ASCII 13) and a linefeed character (ASCII 10) to indicate the end of the line. The CSV generated by Google Docs only uses the linefeed character so, to Notepad, there's no indication where the line ends.

Excel is different and can recognize the linefeed as the end of the line, which is why it opens there just fine. Note, though, that if you use Excel for Windows to create a CSV file, it will use a carriage return and linefeed at the end of each line.

In order to see the CSV file in the way you expect, you need to use a text editor/viewer that's smarter about linefeeds without carriage returns. Notepad++ is the one I use, but there are a plethora of Notepad replacements out there.

share|improve this answer
    
Sigh, that is very awkward –  Paul Jul 4 '13 at 9:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.