The TABLETOCSV() function converts values from a table into 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 LibreOffice Calc will automatically return the text in "csv" format:
=TABLETOCSV(Range)
We will have the following result:
This example uses the following values:
You can use the TABLETOCSV() function by installing the extension "YLC_Utilities.oxt" .
After that, this function will be available in all files that will be opened in LibreOffice Calc.