CSV End of line

excel csv delimiter end-of-line
sanu picture sanu · Mar 8, 2017 · Viewed 24.7k times · Source

Hi i am trying to put end of line code in CSV format to import it to excel I tried putting
\n, "\n", \r, "\r", \r\n, "\r\n" but nothing worked for me I am trying to import it in excel 2013 my csv format is like below

Medicine;1213;22;19\nMedicine (miscellaneous);1013;32;55\nEngineering;708;14;21

please help. Field delimiter working fine but how to manage line break I want out put like this

Medicine                   | 1213 | 22 | 19   
Medicine (miscellaneous)   | 1013 | 32 | 55   
Engineering                | 708  | 14 |21

Thank you for your any help and suggestions

Answer

Tim Biegeleisen picture Tim Biegeleisen · Mar 8, 2017

In Notepad++ you can just do the following find and replace:

Find:

\\n

Replace:

\n

Be certain to do this in regex mode, not regular mode.

Related questions

Escaping quotes and delimiters in CSV files with Excel

I try to import a CSV file in Excel, using ; as delimiters, but some columns contains ; and/or quotes. My problem is : I can use double quotes to ignore the delimiters for a specific string, but if there is a …

Read More
Excel to CSV with UTF8 encoding

I have an Excel file that has some Spanish characters (tildes, etc.) that I need to convert to a CSV file to use as an import file. However, when I do Save As CSV it mangles the "special" Spanish characters …

Read More
Writing to an Excel spreadsheet

I am new to Python. I need to write some data from my program to a spreadsheet. I've searched online and there seem to be many packages available (xlwt, XlsXcessive, openpyxl). Others suggest to write to a .csv file (never …

Read More