Function TABLETOCSV() converts values from a table to text in "csv" format.
=TABLETOCSV(Range)
The TABLETOCSV() function is easy to use. You just need to select a table or specify any range of cells with values and Excel (Calc) will automatically return text in "csv" format:
=TABLETOCSV(Range)
We will get the following result:
In this example, the following values are used:
You can use the function TABLETOCSV() by installing the extension YLC Utilities.
After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).