Line breaks in longtext: what is and isn't possible?

I’m looking for a reality check on whether I have understood the following.

It seems I can do these operations with line breaks/newlines:

  • Enter data containing line breaks in a longtext field

  • Display longtext data containing line breaks in a text widget in a card

  • Accept data containing line breaks in a longtext field in a form

  • Export data containing line breaks in a longtext field in an Excel file

But apparently I can’t do any of the following:

  • I can’t import text data containing line breaks in Excel (can’t import to longtext at all)

  • I can’t use a longtext field in a function and have line breaks persist (e.g., the CONCATENATE() function turns line breaks to spaces)

  • I can’t represent line breaks in a string literal (i.e., “\n” or some other common convention) (I guess this is a corollary to the above)

Did I get that right?

My use case: I have an urgent need to import legacy data containing line breaks. (I also would like to use functions to combine multiple form submission data fields into nicely formatted longtexts containing embedded blank lines, but that’s not mission critical.)

If there are any tricks to get around these limitations I’d love to hear about them. I’m investigating the General Caster integration. Are there others?