Importing descriptions with line breaks

A line break in a description is a formatting element, just like bold, underlining, etc.
For the import process to correctly read this formatting element into a web application, it needs to be converted in html.
The html code for a line break is <br/>

If you work with Excel, converting the line breaks into the html tag because Excel has a formula to detect and replace line breaks with <br/>

Here are the detailed steps for you to follow to insert the html tag, so that you can import your descriptions with Store Commander.

There are 2 options: remove or keep the line breaks:

• To remove line breaks, use the Excel formula:
  =SUBSTITUTE(A1;CHAR(10);" ")
  

• To keep line breaks in html format, use the Excel formula:
  =SUBSTITUE(A1;CAR(10);"<br/>")

Here’s how to keep the line breaks.

The CSV file includes a description with line breaks in cell A2

In cell B2, insert the formula =SUBSTITUE(A1;CAR(10);"<br/>")

Copy cell B2 (where you added the formula)

In cell C2 right-click to choose Paste Special > Values

Delete columns A and B.
Only keep column C with the converted description that will be imported.

You can see the html codes corresponding to line breaks.

💡Tip: Open the CSV file in Notepad++ or in SublimText to verify whether there are carriage returns in the file.