Hello Alison

Regrettably, presently, we lack a straightforward solution for conveying new lines or line breaks when linking a table to a source Spreadsheet/CSV/Excel. Any formatting applied to the source cannot be transferred to the table through this method.

Adding HTML <br> tag in the source sheet cells can do the trick.

The only alternative workaround involves utilizing Conditional Formatting, although it is a more intricate solution.

Here's a method for creating values in cells that span multiple lines without the need for <br> tags:

If you structure cell values as demonstrated in this example:

And then, if you make conditional rules, like this :

This prompts the plugin to examine each cell value for the specified content as we articulate them. If a match is found, the plugin will incorporate <br> to facilitate a new line within the table cells. The outcome is as follows:

This workaround enables filter values in the select box without <br> tags and allows column cells in the table to span multiple lines. However, its effectiveness depends on the nature of the content added to the source sheet by those editing it.

While suitable for a limited set of values, it becomes less practical for extensive text requiring numerous new lines. In such cases, the Conditional Rules workaround proves more challenging than manually inputting <br> tags.

Regrettably, at present, this represents the optimal solution for creating new lines in linked tables, as no better or simpler alternatives are available.

If you want to try a completely different approach, you can try to import the initial data ( from CSV/Excel/Google Sheet) to make a new Manual Table, or make a new Manual Table from scratch, and use a 'multi-line String' Column with a 'multi-line Editor' input type.

( * Important note, if you do that, the table loses the connection with the source Sheet/file, so any editing you make on the source will not reflect the table, but it is fully editable in our plugin)

Subsequently, you can embed this table on a front-end page, providing users with the capability for front-end editing. It functions as a multi-line editor, enabling users to create new lines effortlessly by pressing "Shift+Enter," eliminating the need for <br> tags.

You can also limit Editing to only specific user roles on your WordPress, in the table Editing tab/Editing roles.

Currently, these are the available methods I can think of. If you have any suggestions for future improvements, please don't hesitate to explore and share your ideas on our suggestions page.