Hi, Manuel 

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

Unfortunately, at this time we don't have an easy solution to make new lines when a table is linked to a Spreadsheet/CSV/Excel.

Any formatting we set on the source can not be passed to the table in that way.

-

1.  As you know, adding HTML <br> tag in the source sheet cells can do the trick.

2.

The only other workaround can be by using Conditional Formatting, but it is a more complex solution.

Here is how we can make the values in the cells go into multiple lines;  without having to use any <br> tags.

-

if you create values for cells like this example :

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

This will make the plugin check, if any cell value is containing those values as we write them > Then it will add <br> to them , to make them go in new lines in the table cells, this is the result:

So, with this kind of a workaround, you would be able to get filter values in the selectbox without <br> tags, and at the same time, you can get column cells in the table, to go multiple lines.

-

But, it depends on exactly what kind of content the persons editing the source sheet will be adding to the table.

This workaround is only useful if we have only several possible values,

but if you have some long text and it needs a lot of new lines,  in that case, the Conditional Rules workaround is just more difficult , compared to inputting <br> tags.

-

At this time that is the best we can do, unfortunately there are no better / easier solutions for making new lines for linked tables.

-

3.

Or If you want to try a completely different approach,

you can try to import the initial Google Spreadsheet data to make a new Manual Table,

or make a new Manual Table from scratch, and use a multi-line String Column and 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)

Then, you could place this table on a front-end page,

where users can do front-end editing of this table as a multi-line editor,  they can hit "shift+Enter" for new lines without need of <br> tags.

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

Here is my Video example of how that might look 

https://watch.screencastify.com/v/9TlJL2zPdmkskEw6Y09I

For the time being, these are all the available methods i can think of,

but if you have any suggestion for future improvements,

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.