TOP

TableToCsv Function

TABLETOCSV() Description

The TABLETOCSV() function is designed to convert values from a table into plain text format. It automatically converts data, separating it according to CSV extension standards.

This result allows you to easily export tabular information for further use in other programs or databases.


Main Characteristics of TABLETOCSV Function

Syntax:

=TABLETOCSV(Range)

Parameters:

Usage Example

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 the text in "csv" format:

=TABLETOCSV(Range)

We will have the following result:

Example of using TABLETOCSV() function
Example of using TABLETOCSV() function

The following values are used in this example:

Download Extension

You can use the TABLETOCSV() function by installing the YLC Utilities extension.

After that, this function will be available in all files that are opened in Excel (LibreOffice Calc).


This function is available in the following extensions: YLC LightYLC FunctionsYLC Utilities

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel