If you're doing this in excel and you're doing this for a 6xx device, look no further.
You want to build your forumulas with a line break and concatenate cells.
So for example if:
A2 = Address A3 = City A4 = Zip
You would build a forumula like this to construct the whole address as one for the csv. (Do all of this in an XLS and save it. Convert later.)
A5 looks like this: =concatenate(A2,CHAR(10),A3,", ",A4)
Then I like to make another worksheet that looks exactly what I want to save to a csv. I map the fields to another worksheet so I have something that I can save easily. I use the orignal worksheet to make modifications as necessary. Then the export worksheet is ready to go. I save as a CSV and give it a whirl.
This DOES work. I had to spend a lot of time figuring it out. The other things mentioned here (using <br>) didn't work.