spreadsheets

This would occur if the spreadsheet's or database's CSV (comma separated values) parser is substandard. Excel comes with an excellent CSV parser that knows how to deal with hard returns (aka line breaks, paragraph markers, etc.) that are embedded within the contents of a field.