Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I use row delimiter other than \n?

CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter.

I'm using Excel 2010, and in need to convert that CSV file to Excel format.

If it can't be done with Excel then is there any other software which allows you to do so?

So far I've tried Excel, Open Office, and CSVed.

share|improve this question
would you mind, showing a line of your csv and to what you would want to change that. Because, right now, I would just suggest you open this with an text-editor and replace \n\n\n\n with ; or whatever. – Jook Nov 8 '12 at 8:26

First I need to be honest - I have close links with the author of this software, having had quite some involvement in its development (ideas, testing etc.). I have been busted for over promotion already, but in my defense I used to constantly fight with Excel and now I use Ron's Editor daily.

As I said I use something called Ron's Editor a lot and I know it lets you change the line break format for cells and rows. However it lets you change them to other line break formats and from your question it is not clear if that is what you need.

Once you have the file as you want it in Ron's Editor it will correctly export the CSV file to Excel, without mucking up the formatting etc.

I hope that helps.

share|improve this answer

Your Answer


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.